Showing 1-30 of 465 (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
2020-05-03
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)
1026862021-02-22
12:50
2021-02-24
16:01
MySQL Server: OptimizerVerified
(9 days)
S58.0AnyAnyThe query plan changed cause query too long
1026812021-02-22
5:29
2021-02-22
6:05
MySQL Server: OptimizerVerified
(11 days)
S38.0,5.7.33, 8.0.23AnyAnyresult of "datetime_val not between NULL and NULL" is unexpected
1026562021-02-19
3:52
2021-02-19
6:59
MySQL Server: OptimizerVerified
(14 days)
S38.0.22, 8.0.23AnyAnySELECT results containing the special character " ︠e " is different
1026552021-02-19
3:07
2021-02-19
6:34
MySQL Server: OptimizerVerified
(14 days)
S38.0, 8.0.23AnyAnyresults from SELECT are different when use WHERE or not
1026342021-02-18
3:26
2021-02-18
7:36
MySQL Server: OptimizerVerified
(15 days)
S38.0.17+AnyAnyOptimizer loses part of range when OR multiple identical ranges in range plan
1024812021-02-04
15:37
2021-02-05
14:40
MySQL Server: OptimizerVerified
(28 days)
S38.0.23AnyAnyEXPLAIN FOR CONNECTION not good
1024682021-02-03
10:06
2021-02-03
10:21
MySQL Server: OptimizerVerified
(30 days)
S38.0.22, 8.0.23AnyAnyTemptable storage engine returns error: doesn't support update of indexes
1024442021-02-02
1:10
2021-02-02
5:20
MySQL Server: OptimizerVerified
(31 days)
S25.7.22 - 5.7.32; 8.0.12, 5.7.33Anyx86Dependent subquery with ORDER BY return NULL value
1024292021-01-30
8:52
2021-01-31
3:00
MySQL Server: OptimizerVerified
(34 days)
S28.0.23AnyAnyTable #sql13c8_4a4_d' uses an extension that doesn't exist in this MySQL version
1023592021-01-24
8:57
2021-01-27
18:48
MySQL Server: OptimizerVerified
(37 days)
S28.0.23AnyAnyFunctional Index ignored by Select query from within a Stored Function
  Showing 1-30 of 465 (Edit, Save, CSV, Feed) Show Next 30 Entries »