Showing 1-30 of 235 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
77340 | 2015-06-12 22:34 | 2015-12-18 10:58 | MySQL Server: Optimizer | Verified (3023 days) | S3 | 5.6.25, 5.7.7 | Any | Any | Optimizer chooses wrong index for LEFT JOIN query |
78612 | 2015-09-28 22:46 | 2022-11-12 22:13 | MySQL Server: Optimizer | Verified (3102 days) | S3 | 5.5.45, 5.6.26, 5.7.8,5.5.47, 5.6.28,5.7.10 | Any | Any | Optimizer chooses wrong index for ORDER BY |
93606 | 2018-12-14 7:53 | 2021-11-23 15:30 | MySQL Server: Optimizer | Verified (1904 days) | S2 | 5.6.40,5.7.24 | CentOS (6.9) | x86 | when use Connector/J preparestatement mysql returns the wrong result |
95776 | 2019-06-13 2:34 | 2019-06-13 5:38 | MySQL Server: Optimizer | Verified (1750 days) | S3 | 5.7.15-log MySQL Community Server (GPL), 5.6.44, 5.7.26, 8.0.16 | CentOS | Any | About FUNCTION STDDEV_SAMP:Data only in different order |
104978 | 2021-09-17 19:57 | 2021-09-20 9:02 | MySQL Server: Optimizer | Verified (920 days) | S5 | 8.0.26, 5.7.35 | Windows | Any | Adding Join Index forces query optimizer to use inefficient execution plan |
103296 | 2021-04-13 5:35 | 2021-04-13 6:01 | MySQL Server: Optimizer | Verified (1080 days) | S3 | 8.0.22, 5.7.33, 8.0.23 | Any | Any | Aggregate function group by primary key/non-primary key has differnet result |
108233 | 2022-08-23 6:43 | 2022-08-23 7:53 | MySQL Server: Optimizer | Verified (583 days) | S3 | 5.7.39, 8.0.30 | Any | Any | Alias displayed incorrectly with "Use temporary" |
88671 | 2017-11-28 0:16 | 2017-12-04 15:41 | MySQL Server: Optimizer | Verified (2306 days) | S5 | 5.7.19 | Any | Any | ALL + BNL chosen over REF in query plan with a simple SELECT + JOIN |
88181 | 2017-10-23 5:30 | 2018-06-11 19:55 | MySQL Server: Optimizer | Verified (2348 days) | S3 | 5.7.20 | Any | Any | Another example of optimizer choosing ref over range when range is faster |
76604 | 2015-04-07 4:29 | 2015-04-07 6:15 | MySQL Server: Optimizer | Verified (3278 days) | S3 | 5.6.23, 5.6.24, 5.6.25, 5.7.8 | Linux (CentOS 7) | Any | Assertion `length > 0 && keyparts != 0' failed in create_ref_for_key |
111918 | 2023-07-30 6:12 | 2023-07-31 6:33 | MySQL Server: Optimizer | Verified (241 days) | S3 | 8.1.0, 8.0.34, 5.7.43 | Ubuntu (22.04) | x86 (x86_64) | Auto increment column query wrong result |
104421 | 2021-07-26 19:58 | 2021-07-29 7:07 | MySQL Server: Optimizer | Verified (973 days) | S2 | 8.0.26, 5.7.35 | Any | Any | Bad plan for WHERE customer_id = @cid ORDER BY id LIMIT 10 with compound PK. |
92850 | 2018-10-19 0:46 | 2018-10-22 5:31 | MySQL Server: Optimizer | Verified (1984 days) | S3 | 5.7.23 | Any | Any | Bad select+order by+limit performance in 5.7 |
98647 | 2020-02-18 13:06 | 2020-02-18 14:03 | MySQL Server: Optimizer | Verified (1500 days) | S3 | 5.7.29 | Windows | x86 | Bad SUM result with GROUP BY |
99130 | 2020-03-31 12:18 | 2020-04-01 13:10 | MySQL Server: Optimizer | Verified (1458 days) | S3 | 8.0.19,5.6.47, 5.7.29 | Any | Any | BETWEEN malfunctions when comparing a string containing a newline |
99135 | 2020-03-31 16:54 | 2020-04-01 5:11 | MySQL Server: Optimizer | Verified (1457 days) | S3 | 8.0.19, 5.6.47, 5.7.29 | Any | Any | BETWEEN malfunctions when comparing large numbers |
102911 | 2021-03-10 23:49 | 2021-03-12 6:09 | MySQL Server: Optimizer | Verified (1113 days) | S2 | 5.7, 8.0, 5.7.33, 8.0.23 | Any | Any | BETWEEN SQL-query on auto-incremented primary key field gives the incorrect resu |
86973 | 2017-07-06 13:26 | 2017-07-07 7:19 | MySQL Server: Optimizer | Verified (2456 days) | S1 | 5.6, 5.5.56, 5.6.36, 5.7.18 | Any | Any | BIN() function error |
97339 | 2019-10-23 8:06 | 2021-07-23 13:05 | MySQL Server: Optimizer | Verified (1612 days) | S2 | 5.7.18, 5.7.28, 5.6.46 | Any | Any | bin() function return Incorrect result set |
110587 | 2023-04-03 7:51 | 2023-04-03 9:37 | MySQL Server: Optimizer | Verified (360 days) | S1 | 8.0.27, 8.0.32, 5.7.41 | Any | Any | Bit with index range query may produce different results |
97648 | 2019-11-14 20:25 | 2019-11-19 14:48 | MySQL Server: Optimizer | Verified (1592 days) | S3 | 5.7, 8.0 | Any | Any | Bug in order by clause in union clause |
103632 | 2021-05-08 12:23 | 2022-08-13 16:23 | MySQL Server: Optimizer | Verified (593 days) | S2 | 8.0.23, 8.0.24, 5.7.34 | Any (Windows, Ubuntu) | Any | Can't write; duplicate key in table |
92466 | 2018-09-17 16:05 | 2018-09-18 9:14 | MySQL Server: Optimizer | Verified (2018 days) | S3 | 5.7.22, 5.7.23, 8.0.12 | Any | Any | Case function error on randomly generated values |
99146 | 2020-04-01 9:49 | 2020-04-01 10:42 | MySQL Server: Optimizer | Verified (1457 days) | S3 | 8.0.19, 5.7.29 | Any | Any | Comparison on FLOAT column and large value malfunctions |
80224 | 2016-02-01 19:13 | 2016-02-15 9:00 | MySQL Server: Optimizer | Verified (2964 days) | S3 | 5.5.46, 5.6.28, 5.7.11 | Any | Any | CONCAT_WS duplication of arguments when used in conjunction with HAVING |
87915 | 2017-09-29 13:47 | 2018-04-27 14:20 | MySQL Server: Optimizer | Verified (2162 days) | S3 | 5.7.18/trunk | Any | Any | Constant in multi-byte character fails to propagate to dependent subquery |
106264 | 2022-01-24 16:33 | 2022-01-25 15:07 | MySQL Server: Optimizer | Verified (793 days) | S2 | 5.7 | Any | Any | Contribution by Tencent: Prevent badly stale rec_per_key for query optimization |
111466 | 2023-06-16 19:18 | 2023-06-17 7:45 | MySQL Server: Optimizer | Verified (285 days) | S3 | 5.7 | Any | Any | Contribution: Disable index hints on spatial indices |
105143 | 2021-10-05 22:01 | 2021-10-06 6:16 | MySQL Server: Optimizer | Verified (904 days) | S3 | 8.0, 5.7 | Any | Any | Contribution: Fixed scientific notation bug |
90043 | 2018-03-13 8:53 | 2019-02-18 16:43 | MySQL Server: Optimizer | Verified (2206 days) | S3 | 5.6, 5.7 | Linux | Any | convert_tz doesn't handle offset more than 13 hours |
Showing 1-30 of 235 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |