MySQL Bugs MySQL AB Bugs Database http://bugs.mysql.com/ MySQL Bugs http://bugs.mysql.com/images/mysql_100x52-64.gif http://bugs.mysql.com/ http://bugs.mysql.com/1973 #1973: TPC-C query does not uses indexes efficently http://bugs.mysql.com/bug.php?id=1973 Submitted by: Peter Zaitsev
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any (all)
Version: 4.0
]]> Thu, 27 Nov 2003 09:16:19 +0000 Server: Optimizer http://bugs.mysql.com/5606 #5606: Nonoptimal join type http://bugs.mysql.com/bug.php?id=5606 Submitted by: Eugene Mamchits
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any (any)
Version: 4.0.21
]]> Thu, 16 Sep 2004 10:19:31 +0000 Server: Optimizer http://bugs.mysql.com/6072 #6072: MySQL 4.1 performance regression while comparing text fields http://bugs.mysql.com/bug.php?id=6072 Submitted by: Peter Zaitsev
Category: Server: Optimizer
Status: Won't fix
Severity: 2
OS: Any (all)
Version: 4.1.6 (bk)
]]> Wed, 13 Oct 2004 19:22:29 +0000 Server: Optimizer http://bugs.mysql.com/8686 #8686: explain show incorrect info http://bugs.mysql.com/bug.php?id=8686 Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any (*)
Version: 4.1.10
]]> Tue, 22 Feb 2005 13:42:30 +0000 Server: Optimizer http://bugs.mysql.com/9000 #9000: HAVING not filtering correctly when used with SUM http://bugs.mysql.com/bug.php?id=9000 Submitted by: Lachlan Mulcahy
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any (Any)
Version: 4.0, 4.1
]]> Sun, 06 Mar 2005 22:25:52 +0000 Server: Optimizer http://bugs.mysql.com/13500 #13500: sum() function returns different result based on order http://bugs.mysql.com/bug.php?id=13500 Submitted by: Steve Meyers
Category: Server: Optimizer
Status: Won't fix
Severity: 2
OS: Linux (RHEL 3.0/Linux)
Version: 4.1.14/BK source
]]> Mon, 26 Sep 2005 20:33:31 +0000 Server: Optimizer http://bugs.mysql.com/19346 #19346: Range optimizer decides to scan NULL key values for t.key IN (NULL, ...) http://bugs.mysql.com/bug.php?id=19346 Submitted by: Sergey Petrunya
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Linux (Linux)
Version: 4.1, 5.0, 5.0.89-bzr
]]> Tue, 25 Apr 2006 17:41:13 +0000 Server: Optimizer http://bugs.mysql.com/20182 #20182: LEFT JOIN optimizations http://bugs.mysql.com/bug.php?id=20182 Submitted by: Ruslan Zakirov
Category: Server: Optimizer
Status: Won't fix
Severity: 5
OS: Linux (gentoo linux)
Version: 4.1.19
]]> Thu, 01 Jun 2006 00:00:55 +0000 Server: Optimizer http://bugs.mysql.com/22144 #22144: EXPLAIN returns wrong information http://bugs.mysql.com/bug.php?id=22144 Submitted by: Georg Richter
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.2
]]> Sat, 09 Sep 2006 05:07:23 +0000 Server: Optimizer http://bugs.mysql.com/24714 #24714: Mathematical SELECT queries no longer return consistent results http://bugs.mysql.com/bug.php?id=24714 Submitted by: Joe Clarke
Category: Server: Optimizer
Status: Won't fix
Severity: 1
OS: Linux (Linux, FreeBSD)
Version: 4.1.22, 4.1 BK
]]> Thu, 30 Nov 2006 07:30:42 +0000 Server: Optimizer http://bugs.mysql.com/28866 #28866: Optimizer doesn't choose best plan for execution http://bugs.mysql.com/bug.php?id=28866 Submitted by: Sveta Smirnova
Category: Server: Optimizer
Status: Won't fix
Severity: 5
OS: Any (Linux)
Version: 4.1, 5.0, 5.1
]]> Mon, 04 Jun 2007 07:29:50 +0000 Server: Optimizer http://bugs.mysql.com/37328 #37328: Optimizer prefers ref access on multiple-column index over simple range access http://bugs.mysql.com/bug.php?id=37328 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.0.60, 5.0.64
]]> Wed, 11 Jun 2008 04:50:05 +0000 Server: Optimizer http://bugs.mysql.com/42821 #42821: Assertion failed: maxcount!=0, file filesort.cc, line 1227 after Falcon recovery http://bugs.mysql.com/bug.php?id=42821 Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Won't fix
Severity: 1
OS: Any
Version: 6.0-falcon-team
]]> Fri, 13 Feb 2009 09:41:02 +0000 Server: Optimizer http://bugs.mysql.com/43371 #43371: wrong index is used (sometimes) in tables with multiple keys http://bugs.mysql.com/bug.php?id=43371 Submitted by: Jens Rieks
Category: Server: Optimizer
Status: Won't fix
Severity: 1
OS: Any
Version: 5.0, 5.1.31, 5.1.33-bzr
]]> Wed, 04 Mar 2009 14:09:47 +0000 Server: Optimizer http://bugs.mysql.com/44604 #44604: Wrong number of results returned when executing query http://bugs.mysql.com/bug.php?id=44604 Submitted by: Pim Pronk
Category: Server: Optimizer
Status: Won't fix
Severity: 1
OS: Linux (Cent OS v5)
Version: 5.1.34, 5.0, 5.1 bzr, 5.4
]]> Fri, 01 May 2009 14:26:40 +0000 Server: Optimizer http://bugs.mysql.com/49872 #49872: MySQL returns wrong user variable value after select http://bugs.mysql.com/bug.php?id=49872 Submitted by: Sergei Glukhov
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.0-bugteam
]]> Tue, 22 Dec 2009 10:44:03 +0000 Server: Optimizer http://bugs.mysql.com/50052 #50052: --optimizer-search-depth=63 makes mysql server crash http://bugs.mysql.com/bug.php?id=50052 Submitted by: Guilhem Bichot
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Linux
Version: 6.0
]]> Mon, 04 Jan 2010 14:27:38 +0000 Server: Optimizer http://bugs.mysql.com/51930 #51930: MySQL not optimizing query on two part (char,int) index http://bugs.mysql.com/bug.php?id=51930 Submitted by: Scott Nebor
Category: Server: Optimizer
Status: Won't fix
Severity: 5
OS: Linux (Ubuntu 8.04)
Version: 5.1.43, 5.1.44, 5.1.46-bzr
]]> Wed, 10 Mar 2010 19:13:49 +0000 Server: Optimizer http://bugs.mysql.com/53224 #53224: Aggregate-only query has extra rows if ORDER BY contains additional column http://bugs.mysql.com/bug.php?id=53224 Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.0
]]> Tue, 27 Apr 2010 21:54:08 +0000 Server: Optimizer http://bugs.mysql.com/57599 #57599: ORDER BY .. LIMIT stops using a key after removing partitioning on a table http://bugs.mysql.com/bug.php?id=57599 Submitted by: Elena Stepanova
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.1, 5.5
]]> Wed, 20 Oct 2010 11:59:14 +0000 Server: Optimizer http://bugs.mysql.com/61395 #61395: Bogus result with SQL_BIG_RESULT and multiple GROUP BY http://bugs.mysql.com/bug.php?id=61395 Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.1.58
]]> Fri, 03 Jun 2011 12:23:21 +0000 Server: Optimizer http://bugs.mysql.com/65995 #65995: MySQL 5.5.20 sql_select.cc has error http://bugs.mysql.com/bug.php?id=65995 Submitted by: henry king
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.5.20, 5.5.28
]]> Tue, 24 Jul 2012 10:49:30 +0000 Server: Optimizer http://bugs.mysql.com/71849 #71849: memory leak when subquery using order by(make_reverse) and best_key used http://bugs.mysql.com/bug.php?id=71849 Submitted by: xiaobin lin
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.5
]]> Wed, 26 Feb 2014 21:41:51 +0000 Server: Optimizer http://bugs.mysql.com/72040 #72040: mysql only returning the first row http://bugs.mysql.com/bug.php?id=72040 Submitted by: mathieu mat
Category: Server: Optimizer
Status: Won't fix
Severity: 1
OS: Any
Version: 5.5.35,5.5.36
]]> Fri, 14 Mar 2014 21:28:22 +0000 Server: Optimizer http://bugs.mysql.com/72510 #72510: SELECT leaks memory http://bugs.mysql.com/bug.php?id=72510 Submitted by: Hanno Foest
Category: Server: Optimizer
Status: Won't fix
Severity: 2
OS: Linux (Ubuntu 12.04)
Version: 5.5.37-0ubuntu0.12.04.1
]]> Fri, 02 May 2014 02:15:29 +0000 Server: Optimizer http://bugs.mysql.com/77398 #77398: row size too large in mysql 5.7 query http://bugs.mysql.com/bug.php?id=77398 Submitted by: Andrea Manenti
Category: Server: Optimizer
Status: Won't fix
Severity: 1
OS: Any
Version: 5.7.7
]]> Thu, 18 Jun 2015 08:01:33 +0000 Server: Optimizer http://bugs.mysql.com/78417 #78417: Valid select with expression in group by under "only_full_group_by" fails http://bugs.mysql.com/bug.php?id=78417 Submitted by: Su Dylan
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.6.22
]]> Sat, 12 Sep 2015 09:48:47 +0000 Server: Optimizer http://bugs.mysql.com/78822 #78822: Materialized table from semijoin may change join order and lead to bad plan http://bugs.mysql.com/bug.php?id=78822 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.6, 5.6.27
]]> Tue, 13 Oct 2015 17:15:25 +0000 Server: Optimizer http://bugs.mysql.com/87164 #87164: Queries running much slower in version 5.7 versus 5.6 http://bugs.mysql.com/bug.php?id=87164 Submitted by: Alok Pathak
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: CentOS (6 & 7)
Version: 5.7, 5.7.18, 5.7.19
]]> Fri, 21 Jul 2017 16:28:47 +0000 Server: Optimizer http://bugs.mysql.com/100536 #100536: Regression on 8.0 when using DISTINCT and LEFT JOIN http://bugs.mysql.com/bug.php?id=100536 Submitted by: Juan Arruti
Category: Server: Optimizer
Status: Won't fix
Severity: 5
OS: Any
Version: 8.0.21, 8.0.23
]]> Sat, 15 Aug 2020 00:48:46 +0000 Server: Optimizer