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/117791 #117791: FORCE INDEX does not skip records_in_range() for 'x IS NULL' http://bugs.mysql.com/bug.php?id=117791 Submitted by: Kaiwang CHen
Category: Server: Optimizer
Status: Open
Severity: 3
OS: Any
Version: 8.0, 8.4, 9.2
]]> Tue, 25 Mar 2025 13:30:07 +0000 Server: Optimizer http://bugs.mysql.com/119909 #119909: Wrong result due to unsafe Item_max optimization triggering on homogeneous subqueries but not heterogeneous ones http://bugs.mysql.com/bug.php?id=119909 Submitted by: Seren Zhou
Category: Server: Optimizer
Status: Open
Severity: 2
OS: Any
Version: 9.5.0
]]> Thu, 12 Feb 2026 21:31:30 +0000 Server: Optimizer http://bugs.mysql.com/120285 #120285: Materialized Semijoin + Outer ORDER BY Loses Rows for Correlated EXISTS,Causing Plan-Dependent Result Divergence http://bugs.mysql.com/bug.php?id=120285 Submitted by: Y F
Category: Server: Optimizer
Status: Open
Severity: 2
OS: Ubuntu (Ubuntu 20.04.4 LTS)
Version: 8.0.45
]]> Sat, 18 Apr 2026 15:49:34 +0000 Server: Optimizer http://bugs.mysql.com/120574 #120574: Range optimizer exceeds memory limit and chooses bad range plan for large IN lists http://bugs.mysql.com/bug.php?id=120574 Submitted by: Qingping Zhu
Category: Server: Optimizer
Status: Open
Severity: 2
OS: Any
Version: 8.0.41
]]> Fri, 29 May 2026 14:05:16 +0000 Server: Optimizer http://bugs.mysql.com/120575 #120575: Range optimizer chooses bad range plan for large IN lists and execution is very slow and memory usage spikes. http://bugs.mysql.com/bug.php?id=120575 Submitted by: hel le
Category: Server: Optimizer
Status: Open
Severity: 2
OS: Any
Version: 8.0.41+
]]> Sat, 30 May 2026 06:57:19 +0000 Server: Optimizer http://bugs.mysql.com/120607 #120607: Join-order enumeration ignores ORDER BY sort cost http://bugs.mysql.com/bug.php?id=120607 Submitted by: Yuchen Sun
Category: Server: Optimizer
Status: Open
Severity: 5
OS: Any
Version: 9.6
]]> Wed, 03 Jun 2026 07:22:23 +0000 Server: Optimizer http://bugs.mysql.com/120608 #120608: prefer_ordering_index makes a filtered ORDER BY pk LIMIT query do a full primary-key scan instead of a filtering index r http://bugs.mysql.com/bug.php?id=120608 Submitted by: Yuchen Sun
Category: Server: Optimizer
Status: Open
Severity: 5
OS: Any
Version: 9.6
]]> Wed, 03 Jun 2026 07:27:56 +0000 Server: Optimizer http://bugs.mysql.com/120666 #120666: Optimizer fails to convert ABS(column) < constant to range scan, resulting in full table scan http://bugs.mysql.com/bug.php?id=120666 Submitted by: jinhui lai
Category: Server: Optimizer
Status: Open
Severity: 5
OS: Any
Version: 9.7.0
]]> Fri, 12 Jun 2026 15:58:22 +0000 Server: Optimizer