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/35724 #35724: Non-found left join data passed as a parameter to a function in WHERE http://bugs.mysql.com/bug.php?id=35724 Submitted by: Tomas Valenta
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: MySQL 5.0.51a-community-nt, 5.1, 6.0 BK
]]> Mon, 31 Mar 2008 22:24:56 +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/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/68072 #68072: MySQL 5.1 issue with timediff, group by on multiple columns, join, primary key http://bugs.mysql.com/bug.php?id=68072 Submitted by: Gergely Kutenics
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (Win64, CentOS Linux)
Version: 5.1, 5.5
]]> Sat, 12 Jan 2013 18:02:32 +0000 Server: Optimizer http://bugs.mysql.com/84257 #84257: Update of a view made of joined MYISAM tables returns no rows http://bugs.mysql.com/bug.php?id=84257 Submitted by: Vladimír Jilemnický
Category: Server: MyISAM
Status: Verified
Severity: 2
OS: Windows (w10 CZECH NATIONALISATION)
Version: 5.7.17
]]> Mon, 19 Dec 2016 09:58:05 +0000 Server: MyISAM http://bugs.mysql.com/88465 #88465: JOIN is performed incorrectly on TIMESTAMP http://bugs.mysql.com/bug.php?id=88465 Submitted by: Vincent Lavoie
Category: Server: DML
Status: Verified
Severity: 2
OS: Any
Version: 5.7.20
]]> Mon, 13 Nov 2017 16:34:26 +0000 Server: DML http://bugs.mysql.com/105860 #105860: UNION with JOIN USING puts results under wrong column http://bugs.mysql.com/bug.php?id=105860 Submitted by: Ray Cheung
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Fri, 10 Dec 2021 10:17:13 +0000 Server: DML http://bugs.mysql.com/109367 #109367: value changed caused by DISTINCT and JOIN http://bugs.mysql.com/bug.php?id=109367 Submitted by: ZongYin Hao
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.7.22, 8.0.31
]]> Tue, 13 Dec 2022 16:11:19 +0000 Server: Optimizer http://bugs.mysql.com/109726 #109726: Incorrect results with aggregated functions on correlated lateral joins http://bugs.mysql.com/bug.php?id=109726 Submitted by: Anthony Green
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Ubuntu
Version: 8.0.31
]]> Fri, 20 Jan 2023 21:35:34 +0000 Server: Optimizer 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/110656 #110656: Join query with wrong result http://bugs.mysql.com/bug.php?id=110656 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.0.32
]]> Tue, 11 Apr 2023 16:02:57 +0000 Server: Optimizer http://bugs.mysql.com/114301 #114301: Incorrect result with IS NULL predicate in join condition http://bugs.mysql.com/bug.php?id=114301 Submitted by: Yamac Karakus
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Mon, 11 Mar 2024 16:40:13 +0000 Server: Optimizer http://bugs.mysql.com/115161 #115161: hint for join order doesn't work http://bugs.mysql.com/bug.php?id=115161 Submitted by: Wen He
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.4.0
]]> Wed, 29 May 2024 11:28:46 +0000 Server: Optimizer http://bugs.mysql.com/117409 #117409: join with crosse table sort is not optimized away by index http://bugs.mysql.com/bug.php?id=117409 Submitted by: jia liu
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0.35, 8.0.41
]]> Fri, 07 Feb 2025 05:48:49 +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/120187 #120187: Bug: COUNT(*) vs SUM(CASE WHEN ...) returns inconsistent results with NULL-sensitive joins http://bugs.mysql.com/bug.php?id=120187 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 11:46:24 +0000 Server 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 http://bugs.mysql.com/120225 #120225: Inconsistent behavior between SELECT and DELETE/UPDATE with EXISTS and LEFT JOIN subquery http://bugs.mysql.com/bug.php?id=120225 Submitted by: Jasper Andrew
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Tue, 07 Apr 2026 13:40:32 +0000 Server: Optimizer http://bugs.mysql.com/120279 #120279: Severe performance degradation with window function + joins (works fast in PostgreSQL/DuckDB/TiDB) http://bugs.mysql.com/bug.php?id=120279 Submitted by: Jasper Andrew
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Fri, 17 Apr 2026 07:23:27 +0000 Server: Optimizer http://bugs.mysql.com/120363 #120363: LEFT JOIN ON FALSE causes incorrect NULL comparison result in MySQL http://bugs.mysql.com/bug.php?id=120363 Submitted by: Jasper Andrew
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (Docker container)
Version: 8.0.43
]]> Tue, 28 Apr 2026 06:58:24 +0000 Server: Optimizer