Showing all 28 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
19732003-11-27
9:16
2003-12-13
18:57
MySQL Server: OptimizerWon't fix
(5480 days)
S34.0Any (all)AnyTPC-C query does not uses indexes efficently Igor Babaev
56062004-09-16
10:19
2004-10-07
12:27
MySQL Server: OptimizerWon't fix
(5181 days)
S34.0.21Any (any)AnyNonoptimal join type  
60722004-10-13
19:22
2004-11-23
16:42
MySQL Server: OptimizerWon't fix
(5134 days)
S24.1.6 (bk)Any (all)AnyMySQL 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
(5025 days)
S34.1.10Any (*)Anyexplain show incorrect info Sergey Petrunya
90002005-03-06
22:25
2005-03-09
1:12
MySQL Server: OptimizerWon't fix
(5028 days)
S34.0, 4.1Any (Any)AnyHAVING not filtering correctly when used with SUM Igor Babaev
135002005-09-26
20:33
2005-10-05
5:44
MySQL Server: OptimizerWon't fix
(4818 days)
S24.1.14/BK sourceLinux (RHEL 3.0/Linux)Anysum() function returns different result based on order Alexander Ivanov
193462006-04-25
17:41
2011-02-16
23:43
MySQL Server: OptimizerWon't fix
(3291 days)
S34.1, 5.0, 5.0.89-bzr Linux (Linux)AnyRange 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
(4539 days)
S54.1.19Linux (gentoo linux)AnyLEFT JOIN optimizations Igor Babaev
221442006-09-09
5:07
2014-01-07
15:25
MySQL Server: OptimizerWon't fix
(1802 days)
S35.2AnyAnyEXPLAIN returns wrong information  
247142006-11-30
7:30
2007-08-20
15:40
MySQL Server: OptimizerWon't fix
(4134 days)
S14.1.22, 4.1 BKLinux (Linux, FreeBSD)AnyMathematical SELECT queries no longer return consistent results  
288662007-06-04
7:29
2007-08-17
23:07
MySQL Server: OptimizerWon't fix
(4137 days)
S54.1, 5.0, 5.1Any (Linux)AnyOptimizer doesn't choose best plan for execution Sergey Petrunya
373282008-06-11
4:50
2014-08-12
2:08
MySQL Server: OptimizerWon't fix
(2244 days)
S35.0.60, 5.0.64AnyAnyOptimizer 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
(3237 days)
S16.0-falcon-teamAnyAnyAssertion 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
(2164 days)
S15.0, 5.1.31, 5.1.33-bzrAnyAnywrong index is used (sometimes) in tables with multiple keys  
446042009-05-01
14:26
2011-02-16
23:43
MySQL Server: OptimizerWon't fix
(3499 days)
S15.1.34, 5.0, 5.1 bzr, 5.4Linux (Cent OS v5)AnyWrong number of results returned when executing query  
498722009-12-22
10:44
2011-02-16
23:44
MySQL Server: OptimizerWon't fix
(3264 days)
S35.0-bugteamAnyAnyMySQL returns wrong user variable value after select Evgeny Potemkin
500522010-01-04
14:27
2011-02-16
23:44
MySQL Server: OptimizerWon't fix
(3209 days)
S36.0LinuxAny--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
(1317 days)
S55.1.43, 5.1.44, 5.1.46-bzr5.5+Linux (Ubuntu 8.04)AnyMySQL not optimizing query on two part (char,int) index  
532242010-04-27
21:54
2011-02-16
23:44
MySQL Server: OptimizerWon't fix
(3151 days)
S35.0AnyAnyAggregate-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
(2969 days)
S35.1, 5.5AnyAnyORDER 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
(2739 days)
S35.1.58AnyAnyBogus result with SQL_BIG_RESULT and multiple GROUP BY  
659952012-07-24
10:49
2013-01-30
0:38
MySQL Server: OptimizerWon't fix
(2144 days)
S35.5.20, 5.5.28AnyAnyMySQL 5.5.20 sql_select.cc has error  
718492014-02-26
21:41
2014-04-04
13:50
MySQL Server: OptimizerWon't fix
(1715 days)
S35.5AnyAnymemory 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
(1676 days)
S15.5.35,5.5.36AnyAnymysql only returning the first row  
725102014-05-02
2:15
2014-05-04
15:39
MySQL Server: OptimizerWon't fix
(1685 days)
S25.5.37-0ubuntu0.12.04.1Linux (Ubuntu 12.04)AnySELECT leaks memory  
784172015-09-12
9:48
2015-09-14
11:44
MySQL Server: OptimizerWon't fix
(1187 days)
S35.6.22AnyAnyValid 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
(785 days)
S35.6, 5.6.27AnyAnyMaterialized table from semijoin may change join order and lead to bad plan  
871642017-07-21
16:28
2018-04-19
5:46
MySQL Server: OptimizerWon't fix
(239 days)
S35.7, 5.7.18, 5.7.19CentOS (6 & 7)AnyQueries running much slower in version 5.7 versus 5.6  
Showing all 28 (Edit, Save, CSV, Feed)