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/45373 #45373: INDEX FOR GROUP BY is not used if there is a LIMIT clause in the query http://bugs.mysql.com/bug.php?id=45373 Submitted by: Alex Bolenok
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.35-community, 5.1.36-bzr
]]> Mon, 08 Jun 2009 13:14:02 +0000 Server: Optimizer http://bugs.mysql.com/46135 #46135: LIMIT + JOIN problem http://bugs.mysql.com/bug.php?id=46135 Submitted by: Pavel Bazanov
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.0, 5.1, next, 6.0.0, 6.0.2, 5.1.36
]]> Sun, 12 Jul 2009 19:03:43 +0000 Server: Optimizer http://bugs.mysql.com/46283 #46283: COUNT() returning bad values when LIMIT 1 clause added to query http://bugs.mysql.com/bug.php?id=46283 Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0, 5.1, 5.4, 6.0
]]> Sat, 18 Jul 2009 15:22:49 +0000 Server: Optimizer http://bugs.mysql.com/46648 #46648: SQL_CALC_FOUND_ROWS kills performance with ORDER BY and LIMIT http://bugs.mysql.com/bug.php?id=46648 Submitted by: Jille Timmermans
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (2.6.28.7)
Version: 5.1.32, 4.1, 5.0, 5.1, azalea bzr
]]> Tue, 11 Aug 2009 11:41:04 +0000 Server: Optimizer http://bugs.mysql.com/50168 #50168: The value of 'rows' in EXPLAIN output is not accurate for LIMIT http://bugs.mysql.com/bug.php?id=50168 Submitted by: Mark Callaghan
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0,5.1
]]> Fri, 08 Jan 2010 02:16:52 +0000 Server: Optimizer http://bugs.mysql.com/52613 #52613: Inconsistent and permanent error when attribute name is to long for PK http://bugs.mysql.com/bug.php?id=52613 Submitted by: Geert Vanderkelen
Category: Server: Cluster
Status: Verified
Severity: 2
OS: Any
Version: mysql-5.1-telco-7.0
]]> Tue, 06 Apr 2010 09:04:05 +0000 Server: Cluster http://bugs.mysql.com/55211 #55211: INSERT...SELECT...LIMIT...UNION should be marked unsafe http://bugs.mysql.com/bug.php?id=55211 Submitted by: Sven Sandberg
Category: Server: Replication
Status: Verified
Severity: 2
OS: Any
Version: 5.1+
]]> Tue, 13 Jul 2010 13:50:12 +0000 Server: Replication http://bugs.mysql.com/34310 #34310: Optimizer is inefficient by using ORDER BY function() and LIMIT http://bugs.mysql.com/bug.php?id=34310 Submitted by: Richard Teubel
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux
Version: 5.0.51a-log, 5.0.54, 5.6.14
]]> Tue, 05 Feb 2008 14:51:56 +0000 Server: Optimizer http://bugs.mysql.com/82560 #82560: nested limit produces counter intuitive result http://bugs.mysql.com/bug.php?id=82560 Submitted by: 帅 Bang
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux
Version: 5.5.51, 5.6.32, 5.7.14
]]> Fri, 12 Aug 2016 03:32:05 +0000 Server: DML http://bugs.mysql.com/87644 #87644: Order by on 'datetime' column not working with LIMIT <row_count> http://bugs.mysql.com/bug.php?id=87644 Submitted by: KORBULY Francois
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: CentOS (6 (x86_64))
Version: 5.7.18
]]> Fri, 01 Sep 2017 22:19:02 +0000 Server: Optimizer http://bugs.mysql.com/76398 #76398: MySQL doing full scan depending on limit value with ORDER BY query http://bugs.mysql.com/bug.php?id=76398 Submitted by: Christophe Fondacci
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Any (CentOS, Mac OS X)
Version: 5.6.23, 5.6.25, 5.5.44
]]> Thu, 19 Mar 2015 20:27:33 +0000 Server: InnoDB http://bugs.mysql.com/104127 #104127: output count is unexpected when limit clause is used in CTE http://bugs.mysql.com/bug.php?id=104127 Submitted by: jiangtao guo
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0, 8.0.25
]]> Mon, 28 Jun 2021 07:00:22 +0000 Server: Optimizer http://bugs.mysql.com/110848 #110848: missing considering on order by and limit clause in cost calculation http://bugs.mysql.com/bug.php?id=110848 Submitted by: QIANG TONG
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0.28, 8.0.33
]]> Thu, 27 Apr 2023 15:04:26 +0000 Server: Optimizer