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/34621 #34621: ODBC - Update fails, if a "ORDER BY" clause is specified http://bugs.mysql.com/bug.php?id=34621 Submitted by: Diego Milazzo
Category: Connector/ODBC
Status: Verified
Severity: 2
OS: Windows (XP with SP2)
Version: ODBC 5.1.2 - MySQL 5.0.51a
]]> Sat, 16 Feb 2008 21:05:51 +0000 Connector/ODBC http://bugs.mysql.com/44943 #44943: ORDER BY on SHOW INDEXES http://bugs.mysql.com/bug.php?id=44943 Submitted by: Jared S
Category: Server
Status: Verified
Severity: 3
OS: Any (NT)
Version: 5.1.34, 4.1, 5.0, 5.1, 6.0 bzr
]]> Tue, 19 May 2009 04:35:23 +0000 Server http://bugs.mysql.com/65899 #65899: "order by" clause returns wrong order result data (BIG5 COLLATE big5_chinese_ci) http://bugs.mysql.com/bug.php?id=65899 Submitted by: Michael Lee
Category: Server: Charsets
Status: Verified
Severity: 2
OS: Any
Version: 5.x, 5.5.26
]]> Sat, 14 Jul 2012 15:19:49 +0000 Server: Charsets http://bugs.mysql.com/113135 #113135: DISTINCT JOIN ORDER BY statements ignore ORDER BY when tmp_table_size is small http://bugs.mysql.com/bug.php?id=113135 Submitted by: Xizhe Zhang
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Mon, 20 Nov 2023 03:03:15 +0000 Server: DML http://bugs.mysql.com/69670 #69670: Dependent subquery with ORDER BY returns empty string http://bugs.mysql.com/bug.php?id=69670 Submitted by: Matthias Brendel
Category: Server: DML
Status: Verified
Severity: 1
OS: Linux (Debian )
Version: 5.5.31/5.5.32
]]> Thu, 04 Jul 2013 11:37:40 +0000 Server: DML http://bugs.mysql.com/85533 #85533: Incorrect sorting result while substring_index function http://bugs.mysql.com/bug.php?id=85533 Submitted by: Vardan Shahinyan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.16-log, 5.5.54, 5.6.35, 5.7.17
]]> Mon, 20 Mar 2017 09:17:39 +0000 Server: DML http://bugs.mysql.com/87835 #87835: the combination of SELECT DISTINCT and ORDER BY give wrong result for some data http://bugs.mysql.com/bug.php?id=87835 Submitted by: Lin Lu
Category: Server: DML
Status: Verified
Severity: 1
OS: Ubuntu (Ubuntu 16.04.2 LTS)
Version: 5.7.19
]]> Fri, 22 Sep 2017 08:19:46 +0000 Server: DML http://bugs.mysql.com/100822 #100822: the result of group_concat(field1 order by field2) is unexpect. http://bugs.mysql.com/bug.php?id=100822 Submitted by: GONGTUI FU
Category: Server: DML
Status: Verified
Severity: 3
OS: Red Hat (7.4)
Version: 8.0/5.7/5.6
]]> Sat, 12 Sep 2020 14:39:16 +0000 Server: DML http://bugs.mysql.com/69100 #69100: CAST in IF function fails in some case http://bugs.mysql.com/bug.php?id=69100 Submitted by: Gabriel Delépine
Category: Server: InnoDB
Status: Verified
Severity: 1
OS: Linux (Debian 6 / Debian 7 / Ubuntu 12.10 / Windows 8)
Version: 5.5.31-0, 5.5.30-1, 5.5.29-0, 5.5.25-1, 5.5.16, 5.5.30-1.1, 5.6.10, 5.0.97, 5.1.70, 5.5.29, 5.7.2
]]> Tue, 30 Apr 2013 09:53:07 +0000 Server: InnoDB 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/119442 #119442: Optimizer fails to simplify ORDER BY when column is filtered by IS NULL, causing filesort http://bugs.mysql.com/bug.php?id=119442 Submitted by: Kishore Kumar
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.4.4
]]> Fri, 21 Nov 2025 20:13:10 +0000 Server: Optimizer http://bugs.mysql.com/115843 #115843: The incorrect calculation of 'select_limit' led to an incorrect index selection http://bugs.mysql.com/bug.php?id=115843 Submitted by: ksql- team
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0.32, 8.0.39
]]> Thu, 15 Aug 2024 08:26:14 +0000 Server: Optimizer http://bugs.mysql.com/111415 #111415: Correlated group query wrong result http://bugs.mysql.com/bug.php?id=111415 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Wed, 14 Jun 2023 09:39:11 +0000 Server: Optimizer 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/59557 #59557: MySQL uses order of fields in GROUP BY when ORDER BY NULL is specified http://bugs.mysql.com/bug.php?id=59557 Submitted by: Shlomo Priymak
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1, 5.5
]]> Mon, 17 Jan 2011 15:26:08 +0000 Server: Optimizer http://bugs.mysql.com/46011 #46011: Regression after applying fix for bug #45828 http://bugs.mysql.com/bug.php?id=46011 Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1-bugteam
]]> Tue, 07 Jul 2009 14:05:37 +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/38397 #38397: select distinct + order by desc is executed inefficiently http://bugs.mysql.com/bug.php?id=38397 Submitted by: Vladimir Kolesnikov
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.26, 5.0.62
]]> Sun, 27 Jul 2008 20:13:19 +0000 Server: Optimizer