Showing 1-30 of 734 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
445492009-04-29
17:47
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0.80, 5.1.34AnyAnyoptimizer incorrectly chooses table scan and filesort over index
456802009-06-23
14:15
2020-04-01
13:16
MySQL Server: OptimizerVerifiedS35.0.54, 5.0.82, 5.1.35, 6.0.12AnyAnywrong results when using index for lookup with implicitly casted values
458802009-07-01
14:21
2022-09-04
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1AnyAnyOUTER JOINed tables with no condition in WHERE must be at the end of explain
460562009-07-08
20:24
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0,5.1,5.4AnyAnyDuplicate rows returned on MAX + ORDER BY
462172009-07-16
11:16
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0,5.1,5.4AnyAnyWrong result on aggregate + JOIN + ORDER BY + LIMIT
462772009-07-17
21:33
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0AnyAnydiffering results for equivalent queries using VAR_POP() & AVG() with DISTINCT
462832009-07-18
15:22
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0AnyAnyCOUNT() returning bad values when LIMIT 1 clause added to query
465172009-08-02
21:54
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.4,5.6.99AnyAnyQueries with constant / null only WHERE clause interpreted differently in azalea
480492009-10-14
16:46
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1.37, 5.5.7AnyAnySELECT MIN(1) reports differently for MERGE tables in 5.0 and 5.1
481032009-10-16
0:32
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1, 6.0AnyAnyUsing STRAIGHT_JOIN with Innodb tables can produce duplicate results
481902009-10-20
14:59
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1,6.0AnyAnyError processing ALL subqueries on empty sets - different than JavaDB/Postgres
495902009-12-10
16:03
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0+AnyAnyServer reporting different result sets for a query depending on use of indexes
503882010-01-16
4:13
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS55.1.41,5.1.42, 5.1.43-bzrAnyAnypartition pruning not working with some right joins
541792010-06-02
11:37
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1.37 , 5.1.47 , 5.5.4AnyAnyIndex is not used for range scan on SET field
600232011-02-08
21:45
2014-05-22
12:13
MySQL Server: OptimizerVerifiedS55.5.8 , 5.1.51AnyAnyNo Loose Index Scan for GROUP BY / DISTINCT on InnoDB partitioned table
693502013-05-30
5:44
2014-02-20
5:48
MySQL Server: OptimizerVerifiedS55.6AnyAnyperformance regression between 5.5 and 5.6 for simple statement in routine loop
698912013-08-01
6:33
2014-09-18
21:25
MySQL Server: OptimizerVerifiedS35.1.31AnyAnysince 5.1.31 REPLACE() function concats it's results under certain conditions
725012014-05-01
17:31
2014-05-01
18:12
MySQL Server: OptimizerVerifiedS35.6.17AnyAnyjoining NULLs + different collation is not efficient
802062016-01-30
6:13
2016-01-30
6:13
MySQL Server: OptimizerVerifiedS35.7.10AnyAnyEQ_REF extension should be skipped for the last joined table
955432019-05-27
12:37
2019-05-29
12:34
MySQL Server: OptimizerVerifiedS25.7.26AnyAnyoptimizer prefers index for order by rather than filtering - (70x slower)
1088632022-10-24
16:40
2024-03-15
8:49
MySQL Server: OptimizerVerifiedS58.0.31AnyAnydifferent index picked when row is not found, marginally slower
1143012024-03-11
16:40
2024-03-12
16:23
MySQL Server: OptimizerVerified
(16 days)
S38.0AnyAnyIncorrect result with IS NULL predicate in join condition
1142372024-03-06
6:57
2024-03-06
8:30
MySQL Server: OptimizerVerified
(22 days)
S58.2.0, 8.3.0AnyAnyUnexpected Cardinality by Index
1129022023-10-31
14:39
2024-02-26
11:07
MySQL Server: OptimizerVerified
(31 days)
S58.0.31, 8.0.35Linux (n.a.)x86 (x86_64)Optimizer in MySQL 8 is significantly slower on dependent subqueries than 5.7
1140922024-02-22
23:40
2024-02-26
14:58
MySQL Server: OptimizerVerified
(33 days)
S5Ver 8.0.36-0Ubuntu (ubuntu 22.04.1)x86 (Linux on x86_64 ((Ubuntu)))WHERE statement on an indexed decimal column hangs
1140272024-02-17
19:34
2024-02-19
6:29
MySQL Server: OptimizerVerified
(38 days)
S38.0.36 & 8.3.0Windows (10 & 11)ARM (x64)Plans for inner hash join show that wrong table is hashed
1138922024-02-05
10:39
2024-02-05
14:13
MySQL Server: OptimizerVerified
(52 days)
S38.0AnyAnyFORCE INDEX reports wrong number of rows
1106562023-04-11
16:02
2024-01-26
9:27
MySQL Server: OptimizerVerified
(62 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)Join query with wrong result
1137362024-01-24
9:44
2024-01-24
14:03
MySQL Server: OptimizerVerified
(64 days)
S38.3MacOS (14.3)ARMTest main.qualify_hypergraph failing with a result difference
1136992024-01-21
16:58
2024-01-24
5:13
MySQL Server: OptimizerVerified
(65 days)
S58.0, 8.1, 8.2, 8.3AnyAnyQEP regression with prefer_ordering_index=off
  Showing 1-30 of 734 (Edit, Save, CSV, Feed) Show Next 30 Entries »