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/120288 #120288: Window function logic mismatch in indexed `NOT IN` http://bugs.mysql.com/bug.php?id=120288 Submitted by: QiFan Liu
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux (Observed on Linux via the `mysql:9.6` )
Version: 8.0.45
]]> Sun, 19 Apr 2026 14:29:16 +0000 Server: Optimizer http://bugs.mysql.com/120306 #120306: ALGORITHM=INPLACE allows creating a VIRTUAL GENERATED COLUMN with invalid expressions for existing data, causing subsequ http://bugs.mysql.com/bug.php?id=120306 Submitted by: fei yang
Category: Server: DDL
Status: Verified
Severity: 3
OS: Any
Version: 8.0.43
]]> Tue, 21 Apr 2026 02:23:53 +0000 Server: DDL http://bugs.mysql.com/120305 #120305: Ubuntu 24.04 Noble: fresh install with mysql-apt-config fails apt update with NO_PUBKEY 9D769D5183E7DDC8 http://bugs.mysql.com/bug.php?id=120305 Submitted by: Robert Shemer
Category: MySQL Repository
Status: Open
Severity: 1
OS: Ubuntu (24.04 Noble cloud image)
Version: 8.4
]]> Tue, 21 Apr 2026 02:16:15 +0000 MySQL Repository http://bugs.mysql.com/120302 #120302: Inconsistent results between VIEW and CTE involving YEAR(DATETIME), UNION, and JOIN. http://bugs.mysql.com/bug.php?id=120302 Submitted by: Niu Xiaoxu
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 9.6.0
]]> Mon, 20 Apr 2026 09:51:04 +0000 Server: Optimizer http://bugs.mysql.com/120300 #120300: Window function logic mismatch across engines http://bugs.mysql.com/bug.php?id=120300 Submitted by: QiFan Liu
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (Observed on Linux via the `mysql:9.6` )
Version: 8.0.45
]]> Mon, 20 Apr 2026 09:02:42 +0000 Server: Optimizer http://bugs.mysql.com/120299 #120299: mismatch in `DELETE ... EXISTS` under window function query http://bugs.mysql.com/bug.php?id=120299 Submitted by: QiFan Liu
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux (Observed on Linux via the `mysql:9.6` )
Version: 9.6
]]> Mon, 20 Apr 2026 09:00:30 +0000 Server: Optimizer http://bugs.mysql.com/120297 #120297: query_term.cc:320 assert(false) crash — UNION query triggers unhandled AccessPath http://bugs.mysql.com/bug.php?id=120297 Submitted by: Chunling Qin
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0.32
]]> Mon, 20 Apr 2026 08:44:43 +0000 Server: Optimizer http://bugs.mysql.com/120294 #120294: Inconsistent fractional seconds precision (FSP) for TIME function results between VIEW and CTE http://bugs.mysql.com/bug.php?id=120294 Submitted by: Niu Xiaoxu
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.45
]]> Sun, 19 Apr 2026 17:16:56 +0000 Server: Optimizer http://bugs.mysql.com/120293 #120293: Query result inconsistency between VIEW and CTE involving a UNION of scalar aggregation and grouped aggregation http://bugs.mysql.com/bug.php?id=120293 Submitted by: Niu Xiaoxu
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.45
]]> Sun, 19 Apr 2026 17:10:22 +0000 Server: Optimizer http://bugs.mysql.com/120292 #120292: Inconsistent results between VIEW and CTE involving IN subquery and RIGHT JOIN http://bugs.mysql.com/bug.php?id=120292 Submitted by: Niu Xiaoxu
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0.45
]]> Sun, 19 Apr 2026 17:01:52 +0000 Server: Optimizer http://bugs.mysql.com/120291 #120291: Inconsistent results between VIEW and CTE involving EXISTS subquery and LEFT JOIN http://bugs.mysql.com/bug.php?id=120291 Submitted by: Niu Xiaoxu
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0.45
]]> Sun, 19 Apr 2026 16:45:04 +0000 Server: Optimizer http://bugs.mysql.com/120290 #120290: i cannot import using import wizard and it is required http://bugs.mysql.com/bug.php?id=120290 Submitted by: Alex Watenga
Category: Server
Status: Open
Severity: 3
OS: Any
]]> Sun, 19 Apr 2026 15:37:01 +0000 Server http://bugs.mysql.com/120289 #120289: Mismatch in indexed `IN` under windows function query http://bugs.mysql.com/bug.php?id=120289 Submitted by: QiFan Liu
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux (Observed on Linux via the `mysql:9.6` )
Version: 9.6
]]> Sun, 19 Apr 2026 14:35:54 +0000 Server: Optimizer http://bugs.mysql.com/120268 #120268: Clarify Symbolic Link Usage and Alternative for InnoDB http://bugs.mysql.com/bug.php?id=120268 Submitted by: Jean-François Gagné
Category: Server: Docs
Status: Open
Severity: 1
OS: Any
Version: 5.7, 8.0, 8.4, 9.x
]]> Tue, 14 Apr 2026 19:38:36 +0000 Server: Docs http://bugs.mysql.com/120287 #120287: Non-identifying relationships show up as identifying relationships http://bugs.mysql.com/bug.php?id=120287 Submitted by: Louis Tjiong
Category: MySQL Workbench: Modeling
Status: Open
Severity: 3
OS: Any
Version: 8.0 CE
]]> Sun, 19 Apr 2026 10:18:12 +0000 MySQL Workbench: Modeling http://bugs.mysql.com/120286 #120286: `SUM(DISTINCT pk)` returns `NULL` with a window function when a secondary index is used for group-by scanning http://bugs.mysql.com/bug.php?id=120286 Submitted by: Peiyuan Liu
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0.45
]]> Sun, 19 Apr 2026 05:14:56 +0000 Server: Optimizer http://bugs.mysql.com/120281 #120281: replica_preserve_commit_order causes infinite deadlock in group commit pipeline, blocking all application writes http://bugs.mysql.com/bug.php?id=120281 Submitted by: Abhijith p
Category: Server: Replication
Status: Open
Severity: 2
OS: Linux (any)
Version: 8.0.42
]]> Fri, 17 Apr 2026 09:21:22 +0000 Server: Replication 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: 3
OS: Any
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Fri, 17 Apr 2026 07:23:27 +0000 Server: Optimizer http://bugs.mysql.com/120278 #120278: mts_event_coord_cmp() uses strcmp() for binlog filename comparison, causing incorrect ordering when binlog index exceeds http://bugs.mysql.com/bug.php?id=120278 Submitted by: Demon Chen
Category: Server: Replication
Status: Open
Severity: 3
OS: Any
Version: 8.0 8.4
]]> Fri, 17 Apr 2026 02:44:03 +0000 Server: Replication http://bugs.mysql.com/120272 #120272: ddl stuck in Waiting for clone PAGE_COPY state http://bugs.mysql.com/bug.php?id=120272 Submitted by: yl deng
Category: Server: InnoDB
Status: Open
Severity: 2
OS: Any
Version: 8.0.45
]]> Wed, 15 Apr 2026 11:21:33 +0000 Server: InnoDB http://bugs.mysql.com/120271 #120271: Logic error: EXISTS subquery treated as constant TRUE yields different result than literal TRUE http://bugs.mysql.com/bug.php?id=120271 Submitted by: Jasper Andrew
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Wed, 15 Apr 2026 10:54:33 +0000 Server: Optimizer http://bugs.mysql.com/120270 #120270: Incorrect result for INTERSECT ALL with semantically equivalent EXCEPT operands when right EXCEPT left operand is wrap http://bugs.mysql.com/bug.php?id=120270 Submitted by: Guo Yuxiao
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.45
]]> Wed, 15 Apr 2026 09:49:38 +0000 Server: Optimizer http://bugs.mysql.com/120269 #120269: Wrong result in string comparison with JSON_UNQUOTE(JSON_EXTRACT(...)) http://bugs.mysql.com/bug.php?id=120269 Submitted by: Guo Yuxiao
Category: Server
Status: Open
Severity: 1
OS: Any
Version: 9.6.0
]]> Wed, 15 Apr 2026 07:40:42 +0000 Server 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/120284 #120284: Materialized `IN (subquery)` Loses VARCHAR-to-YEAR Coercion,Causing Plan-Dependent Result Divergence http://bugs.mysql.com/bug.php?id=120284 Submitted by: Y F
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Ubuntu (Ubuntu 20.04.4 LTS)
Version: 8.0.45
]]> Sat, 18 Apr 2026 15:46:42 +0000 Server: Optimizer http://bugs.mysql.com/120275 #120275: DATE Index Lookup Loses Existing JOIN Matches Even with Explicit CAST(MEDIUMTEXT AS DATE), Causing S1/S2 Divergence http://bugs.mysql.com/bug.php?id=120275 Submitted by: Y F
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Ubuntu (Ubuntu 20.04.4 LTS)
Version: 8.0.45
]]> Thu, 16 Apr 2026 07:10:44 +0000 Server: Optimizer http://bugs.mysql.com/120296 #120296: Materialized Correlated EXISTS Loses Implicit VARCHAR-to-YEAR Coercion,Causing Plan-Dependent Result Divergence http://bugs.mysql.com/bug.php?id=120296 Submitted by: Y F
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Ubuntu (Ubuntu 20.04.4 LTS)
Version: 8.0.45
]]> Mon, 20 Apr 2026 07:50:54 +0000 Server: Optimizer http://bugs.mysql.com/120274 #120274: Specific account authentication permanently fails with "Public Key Retrieval is not allowed" after FLUSH PRIVILEGES http://bugs.mysql.com/bug.php?id=120274 Submitted by: SeWoong Jeon
Category: Server: Connection Handling
Status: Open
Severity: 2
OS: Red Hat (Rocky Linux 8.8)
Version: 8.4.6
]]> Thu, 16 Apr 2026 05:53:42 +0000 Server: Connection Handling http://bugs.mysql.com/120273 #120273: Incorrect COUNT result when "SET SESSION internal_tmp_mem_storage_engine = MEMORY" is used http://bugs.mysql.com/bug.php?id=120273 Submitted by: jinhui lai
Category: Server: Memory
Status: Verified
Severity: 2
OS: Ubuntu (22.04)
Version: 8.0.45
]]> Wed, 15 Apr 2026 15:39:48 +0000 Server: Memory http://bugs.mysql.com/120304 #120304: MySQL 8.0.44 crashes with InnoDB assertion failure on replica when TRUNCATE TABLE is applied to a table whose tablespace http://bugs.mysql.com/bug.php?id=120304 Submitted by: zyshe kolodny
Category: Server: InnoDB
Status: Open
Severity: 1
OS: CentOS (07)
Version: 8.0.44
]]> Mon, 20 Apr 2026 22:05:18 +0000 Server: InnoDB