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/26232 #26232: review of bug #20944 / proof of concept attached http://bugs.mysql.com/bug.php?id=26232 Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.1.22, 5.0.34, 5.0.36-BK
]]> Fri, 09 Feb 2007 17:28:20 +0000 Server: Optimizer http://bugs.mysql.com/29443 #29443: cost calculations are off http://bugs.mysql.com/bug.php?id=29443 Submitted by: Matthew Lord
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.19
]]> Fri, 29 Jun 2007 13:28:44 +0000 Server: Optimizer http://bugs.mysql.com/42948 #42948: MySQL Optimizer does not properly use Indexes on Views with "Group By" http://bugs.mysql.com/bug.php?id=42948 Submitted by: John Kounis
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux (Ubuntu 8.10)
Version: 5.0.67-0ubuntu6, 6.0.11
]]> Tue, 17 Feb 2009 23:02:39 +0000 Server: Optimizer http://bugs.mysql.com/44549 #44549: optimizer incorrectly chooses table scan and filesort over index http://bugs.mysql.com/bug.php?id=44549 Submitted by: Matthew Lord
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0.80, 5.1.34
]]> Wed, 29 Apr 2009 17:47:30 +0000 Server: Optimizer http://bugs.mysql.com/44201 #44201: Performance problem with View http://bugs.mysql.com/bug.php?id=44201 Submitted by: Akiko Marti
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.32, 5.1.35-bzr, 6.0.11-bzr, 5.0, 5.6.99
]]> Fri, 10 Apr 2009 03:04:52 +0000 Server: Optimizer http://bugs.mysql.com/46376 #46376: Optimizer choose wrong index even when where clause and order-by are covered http://bugs.mysql.com/bug.php?id=46376 Submitted by: T C
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Windows (XP)
Version: 5.0.85, 5.1.36, 5.1.38, 5.1.39
]]> Fri, 24 Jul 2009 17:05:25 +0000 Server: Optimizer http://bugs.mysql.com/48049 #48049: SELECT MIN(1) reports differently for MERGE tables in 5.0 and 5.1 http://bugs.mysql.com/bug.php?id=48049 Submitted by: Kyle Joiner
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.37, 5.5.7
]]> Wed, 14 Oct 2009 16:46:51 +0000 Server: Optimizer http://bugs.mysql.com/47454 #47454: Not exists optimization method is not used for NULL columns in the right table http://bugs.mysql.com/bug.php?id=47454 Submitted by: Alex Bolenok
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.35
]]> Sat, 19 Sep 2009 19:33:40 +0000 Server: Optimizer http://bugs.mysql.com/58101 #58101: Optimizer picks wrong order of queries http://bugs.mysql.com/bug.php?id=58101 Submitted by: Zbigniew Braniecki
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux
Version: 5.1.38-community-log, 5.1.54-bzr
]]> Wed, 10 Nov 2010 00:21:44 +0000 Server: Optimizer http://bugs.mysql.com/67351 #67351: Cardinality samples of partitioned tables sometimes widely off http://bugs.mysql.com/bug.php?id=67351 Submitted by: Patrick van Bergen
Category: Server: Partition
Status: In progress
Severity: 2
OS: Linux
Version: 5.5.27-29.0
]]> Wed, 24 Oct 2012 08:02:07 +0000 Server: Partition http://bugs.mysql.com/68554 #68554: Optimizer wrongly choses covering index over ICP http://bugs.mysql.com/bug.php?id=68554 Submitted by: Jaime Crespo
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 5.6.10
]]> Sun, 03 Mar 2013 16:16:08 +0000 Server: Optimizer http://bugs.mysql.com/71191 #71191: Loose index scan is used even though full table scan/tight index scan is faster http://bugs.mysql.com/bug.php?id=71191 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.5.33
]]> Fri, 20 Dec 2013 15:30:25 +0000 Server: Optimizer http://bugs.mysql.com/71199 #71199: Optimizer's estimated number of rows is 2 times wrong for (loose?) index scans http://bugs.mysql.com/bug.php?id=71199 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6.14, 5.6.15, 5.5.35
]]> Sat, 21 Dec 2013 18:16:34 +0000 Server: Optimizer http://bugs.mysql.com/71189 #71189: Manual does not provide enough details on how loose index scan really works http://bugs.mysql.com/bug.php?id=71189 Submitted by: Valeriy Kravchuk
Category: Server: Docs
Status: Verified
Severity: 3
OS: Any
Version: 5.5, any
]]> Fri, 20 Dec 2013 14:56:53 +0000 Server: Docs http://bugs.mysql.com/74049 #74049: Update query use filesort instead of index http://bugs.mysql.com/bug.php?id=74049 Submitted by: Matzz -
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6.19-67.0, 5.6.22
]]> Wed, 24 Sep 2014 08:01:47 +0000 Server: Optimizer http://bugs.mysql.com/74083 #74083: ENUM index scan is slower than INT index scan http://bugs.mysql.com/bug.php?id=74083 Submitted by: Vojtech Kurka
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux (CentOS 6.5)
Version: 5.6.20, 5.6.22
]]> Thu, 25 Sep 2014 18:11:12 +0000 Server: Optimizer http://bugs.mysql.com/80067 #80067: Index on BIT column is NOT used when column name only is used in WHERE clause http://bugs.mysql.com/bug.php?id=80067 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6.28, 5.7.10
]]> Wed, 20 Jan 2016 10:50:43 +0000 Server: Optimizer http://bugs.mysql.com/30342 #30342: Equality propagation can make optimization much slower http://bugs.mysql.com/bug.php?id=30342 Submitted by: Mark Callaghan
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 5.0.37, 5.6.17
]]> Thu, 09 Aug 2007 18:52:04 +0000 Server: Optimizer http://bugs.mysql.com/83062 #83062: it's no longer possible to determine used key parts by looking at key_length http://bugs.mysql.com/bug.php?id=83062 Submitted by: Kenny Gryp
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6.32, 5.7.14, 5.6.33, 5.7.15
]]> Tue, 20 Sep 2016 13:18:22 +0000 Server: Optimizer http://bugs.mysql.com/83071 #83071: MySQL prefers first declared index over more useful other indexes http://bugs.mysql.com/bug.php?id=83071 Submitted by: Kenny Gryp
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.7.14, 5.6.*, 5.7.15
]]> Wed, 21 Sep 2016 08:02:40 +0000 Server: Optimizer http://bugs.mysql.com/83248 #83248: Partition pruning is not working with LEFT JOIN http://bugs.mysql.com/bug.php?id=83248 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.0, 5.7.15
]]> Mon, 03 Oct 2016 15:57:04 +0000 Server: Optimizer http://bugs.mysql.com/83323 #83323: Optimizer chooses wrong plan when joining 2 tables http://bugs.mysql.com/bug.php?id=83323 Submitted by: Alexander Rubin
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.7, 5.6, 8.0.1
]]> Mon, 10 Oct 2016 18:02:33 +0000 Server: Optimizer http://bugs.mysql.com/86036 #86036: InnoDB FULLTEXT index has too strict innodb_ft_result_cache_limit max limit http://bugs.mysql.com/bug.php?id=86036 Submitted by: Valeriy Kravchuk
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Any
Version: 5.7/8.0
]]> Fri, 21 Apr 2017 10:08:42 +0000 Server: InnoDB http://bugs.mysql.com/93360 #93360: mysterious optimizer behavior http://bugs.mysql.com/bug.php?id=93360 Submitted by: dean winchester
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux
Version: 5.6.16,5.7.23
]]> Tue, 27 Nov 2018 09:41:47 +0000 Server: Optimizer http://bugs.mysql.com/100885 #100885: generated column index against json column is not used with different encoding http://bugs.mysql.com/bug.php?id=100885 Submitted by: Nikolai Ikhalainen
Category: Server: JSON
Status: Verified
Severity: 5
OS: Any
Version: 5.7.31
]]> Fri, 18 Sep 2020 03:43:07 +0000 Server: JSON http://bugs.mysql.com/104978 #104978: Adding Join Index forces query optimizer to use inefficient execution plan http://bugs.mysql.com/bug.php?id=104978 Submitted by: Dmitrii Naumov
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Windows
Version: 8.0.26, 5.7.35
]]> Fri, 17 Sep 2021 19:57:07 +0000 Server: Optimizer http://bugs.mysql.com/106473 #106473: Inner table of OUT-JOIN is nullable, after applying OUTER2INNER transformation http://bugs.mysql.com/bug.php?id=106473 Submitted by: Shanshan Ying
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.28
]]> Wed, 16 Feb 2022 08:55:54 +0000 Server: Optimizer http://bugs.mysql.com/99684 #99684: incorrect determination of big test http://bugs.mysql.com/bug.php?id=99684 Submitted by: andy zhang
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6, 5.7, 8.0
]]> Mon, 25 May 2020 12:19:09 +0000 Server: Optimizer http://bugs.mysql.com/108127 #108127: MySQL optimizer chooses to a inefficient index . http://bugs.mysql.com/bug.php?id=108127 Submitted by: Lin TSE YU
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0.29
]]> Fri, 12 Aug 2022 05:57:25 +0000 Server: Optimizer http://bugs.mysql.com/110117 #110117: Lack of instrumentation for index condition impact on the query plan http://bugs.mysql.com/bug.php?id=110117 Submitted by: Przemyslaw Malkowski
Category: Server: Docs
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Fri, 17 Feb 2023 13:22:59 +0000 Server: Docs