Showing 1-30 of 376 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
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  
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  
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  
456802009-06-23
14:15
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0.54, 5.0.82, 5.1.35, 6.0.12AnyAnywrong results when using index for lookup with implicitly casted values  
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  
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  
725012014-05-01
17:31
2014-05-01
18:12
MySQL Server: OptimizerVerifiedS35.6.17AnyAnyjoining NULLs + different collation is not efficient  
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  
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  
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  
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  
458802009-07-01
14:21
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.15.5+AnyAnyOUTER JOINed tables with no condition in WHERE must be at the end of explain Sergey Glukhov
801162016-01-22
13:56
2016-01-22
13:56
MySQL Server: OptimizerVerifiedS35.7AnyAnyOuter reference to aggregate incorrectly 0 or NULL in subquery  
909512018-05-21
16:18
2018-11-19
14:45
MySQL Server: OptimizerVerifiedS35.6.35AnyAnyContribution by Facebook: Enhance group-by loose index scan  
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  
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  
460562009-07-08
20:24
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0,5.1,5.4AnyAnyDuplicate rows returned on MAX + ORDER BY  
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  
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  
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  
793402015-11-19
14:40
2018-10-30
9:16
MySQL Server: OptimizerVerifiedS25.7.9AnyAnyUNION ALL ... LIMIT 1 evaluates too many rows in 5.5/6 and twice more in 5.7  
942512019-02-08
7:01
2019-02-08
11:18
MySQL Server: OptimizerVerified
(8 days)
S38.0.12, 8.0.15Microsoft Windows (Windows 10 Pro)x86 (AMD Athlon 64 X2)Aggregate function result is dependent by window is defined directly or as named  
942242019-02-06
16:45
2019-02-07
8:56
MySQL Server: OptimizerVerified
(9 days)
S35.6, 5.6.43Any (any)Any (any)[5.6] Optimizer reconsiders index based on index definition order, not value  
939222019-01-14
16:04
2019-01-17
15:06
MySQL Server: OptimizerVerified
(30 days)
S28.0Linuxx86UNION ALL very slow with SUM(0)  
938452019-01-07
21:55
2019-01-10
13:00
MySQL Server: OptimizerVerified
(38 days)
S25.7,8.0.11,8.0.13AnyAnyOptimizer choose wrong index, sorting index instead of filtering index  
935862018-12-13
9:50
2018-12-13
12:32
MySQL Server: OptimizerVerified
(65 days)
S28.0, 8.0.13AnyAnyQuery state "Removing duplicates"  
933602018-11-27
9:41
2018-12-12
14:48
MySQL Server: OptimizerVerified
(66 days)
S55.6.16,5.7.23Linuxx86mysterious optimizer behavior  
934912018-12-05
17:40
2018-12-06
5:39
MySQL Server: OptimizerVerified
(72 days)
S38.0.13, 5.7.24, 5.6.42AnyAnyOptimizer does not correctly consider attached conditions in planning  
934552018-12-03
16:46
2018-12-06
14:04
MySQL Server: OptimizerVerified
(73 days)
S35.7.24AnyAnymax_execution_time optimizer hint has no effect on boolean full-text search  
  Showing 1-30 of 376 (Edit, Save, CSV, Feed) Show Next 30 Entries »