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/7080 #7080: Optimizer choose incorrect index http://bugs.mysql.com/bug.php?id=7080 Submitted by: Victoria Reznichenko
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.0
]]> Tue, 07 Dec 2004 15:23:30 +0000 Server: Optimizer http://bugs.mysql.com/7604 #7604: Row subqueries don't work with ALL http://bugs.mysql.com/bug.php?id=7604 Submitted by: Peter Gulutzan
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.21-BK, 6.0.14
]]> Fri, 31 Dec 2004 20:13:04 +0000 Server: Optimizer http://bugs.mysql.com/8036 #8036: Bad optimization of ORDER BY ... LIMIT 1 if one table is MyISAM, another InnoDB http://bugs.mysql.com/bug.php?id=8036 Submitted by: Nick Peterson
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: FreeBSD (Free BSD 4.5, Linux)
Version: 4.0.18, 4.1.10, 5.1.52
]]> Thu, 20 Jan 2005 10:12:51 +0000 Server: Optimizer http://bugs.mysql.com/8113 #8113: Select with between optimization http://bugs.mysql.com/bug.php?id=8113 Submitted by: Emmanuel van der Meulen
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 5.0, 5.1, azalea bzr
]]> Mon, 24 Jan 2005 15:43:39 +0000 Server: Optimizer http://bugs.mysql.com/8662 #8662: optimizer, query takes 3 to 10 times as long when using index http://bugs.mysql.com/bug.php?id=8662 Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 6.0.14, 5.1.12-BK, 4.1.10
]]> Mon, 21 Feb 2005 21:31:23 +0000 Server: Optimizer http://bugs.mysql.com/8749 #8749: EXPLAIN report different "type" w and w/o USE INDEX(...) for the same used key http://bugs.mysql.com/bug.php?id=8749 Submitted by: jocelyn fournier
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any (*)
Version: 4.1.10, 5.0.67
]]> Wed, 23 Feb 2005 21:08:11 +0000 Server: Optimizer http://bugs.mysql.com/11948 #11948: MyISAM only, nested JOIN Views, dramatic performance loss http://bugs.mysql.com/bug.php?id=11948 Submitted by: Matthias Leich
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0
]]> Thu, 14 Jul 2005 18:00:15 +0000 Server: Optimizer http://bugs.mysql.com/12113 #12113: Composite index chosen partially for ORDER BY ... LIMIT query. http://bugs.mysql.com/bug.php?id=12113 Submitted by: Domas Mituzas
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 5.0.28-BK, 4.0,5.0
]]> Fri, 22 Jul 2005 14:23:01 +0000 Server: Optimizer http://bugs.mysql.com/12799 #12799: one result returned when change from summer time causes dup unique key recs http://bugs.mysql.com/bug.php?id=12799 Submitted by: James Day
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Windows (windows xp)
Version: 5.0.10-log, 4.1.13a-log on win, 4.1 on RHES3.0
]]> Thu, 25 Aug 2005 09:46:52 +0000 Server: Optimizer http://bugs.mysql.com/14084 #14084: index_merge access method not used for federated engine http://bugs.mysql.com/bug.php?id=14084 Submitted by: Sergey Petrunya
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0-bk
]]> Mon, 17 Oct 2005 20:09:56 +0000 Server: Optimizer http://bugs.mysql.com/14253 #14253: Optimizer uses partial indexes for subqueries, where it should not http://bugs.mysql.com/bug.php?id=14253 Submitted by: Domas Mituzas
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0, 4.1, 6.0.14-bzr
]]> Mon, 24 Oct 2005 09:26:12 +0000 Server: Optimizer http://bugs.mysql.com/15907 #15907: Binary comparison ignores indexes http://bugs.mysql.com/bug.php?id=15907 Submitted by: Jon Bright
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux (Linux)
Version: 5.0.19-BK, 5.0.13, 6.0.14-bzr
]]> Wed, 21 Dec 2005 15:23:00 +0000 Server: Optimizer http://bugs.mysql.com/17259 #17259: Query optimizer chooses wrong index http://bugs.mysql.com/bug.php?id=17259 Submitted by: Brad Green
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux (Linux)
Version: 5.0.15, 6.0.7
]]> Thu, 09 Feb 2006 02:23:04 +0000 Server: Optimizer http://bugs.mysql.com/17299 #17299: Inefficient optimizer for fulltext queries. http://bugs.mysql.com/bug.php?id=17299 Submitted by: Andre Timmer
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any (All)
Version: 5.0.18
]]> Fri, 10 Feb 2006 12:35:42 +0000 Server: Optimizer http://bugs.mysql.com/18465 #18465: Optimizer/execution plan bug with dependent subqueries in ON clauses of JOINs http://bugs.mysql.com/bug.php?id=18465 Submitted by: Beat Vontobel
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (any)
Version: 5.0.20-BK, 5.0.19, 5.0.85
]]> Thu, 23 Mar 2006 17:43:41 +0000 Server: Optimizer http://bugs.mysql.com/18688 #18688: non-optimal plan for SELECT http://bugs.mysql.com/bug.php?id=18688 Submitted by: Victoria Reznichenko
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (linux)
Version: 4.0, 4.1, 5.0
]]> Fri, 31 Mar 2006 14:07:35 +0000 Server: Optimizer http://bugs.mysql.com/19195 #19195: Optimizer does not use proper index for join http://bugs.mysql.com/bug.php?id=19195 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.27-BK, 5.0.21-BK, 5.0.19
]]> Wed, 19 Apr 2006 12:09:46 +0000 Server: Optimizer http://bugs.mysql.com/20111 #20111: named columns used in subqueries hinder optimisation of LIKE, BETWEEN, range http://bugs.mysql.com/bug.php?id=20111 Submitted by: Daniel Treplin
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux (Linux)
Version: 4.1.19-log
]]> Sun, 28 May 2006 10:57:40 +0000 Server: Optimizer http://bugs.mysql.com/24697 #24697: insert .. select ....ON DUPLICATE KEY UPDATE fails with ambiguous column name http://bugs.mysql.com/bug.php?id=24697 Submitted by: Dave Pullin
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Windows (Windows 2000 and Linux)
Version: 5.0.24a-community-nt-log/4.1BK/5.0BK/5.1BK
]]> Wed, 29 Nov 2006 15:13:33 +0000 Server: Optimizer http://bugs.mysql.com/24754 #24754: Index is not used when joining two tables http://bugs.mysql.com/bug.php?id=24754 Submitted by: Alexander Barkov
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.1.14, 5.1.43-bzr
]]> Fri, 01 Dec 2006 13:34:26 +0000 Server: Optimizer http://bugs.mysql.com/25068 #25068: MyISAM-Optimizer prefers full table scan than index for IN with >15 elements http://bugs.mysql.com/bug.php?id=25068 Submitted by: Anders Henke
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.0.27, 5.0.19, 5.0.36-BK
]]> Thu, 14 Dec 2006 11:56:09 +0000 Server: Optimizer http://bugs.mysql.com/25764 #25764: Query Cost Estimate seems to only cover a part of subqueries, not full query. http://bugs.mysql.com/bug.php?id=25764 Submitted by: Tobias Asplund
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux, Mac OS X)
Version: 5.0.36-BK, 6.0.8-bzr
]]> Mon, 22 Jan 2007 20:59:13 +0000 Server: Optimizer 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/26284 #26284: bug #26273 / optimize, not executed for index, if datafile is gap-free http://bugs.mysql.com/bug.php?id=26284 Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.bk
]]> Mon, 12 Feb 2007 12:32:58 +0000 Server: Optimizer http://bugs.mysql.com/26832 #26832: ENUM types not optimized http://bugs.mysql.com/bug.php?id=26832 Submitted by: Roberto Spadim
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 5.5
]]> Sun, 04 Mar 2007 18:17:45 +0000 Server: Optimizer http://bugs.mysql.com/27452 #27452: Correlated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA http://bugs.mysql.com/bug.php?id=27452 Submitted by: Jay Pipes
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux
Version: 5.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzr
]]> Mon, 26 Mar 2007 17:35:17 +0000 Server: Optimizer http://bugs.mysql.com/28404 #28404: Optimizer does not consider index that can be used for ORDER BY http://bugs.mysql.com/bug.php?id=28404 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux
Version: 4.0.31, 4.1.25, 4.1.26, 5.0.42-BK, 5.0.46, 5.1.33
]]> Sun, 13 May 2007 18:33:11 +0000 Server: Optimizer http://bugs.mysql.com/28554 #28554: Optimizer wrongly prefers index for (col = value) over (PK <= value) http://bugs.mysql.com/bug.php?id=28554 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 4.1.22, 5.0.42-BK
]]> Mon, 21 May 2007 09:32:16 +0000 Server: Optimizer http://bugs.mysql.com/29421 #29421: MySQL allows mixing of GROUP columns with no GROUP columns in complex terms http://bugs.mysql.com/bug.php?id=29421 Submitted by: Szymon Nowakowski
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1.14-beta/5.0
]]> Thu, 28 Jun 2007 13:43:41 +0000 Server: Optimizer http://bugs.mysql.com/29433 #29433: composite index not used http://bugs.mysql.com/bug.php?id=29433 Submitted by: Jacek Becla
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0.27, 5.0, 5.1, 4.1, 5.2 BK, 6.0.14-bzr
]]> Fri, 29 Jun 2007 00:03:28 +0000 Server: Optimizer