« Show Previous 30 Entries | Showing 31-60 of 735 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
88181 | 2017-10-23 5:30 | 2018-06-11 19:55 | MySQL Server: Optimizer | Verified (2349 days) | S3 | 5.7.20 | Any | Any | Another example of optimizer choosing ref over range when range is faster |
109736 | 2023-01-23 10:41 | 2023-01-25 7:41 | MySQL Server: Optimizer | Verified (429 days) | S2 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | ANY query with wrong result |
100852 | 2020-09-15 9:40 | 2022-11-26 0:29 | MySQL Server: Optimizer | Verified (1291 days) | S3 | 8.0.20, 8.0.21 | Windows | Any | ANY_VALUE gives unexpected type with GROUP BY |
109601 | 2023-01-12 9:00 | 2023-01-12 9:38 | MySQL Server: Optimizer | Verified (442 days) | S3 | 8.0 | Any | Any | Apply partition pruning if all insert rows have non-null values on autoinc field |
112377 | 2023-09-18 23:01 | 2023-09-19 12:24 | MySQL Server: Optimizer | Verified (192 days) | S3 | 8.0 | Any | Any | Assert in AccessPath::index_merge() |
72814 | 2014-05-30 9:31 | 2014-07-18 18:56 | MySQL Server: Optimizer | Verified (3588 days) | S3 | 5.6.17 | Any | Any | Assertion `!(ordered_index_usage == ordered_index_void && ... fails |
76604 | 2015-04-07 4:29 | 2015-04-07 6:15 | MySQL Server: Optimizer | Verified (3279 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 |
74490 | 2014-10-22 2:08 | 2014-10-22 6:57 | MySQL Server: Optimizer | Verified (3446 days) | S3 | 5.6.20-debug, 5.6.22 | Linux (CentOS 7) | Any | Assertion `table->key_read == 0' failed | sig 6 in close_open_tables |
111918 | 2023-07-30 6:12 | 2023-07-31 6:33 | MySQL Server: Optimizer | Verified (242 days) | S3 | 8.1.0, 8.0.34, 5.7.43 | Ubuntu (22.04) | x86 (x86_64) | Auto increment column query wrong result |
106521 | 2022-02-20 13:00 | 2022-02-21 10:32 | MySQL Server: Optimizer | Verified (767 days) | S3 | 8.0.28 | Any | Any | Backward index scan is not shown for UPDATE/DELETE |
69729 | 2013-07-12 2:18 | 2018-07-12 12:54 | MySQL Server: Optimizer | Verified (3913 days) | S2 | 5.5.31, 5.5.32 | Any | Any | Bad interaction between MIN/MAX and "NOT BETWEEN" leads to wrong results |
56165 | 2010-08-21 8:12 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4967 days) | S3 | 5.0.not_sure, 5.0, 5.1, 5.6.99 bzr | Any | Any | Bad Optimization |
8036 | 2005-01-20 10:12 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6999 days) | S3 | 4.0.18, 4.1.10, 5.1.52 | FreeBSD (Free BSD 4.5, Linux) | Any | Bad optimization of ORDER BY ... LIMIT 1 if one table is MyISAM, another InnoDB |
99244 | 2020-04-14 3:22 | 2020-04-22 12:45 | MySQL Server: Optimizer | Verified (1438 days) | S1 | 8.0.19 | Any | Any | bad performance in hash join because join with no join condition between tables |
104421 | 2021-07-26 19:58 | 2021-07-29 7:07 | MySQL Server: Optimizer | Verified (974 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 (1985 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 (1501 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 (1459 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 (1458 days) | S3 | 8.0.19, 5.6.47, 5.7.29 | Any | Any | BETWEEN malfunctions when comparing large numbers |
99149 | 2020-04-01 11:07 | 2020-04-01 11:46 | MySQL Server: Optimizer | Verified (1458 days) | S3 | 8.0.19 | Any | Any | BETWEEN query malfunctions for special character and TEXT index |
110310 | 2023-03-09 8:41 | 2023-04-29 15:24 | MySQL Server: Optimizer | Verified (386 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | BETWEEN query with wrong result |
102911 | 2021-03-10 23:49 | 2021-03-12 6:09 | MySQL Server: Optimizer | Verified (1114 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 (2457 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 (1613 days) | S2 | 5.7.18, 5.7.28, 5.6.46 | Any | Any | bin() function return Incorrect result set |
110322 | 2023-03-09 11:41 | 2023-03-09 12:31 | MySQL Server: Optimizer | Verified (386 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | Binary column primary key query with wrong result |
15907 | 2005-12-21 15:23 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5218 days) | S5 | 5.0.19-BK, 5.0.13, 6.0.14-bzr | Linux (Linux) | Any | Binary comparison ignores indexes |
63563 | 2011-12-03 14:09 | 2011-12-05 7:50 | MySQL Server: Optimizer | Verified (4499 days) | S2 | 5.5.17 | Any | Any | Binary operator now causes a full scan |
109824 | 2023-01-27 15:43 | 2023-01-28 8:04 | MySQL Server: Optimizer | Verified (426 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | Bit query with wrong result |
110587 | 2023-04-03 7:51 | 2023-04-03 9:37 | MySQL Server: Optimizer | Verified (361 days) | S1 | 8.0.27, 8.0.32, 5.7.41 | Any | Any | Bit with index range query may produce different results |
111318 | 2023-06-07 14:36 | 2023-06-07 14:55 | MySQL Server: Optimizer | Verified (296 days) | S3 | 8.0 | Any | Any | block_nested_loop optimizer wrong result? |
« Show Previous 30 Entries | Showing 31-60 of 735 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |