« 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
881812017-10-23
5:30
2018-06-11
19:55
MySQL Server: OptimizerVerified
(2349 days)
S35.7.20AnyAnyAnother example of optimizer choosing ref over range when range is faster
1097362023-01-23
10:41
2023-01-25
7:41
MySQL Server: OptimizerVerified
(429 days)
S28.0.32Ubuntu (22.04)x86 (x86_64)ANY query with wrong result
1008522020-09-15
9:40
2022-11-26
0:29
MySQL Server: OptimizerVerified
(1291 days)
S38.0.20, 8.0.21WindowsAnyANY_VALUE gives unexpected type with GROUP BY
1096012023-01-12
9:00
2023-01-12
9:38
MySQL Server: OptimizerVerified
(442 days)
S38.0AnyAnyApply partition pruning if all insert rows have non-null values on autoinc field
1123772023-09-18
23:01
2023-09-19
12:24
MySQL Server: OptimizerVerified
(192 days)
S38.0AnyAnyAssert in AccessPath::index_merge()
728142014-05-30
9:31
2014-07-18
18:56
MySQL Server: OptimizerVerified
(3588 days)
S35.6.17AnyAnyAssertion `!(ordered_index_usage == ordered_index_void && ... fails
766042015-04-07
4:29
2015-04-07
6:15
MySQL Server: OptimizerVerified
(3279 days)
S35.6.23, 5.6.24, 5.6.25, 5.7.8Linux (CentOS 7)AnyAssertion `length > 0 && keyparts != 0' failed in create_ref_for_key
744902014-10-22
2:08
2014-10-22
6:57
MySQL Server: OptimizerVerified
(3446 days)
S35.6.20-debug, 5.6.22Linux (CentOS 7)AnyAssertion `table->key_read == 0' failed | sig 6 in close_open_tables
1119182023-07-30
6:12
2023-07-31
6:33
MySQL Server: OptimizerVerified
(242 days)
S38.1.0, 8.0.34, 5.7.43Ubuntu (22.04)x86 (x86_64)Auto increment column query wrong result
1065212022-02-20
13:00
2022-02-21
10:32
MySQL Server: OptimizerVerified
(767 days)
S38.0.28AnyAnyBackward index scan is not shown for UPDATE/DELETE
697292013-07-12
2:18
2018-07-12
12:54
MySQL Server: OptimizerVerified
(3913 days)
S25.5.31, 5.5.32AnyAnyBad interaction between MIN/MAX and "NOT BETWEEN" leads to wrong results
561652010-08-21
8:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4967 days)
S35.0.not_sure, 5.0, 5.1, 5.6.99 bzrAnyAnyBad Optimization
80362005-01-20
10:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6999 days)
S34.0.18, 4.1.10, 5.1.52FreeBSD (Free BSD 4.5, Linux)AnyBad optimization of ORDER BY ... LIMIT 1 if one table is MyISAM, another InnoDB
992442020-04-14
3:22
2020-04-22
12:45
MySQL Server: OptimizerVerified
(1438 days)
S18.0.19AnyAnybad performance in hash join because join with no join condition between tables
1044212021-07-26
19:58
2021-07-29
7:07
MySQL Server: OptimizerVerified
(974 days)
S28.0.26, 5.7.35AnyAnyBad plan for WHERE customer_id = @cid ORDER BY id LIMIT 10 with compound PK.
928502018-10-19
0:46
2018-10-22
5:31
MySQL Server: OptimizerVerified
(1985 days)
S35.7.23AnyAnyBad select+order by+limit performance in 5.7
986472020-02-18
13:06
2020-02-18
14:03
MySQL Server: OptimizerVerified
(1501 days)
S35.7.29Windowsx86Bad SUM result with GROUP BY
991302020-03-31
12:18
2020-04-01
13:10
MySQL Server: OptimizerVerified
(1459 days)
S38.0.19,5.6.47, 5.7.29AnyAnyBETWEEN malfunctions when comparing a string containing a newline
991352020-03-31
16:54
2020-04-01
5:11
MySQL Server: OptimizerVerified
(1458 days)
S38.0.19, 5.6.47, 5.7.29AnyAnyBETWEEN malfunctions when comparing large numbers
991492020-04-01
11:07
2020-04-01
11:46
MySQL Server: OptimizerVerified
(1458 days)
S38.0.19AnyAnyBETWEEN query malfunctions for special character and TEXT index
1103102023-03-09
8:41
2023-04-29
15:24
MySQL Server: OptimizerVerified
(386 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)BETWEEN query with wrong result
1029112021-03-10
23:49
2021-03-12
6:09
MySQL Server: OptimizerVerified
(1114 days)
S25.7, 8.0, 5.7.33, 8.0.23AnyAnyBETWEEN SQL-query on auto-incremented primary key field gives the incorrect resu
869732017-07-06
13:26
2017-07-07
7:19
MySQL Server: OptimizerVerified
(2457 days)
S15.6, 5.5.56, 5.6.36, 5.7.18AnyAnyBIN() function error
973392019-10-23
8:06
2021-07-23
13:05
MySQL Server: OptimizerVerified
(1613 days)
S25.7.18, 5.7.28, 5.6.46AnyAnybin() function return Incorrect result set
1103222023-03-09
11:41
2023-03-09
12:31
MySQL Server: OptimizerVerified
(386 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)Binary column primary key query with wrong result
159072005-12-21
15:23
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5218 days)
S55.0.19-BK, 5.0.13, 6.0.14-bzrLinux (Linux)AnyBinary comparison ignores indexes
635632011-12-03
14:09
2011-12-05
7:50
MySQL Server: OptimizerVerified
(4499 days)
S25.5.17AnyAnyBinary operator now causes a full scan
1098242023-01-27
15:43
2023-01-28
8:04
MySQL Server: OptimizerVerified
(426 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)Bit query with wrong result
1105872023-04-03
7:51
2023-04-03
9:37
MySQL Server: OptimizerVerified
(361 days)
S18.0.27, 8.0.32, 5.7.41AnyAnyBit with index range query may produce different results
1113182023-06-07
14:36
2023-06-07
14:55
MySQL Server: OptimizerVerified
(296 days)
S38.0AnyAnyblock_nested_loop optimizer wrong result?
« Show Previous 30 Entries Showing 31-60 of 735 (Edit, Save, CSV, Feed) Show Next 30 Entries »