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/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/32341 #32341: Subquery does not use index with session variable, works with string literal http://bugs.mysql.com/bug.php?id=32341 Submitted by: Devananda van der Veen
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux
Version: 5.0.41, 5.0.52
]]> Tue, 13 Nov 2007 19:29:55 +0000 Server: Optimizer http://bugs.mysql.com/36422 #36422: EXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins http://bugs.mysql.com/bug.php?id=36422 Submitted by: Sergey Petrunya
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 6.0.x
]]> Wed, 30 Apr 2008 02:19:54 +0000 Server: Optimizer http://bugs.mysql.com/46288 #46288: Index is not used for equality condition on single-row, multiple column subquery http://bugs.mysql.com/bug.php?id=46288 Submitted by: Alex Bolenok
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Windows
Version: 5.1.35-community, 5.1.36
]]> Sat, 18 Jul 2009 19:12:02 +0000 Server: Optimizer http://bugs.mysql.com/49200 #49200: Select_type in explain output incorrect for semijoin queries http://bugs.mysql.com/bug.php?id=49200 Submitted by: Roy Lyseng
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 6.0
]]> Mon, 30 Nov 2009 10:19:17 +0000 Server: Optimizer http://bugs.mysql.com/48190 #48190: Error processing ALL subqueries on empty sets - different than JavaDB/Postgres http://bugs.mysql.com/bug.php?id=48190 Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1,6.0
]]> Tue, 20 Oct 2009 14:59:39 +0000 Server: Optimizer http://bugs.mysql.com/66932 #66932: GREATEST produces invalid result if in subquery with utf8_hungarian_ci collation http://bugs.mysql.com/bug.php?id=66932 Submitted by: Marton Balint
Category: Server: Charsets
Status: Verified
Severity: 3
OS: Linux
Version: 5.5.25a
]]> Sun, 23 Sep 2012 13:32:01 +0000 Server: Charsets http://bugs.mysql.com/70466 #70466: No results when filesorting with a correlation in subquery's HAVING clause http://bugs.mysql.com/bug.php?id=70466 Submitted by: Alan Egerton
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.5,5.6
]]> Mon, 30 Sep 2013 07:24:56 +0000 Server: Optimizer http://bugs.mysql.com/70684 #70684: HAVING referring to subquery results in WARNING 1292 http://bugs.mysql.com/bug.php?id=70684 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.5.33, 5.6.14
]]> Tue, 22 Oct 2013 08:13:59 +0000 Server: Optimizer http://bugs.mysql.com/77191 #77191: Subquery on information_schema including an IN clause, does not return results http://bugs.mysql.com/bug.php?id=77191 Submitted by: William Chiquito
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.6.21, 5.6.24, 5.7.8
]]> Fri, 29 May 2015 09:14:24 +0000 Server: Optimizer http://bugs.mysql.com/79953 #79953: Fulltext-index not found in MySQL 5.7.10 when use GROUP_CONCAT http://bugs.mysql.com/bug.php?id=79953 Submitted by: Oliver Beta
Category: Server: FTS
Status: Verified
Severity: 3
OS: Windows (Win 2012R2)
Version: 5.7.10
]]> Wed, 13 Jan 2016 13:31:42 +0000 Server: FTS http://bugs.mysql.com/78497 #78497: Large select with nested subqueries return 0 rows http://bugs.mysql.com/bug.php?id=78497 Submitted by: Jose Ignacio Andrés
Category: Server: DML
Status: Verified
Severity: 3
OS: Ubuntu
Version: 5.6, 5.6.26, 5.6.28, 5.7.10
]]> Mon, 21 Sep 2015 08:44:52 +0000 Server: DML http://bugs.mysql.com/90245 #90245: Wrong result when using GROUP BY and const value in a subquery http://bugs.mysql.com/bug.php?id=90245 Submitted by: Michał Konarski
Category: Server: DML
Status: Verified
Severity: 3
OS: MacOS (10.13.3)
Version: 5.7/8.0
]]> Wed, 28 Mar 2018 15:23:41 +0000 Server: DML http://bugs.mysql.com/91418 #91418: derived_merge causing inccorect results with distinct subquery and uuid() http://bugs.mysql.com/bug.php?id=91418 Submitted by: Chris Tyler
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.7,8.0.11, 5.7.22
]]> Tue, 26 Jun 2018 07:08:18 +0000 Server: Optimizer http://bugs.mysql.com/104562 #104562: UUID function not executed in implicit subquery, but execute in explicit subquer http://bugs.mysql.com/bug.php?id=104562 Submitted by: Chen Woods
Category: Server: DML
Status: Verified
Severity: 3
OS: Debian (10.9)
Version: 8.0.26
]]> Fri, 06 Aug 2021 16:55:13 +0000 Server: DML http://bugs.mysql.com/109736 #109736: ANY query with wrong result http://bugs.mysql.com/bug.php?id=109736 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Ubuntu (22.04)
Version: 8.0.32
]]> Mon, 23 Jan 2023 10:41:54 +0000 Server: Optimizer http://bugs.mysql.com/111358 #111358: delete handl error http://bugs.mysql.com/bug.php?id=111358 Submitted by: sherman chen
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Mon, 12 Jun 2023 08:41:05 +0000 Server: DML http://bugs.mysql.com/113551 #113551: Discrepancy in MySQL 8.2.0 Documentation Regarding Subquery Scoping Rules http://bugs.mysql.com/bug.php?id=113551 Submitted by: Kang Rong
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (mysql docker image 8.2.0)
Version: 8.2.0
]]> Thu, 04 Jan 2024 10:04:01 +0000 Server: Optimizer http://bugs.mysql.com/120152 #120152: Unexpected behavior of LEFT JOIN + empty subquery with NULL comparison in WHERE clause http://bugs.mysql.com/bug.php?id=120152 Submitted by: Jasper Andrew
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Wed, 25 Mar 2026 08:50:11 +0000 Server: Optimizer http://bugs.mysql.com/120159 #120159: RIGHT JOIN + Complex Subqueries Returns Extra Rows http://bugs.mysql.com/bug.php?id=120159 Submitted by: Jasper Andrew
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Thu, 26 Mar 2026 11:41:59 +0000 Server: Optimizer http://bugs.mysql.com/120191 #120191: TLP bug: Incorrect result under Ternary Logic Partitioning (TLP) with complex RIGHT JOIN chains http://bugs.mysql.com/bug.php?id=120191 Submitted by: Jasper Andrew
Category: Server
Status: Open
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Tue, 31 Mar 2026 13:32:17 +0000 Server