Showing all 27 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version Target OS Summary Assigned
19732003-11-27
9:16
2003-12-13
18:57
MySQL Server: OptimizerWon't fix
(5058 days)
S34.0Any (all)TPC-C query does not uses indexes efficently Igor Babaev
56062004-09-16
10:19
2004-10-07
12:27
MySQL Server: OptimizerWon't fix
(4759 days)
S34.0.21Any (any)Nonoptimal join type  
60722004-10-13
19:22
2004-11-23
16:42
MySQL Server: OptimizerWon't fix
(4712 days)
S24.1.6 (bk)Any (all)MySQL 4.1 performance regression while comparing text fields Timour Katchaounov
86862005-02-22
13:42
2005-03-12
15:38
MySQL Server: OptimizerWon't fix
(4603 days)
S34.1.10Any (*)explain show incorrect info Sergey Petrunya
90002005-03-06
22:25
2005-03-09
1:12
MySQL Server: OptimizerWon't fix
(4606 days)
S34.0, 4.1Any (Any)HAVING not filtering correctly when used with SUM Igor Babaev
135002005-09-26
20:33
2005-10-05
5:44
MySQL Server: OptimizerWon't fix
(4396 days)
S24.1.14/BK sourceLinux (RHEL 3.0/Linux)sum() function returns different result based on order Alexander Ivanov
193462006-04-25
17:41
2011-02-16
23:43
MySQL Server: OptimizerWon't fix
(2869 days)
S34.1, 5.0, 5.0.89-bzr Linux (Linux)Range optimizer decides to scan NULL key values for t.key IN (NULL, ...)  
201822006-06-01
0:00
2006-07-11
6:06
MySQL Server: OptimizerWon't fix
(4117 days)
S54.1.19Linux (gentoo linux)LEFT JOIN optimizations Igor Babaev
221442006-09-09
5:07
2014-01-07
15:25
MySQL Server: OptimizerWon't fix
(1380 days)
S35.2AnyEXPLAIN returns wrong information  
247142006-11-30
7:30
2007-08-20
15:40
MySQL Server: OptimizerWon't fix
(3712 days)
S14.1.22, 4.1 BKLinux (Linux, FreeBSD)Mathematical SELECT queries no longer return consistent results  
288662007-06-04
7:29
2007-08-17
23:07
MySQL Server: OptimizerWon't fix
(3715 days)
S54.1, 5.0, 5.1Any (Linux)Optimizer doesn't choose best plan for execution Sergey Petrunya
373282008-06-11
4:50
2014-08-12
2:08
MySQL Server: OptimizerWon't fix
(1822 days)
S35.0.60, 5.0.64AnyOptimizer prefers ref access on multiple-column index over simple range access Jørgen Løland
428212009-02-13
9:41
2011-02-16
23:43
MySQL Server: OptimizerWon't fix
(2815 days)
S16.0-falcon-teamAnyAssertion failed: maxcount!=0, file filesort.cc, line 1227 after Falcon recovery  
433712009-03-04
14:09
2013-01-10
11:02
MySQL Server: OptimizerWon't fix
(1742 days)
S15.0, 5.1.31, 5.1.33-bzrAnywrong index is used (sometimes) in tables with multiple keys  
446042009-05-01
14:26
2011-02-16
23:43
MySQL Server: OptimizerWon't fix
(3077 days)
S15.1.34, 5.0, 5.1 bzr, 5.4Linux (Cent OS v5)Wrong number of results returned when executing query  
498722009-12-22
10:44
2011-02-16
23:44
MySQL Server: OptimizerWon't fix
(2842 days)
S35.0-bugteamAnyMySQL returns wrong user variable value after select Evgeny Potemkin
500522010-01-04
14:27
2011-02-16
23:44
MySQL Server: OptimizerWon't fix
(2787 days)
S36.0Linux--optimizer-search-depth=63 makes mysql server crash Roy Lyseng
519302010-03-10
19:13
2015-05-07
5:08
MySQL Server: OptimizerWon't fix
(895 days)
S55.1.43, 5.1.44, 5.1.46-bzr5.5+Linux (Ubuntu 8.04)MySQL not optimizing query on two part (char,int) index  
532242010-04-27
21:54
2011-02-16
23:44
MySQL Server: OptimizerWon't fix
(2729 days)
S35.0AnyAggregate-only query has extra rows if ORDER BY contains additional column  
575992010-10-20
11:59
2011-02-16
23:44
MySQL Server: OptimizerWon't fix
(2547 days)
S35.1, 5.5AnyORDER BY .. LIMIT stops using a key after removing partitioning on a table  
613952011-06-03
12:23
2011-06-15
23:01
MySQL Server: OptimizerWon't fix
(2317 days)
S35.1.58AnyBogus result with SQL_BIG_RESULT and multiple GROUP BY  
659952012-07-24
10:49
2013-01-30
0:38
MySQL Server: OptimizerWon't fix
(1722 days)
S35.5.20, 5.5.28AnyMySQL 5.5.20 sql_select.cc has error  
718492014-02-26
21:41
2014-04-04
13:50
MySQL Server: OptimizerWon't fix
(1293 days)
S35.5Anymemory leak when subquery using order by(make_reverse) and best_key used  
720402014-03-14
21:28
2017-05-16
14:23
MySQL Server: OptimizerWon't fix
(1254 days)
S15.5.35,5.5.36Anymysql only returning the first row  
725102014-05-02
2:15
2014-05-04
15:39
MySQL Server: OptimizerWon't fix
(1263 days)
S25.5.37-0ubuntu0.12.04.1Linux (Ubuntu 12.04)SELECT leaks memory  
784172015-09-12
9:48
2015-09-14
11:44
MySQL Server: OptimizerWon't fix
(765 days)
S35.6.22AnyValid select with expression in group by under "only_full_group_by" fails  
788222015-10-13
17:15
2016-10-20
8:41
MySQL Server: OptimizerWon't fix
(363 days)
S35.6, 5.6.27AnyMaterialized table from semijoin may change join order and lead to bad plan  
Showing all 27 (Edit, Save, CSV, Feed)