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/44397 #44397: Negative relevancy value for boolean fulltext query using a left join http://bugs.mysql.com/bug.php?id=44397 Submitted by: Tim McLaughlin
Category: Server: FTS
Status: Verified
Severity: 2
OS: Any
Version: 5.0.79, 5.1.33, 5.1.34, 6.0.9
]]> Wed, 22 Apr 2009 02:46:02 +0000 Server: FTS http://bugs.mysql.com/47454 #47454: Not exists optimization method is not used for NULL columns in the right table http://bugs.mysql.com/bug.php?id=47454 Submitted by: Alex Bolenok
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.35
]]> Sat, 19 Sep 2009 19:33:40 +0000 Server: Optimizer http://bugs.mysql.com/105637 #105637: left join + semijoin produce wrong results when using materialization strategy http://bugs.mysql.com/bug.php?id=105637 Submitted by: Xiaodi Z
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0.25, 8.0.27
]]> Fri, 19 Nov 2021 09:52:21 +0000 Server: Optimizer http://bugs.mysql.com/107585 #107585: Incorrect result in semi-join and left-join http://bugs.mysql.com/bug.php?id=107585 Submitted by: Wang Ke
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (ubuntu 20.04)
Version: 8.0.29
]]> Fri, 17 Jun 2022 10:29:11 +0000 Server: Optimizer http://bugs.mysql.com/110614 #110614: Left join query with wrong result http://bugs.mysql.com/bug.php?id=110614 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Wed, 05 Apr 2023 08:32:09 +0000 Server: Optimizer http://bugs.mysql.com/109155 #109155: Invalid scan on left join tables of which columns not in distinct output fields http://bugs.mysql.com/bug.php?id=109155 Submitted by: Chen Wang
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0.18, 8.0.31, 8.0.35
]]> Tue, 22 Nov 2022 05:43:18 +0000 Server: Optimizer http://bugs.mysql.com/115565 #115565: Partition tables:compare the field with null and return an incorrect result http://bugs.mysql.com/bug.php?id=115565 Submitted by: GONGTUI FU
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Thu, 11 Jul 2024 09:37:28 +0000 Server: Optimizer http://bugs.mysql.com/115559 #115559: Row constructor comparison with nested join fails to match rows http://bugs.mysql.com/bug.php?id=115559 Submitted by: Timothy Liang
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Wed, 10 Jul 2024 13:59:15 +0000 Server: Optimizer http://bugs.mysql.com/119447 #119447: Prepare Statement execute much slower than normal select query http://bugs.mysql.com/bug.php?id=119447 Submitted by: Qingping Zhu
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: CentOS
Version: 8.0.41
]]> Sun, 23 Nov 2025 08:34:44 +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