| Showing all 245 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 120582 | 2026-05-31 10:11 | 2026-05-31 10:11 | MySQL Server: Optimizer | Open | S3 | 8.0.44 | MacOS | Any | unique index causes incorrect result when comparing DOUBLE and BIGINT |
| 120581 | 2026-05-31 9:02 | 2026-05-31 9:02 | MySQL Server: Optimizer | Open | S2 | 8.0.44 | MacOS | Any | unique index causes incorrect result for IN comparison with implicit type conversion |
| 120580 | 2026-05-31 7:52 | 2026-05-31 7:53 | MySQL Server: Optimizer | Open | S3 | 8.0.44 | Any | Any | MyISAM prefix index causes incorrect range query result |
| 120579 | 2026-05-30 11:39 | 2026-05-30 11:39 | MySQL Server: Optimizer | Open | S3 | 8.0.45 | Any | Any | LIKE query returns inconsistent results with MyISAM prefix index |
| 120578 | 2026-05-30 9:05 | 2026-05-30 9:05 | MySQL Server: Optimizer | Open | S3 | 8.0.45 | Any | Any | Multiple-Column Index Creation Changes Query Results |
| 120575 | 2026-05-30 6:57 | 2026-05-30 6:57 | MySQL Server: Optimizer | Open | S2 | 8.0.41+ | Any | Any | Range optimizer chooses bad range plan for large IN lists and execution is very slow and memory usage spikes. |
| 120574 | 2026-05-29 14:05 | 2026-05-29 14:12 | MySQL Server: Optimizer | Open | S2 | 8.0.41 | Any | Any | Range optimizer exceeds memory limit and chooses bad range plan for large IN lists |
| 120564 | 2026-05-29 6:43 | 2026-05-29 6:46 | MySQL Server: InnoDB storage engine | Open | S3 | 9.7.0 | Any | Any | InnoDB FTS: Off-by-one error in fts_init_index() causes unsynced document to be lost after crash recovery |
| 120562 | 2026-05-28 12:53 | 2026-05-28 12:53 | MySQL Server: InnoDB storage engine | Open | S1 | 9.6.0 | Linux | Any | InnoDB crashes with assertion failure when UPDATE touches a table with many secondary indexes |
| 120561 | 2026-05-28 11:11 | 2026-05-29 4:41 | MySQL Server: DDL | Open (3 days) | S3 | 9.7/8.4/8.0 | Any | Any | tablespace marked missing after rollback of copy-style ALTER |
| 120558 | 2026-05-27 11:21 | 2026-05-27 11:41 | MySQL Server: InnoDB storage engine | Open (4 days) | S3 | 8.4.8 | Any | Any | Redo log archiving started by dead connection cannot be disabled later |
| 120555 | 2026-05-27 8:22 | 2026-05-27 11:39 | MySQL Server: Optimizer | Verified (4 days) | S2 | 8.0.45 | Ubuntu | Any | Equivalent VIEW and CTE queries return different row counts with EXISTS, BINARY ENUM comparison, and LEFT JOIN |
| 120544 | 2026-05-25 10:47 | 2026-05-27 12:38 | MySQL Server: Optimizer | Duplicate (4 days) | S3 | 8.4.8 | Any | Any | MySQL `MERGE` vs `TEMPTABLE` view evaluation changes `CROSS JOIN ... ON EXISTS(...)` cardinality |
| 120543 | 2026-05-25 9:57 | 2026-05-27 5:37 | MySQL Server: Optimizer | Verified (4 days) | S2 | 8.4.8 | Any | Any | MySQL `MERGE` vs `TEMPTABLE` view evaluation changes `MAX(SET)` result |
| 120540 | 2026-05-25 1:44 | 2026-05-29 5:20 | MySQL Server: Optimizer | Patch pending (4 days) | S2 | 9.7.0 | Ubuntu | x86 | A negated `IS TRUE` guard can still match a DECIMAL row for which the guarded predicate is true |
| 120539 | 2026-05-24 15:26 | 2026-05-24 15:26 | MySQL Server: FULLTEXT search | Open | S2 | 9.6.0 | Linux | Any | Duplicate FULLTEXT index on a column returns wrong MATCH...AGAINST results when combined with a STORED generated column |
| 120538 | 2026-05-24 13:46 | 2026-05-27 13:53 | MySQL Server: Optimizer | Duplicate (4 days) | S2 | 9.7.0 | Ubuntu | x86 | A RIGHT JOIN predicate treats IFNULL(NULL, non-NULL DECIMAL ZEROFILL) as non-matching and drops obvious rows |
| 120535 | 2026-05-24 5:29 | 2026-05-26 12:42 | MySQL Server: Optimizer | Verified (5 days) | S3 | 8.0.45 | Any | Any | Incorrect Query Result: IN and NOT IN return the same row simultaneously (boolean logic violation) |
| 120534 | 2026-05-24 5:19 | 2026-05-26 12:26 | MySQL Server: Optimizer | Verified (5 days) | S3 | 8.0.45 | Any | Any | Wrong Query Result Due to Incorrect Evaluation of GREATEST() with Mixed Types in OR (||) Boolean Context |
| 120533 | 2026-05-23 12:35 | 2026-05-26 8:30 | MySQL Server: Optimizer | Verified (5 days) | S2 | 8.0.45 | Ubuntu | x86 | A LEFT JOIN over DECIMAL ZEROFILL UNIQUE wrongly loses an obvious match |
| 120532 | 2026-05-23 12:34 | 2026-05-27 13:43 | MySQL Server: Optimizer | Duplicate (4 days) | S2 | 9.7.0 | Ubuntu | x86 | An unused derived subquery triggers a DISTINCT/IFNULL wrong-result in the original path |
| 120531 | 2026-05-23 12:33 | 2026-05-26 7:24 | MySQL Server: Optimizer | Verified (5 days) | S2 | 8.0.45 | Ubuntu | x86 | A NULL comparison inside an IN subquery becomes spuriously true in the original path |
| 120529 | 2026-05-22 17:08 | 2026-05-27 16:48 | MySQL Server: InnoDB storage engine | Open | S3 | Any | Any | Contribution: Log a warning when history list length exceeds threshold | |
| 120527 | 2026-05-22 11:47 | 2026-05-27 11:56 | MySQL Server: Optimizer | Can't repeat (4 days) | S2 | 9.6.0 | Linux | Any | FULLTEXT index scan with ORDER BY and numeric WHERE filter returns empty result set |
| 120526 | 2026-05-22 11:47 | 2026-05-26 6:59 | MySQL Server: Optimizer | Verified (5 days) | S3 | 8.0.43 | Any | Any | Wrong result for IN subquery involving CURRENT_USER(), BIT column, and UNIQUE prefix index |
| 120525 | 2026-05-22 9:41 | 2026-05-26 6:49 | MySQL Server: Optimizer | Verified (5 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Append-Only Growth Breaks Subset Monotonicity for Implicit VARCHAR-to-DECIMAL IN-Subquery Comparison |
| 120524 | 2026-05-22 9:40 | 2026-05-26 6:27 | MySQL Server: Optimizer | Verified (5 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Materialized Correlated EXISTS Returns Positive COUNT(*) But No Rows for Implicit VARCHAR-to-YEAR Comparison |
| 120523 | 2026-05-22 9:13 | 2026-05-25 20:10 | MySQL Server: Optimizer | Verified (6 days) | S3 | 8.0.43 | Any | Any | Wrong result for arithmetic expression involving DAYNAME() and BIT column |
| 120522 | 2026-05-22 6:39 | 2026-05-22 6:39 | MySQL Server: Optimizer | Open | S5 | 9.7.0 | Any | Any | Sub‑optimal execution plan for multi‑table row‑value IN condition leads to full index scan instead of index range scans |
| 120520 | 2026-05-21 16:34 | 2026-05-25 19:58 | MySQL Server: Optimizer | Verified (6 days) | S3 | 8.0.43 | Any | Any | Wrong result for IS NOT UNKNOWN when NULLIF() uses CURRENT_USER() as an argument |
| 120519 | 2026-05-21 15:49 | 2026-05-25 19:43 | MySQL Server: Optimizer | Verified (6 days) | S3 | 8.0.43 | Any | Any | Wrong result for BETWEEN predicate with LONGBLOB prefix PRIMARY KEY and implicit type conversion |
| 120518 | 2026-05-21 14:29 | 2026-05-25 19:27 | MySQL Server: Optimizer | Verified (6 days) | S3 | 8.0.43 | Any | Any | Wrong result for SOME quantified comparison with ELT() returning NULL and PRIMARY KEY optimization |
| 120515 | 2026-05-21 10:36 | 2026-05-21 11:55 | MySQL Server: Optimizer | Verified (10 days) | S3 | 8.0 | Any | Any | Wrong result for NOT BETWEEN involving interval arithmetic and implicit type conversion |
| 120514 | 2026-05-21 9:19 | 2026-05-21 11:47 | MySQL Server: Optimizer | Unsupported (10 days) | S3 | 8.0 | Any | Any | Wrong result for ALL quantified comparison involving interval arithmetic and PRIMARY KEY optimization |
| 120512 | 2026-05-21 7:43 | 2026-05-21 11:23 | MySQL Server: Optimizer | Verified (10 days) | S3 | 8.0 | Any | Any | ALL quantified comparison involving implicit numeric conversion of BLOB values |
| 120511 | 2026-05-21 7:24 | 2026-05-21 8:26 | MySQL Server: Optimizer | Verified (10 days) | S3 | 8.0.46 | Ubuntu | x86 | LEFT JOIN ON with IN (empty subquery) produces a spurious match |
| 120504 | 2026-05-20 11:53 | 2026-05-29 10:36 | MySQL Server: InnoDB storage engine | Verified (2 days) | S3 | 9.7 | Any | Any | Can't create some of tables with SPATIAL KEY because of ER_TOO_BIG_ROWSIZE |
| 120502 | 2026-05-20 10:16 | 2026-05-20 10:16 | MySQL Server: Optimizer | Open | S5 | 9.7.0 | Any | Any | Impossible WHERE with inequality-only contradictions not optimized |
| 120499 | 2026-05-20 5:02 | 2026-05-20 5:02 | MySQL Server: Stored Routines | Open | S2 | 9.6.0 | Linux | x86 (AMD EPYC 9K65) | Recursive stored procedure with max_sp_recursion_depth >= 250 crashes mysqld |
| 120497 | 2026-05-19 3:12 | 2026-05-21 6:37 | MySQL Server: Optimizer | Duplicate (12 days) | S3 | 8.4.8, 9.7.0 | Any | Any | INDEX Hint Prevents Reuse of InnoDB Primary-Key Suffix Order and Forces a Temporary Table |
| 120495 | 2026-05-18 16:12 | 2026-05-27 6:34 | MySQL Server: Optimizer | Verified (4 days) | S5 | 9.7.0 | Any | Any | Incorrect Cardinality Estimation for Index Lookup with Equality Predicate on the Index Column |
| 120493 | 2026-05-18 14:26 | 2026-05-19 19:53 | MySQL Server: Optimizer | Verified (12 days) | S3 | 8.0 | Any | Any | Wrong result for SOME quantified comparison in WHERE clause |
| 120491 | 2026-05-18 5:53 | 2026-05-18 12:22 | MySQL Server: Optimizer | Verified (13 days) | S2 | 8.0.46 | CentOS | Any | Semijoin returns wrong results for VARCHAR-to-DECIMAL comparison with non-canonical numeric strings |
| 120490 | 2026-05-18 3:24 | 2026-05-18 8:26 | MySQL Server: Optimizer | Verified (13 days) | S5 | 9.7.0 | Any | Any | Join Not Eliminated When Constant Table is Empty Due to PrimaryKeyCol IN (NULL) Condition |
| 120480 | 2026-05-14 20:59 | 2026-05-20 23:19 | MySQL Server: Replication | Open (11 days) | S3 | 8.0.40 | Any | Any | Crash in set_and_validate_user_attributes during relay log recovery |
| 120477 | 2026-05-14 15:50 | 2026-05-18 10:26 | MySQL Server: Optimizer | Verified (13 days) | S5 | 9.7.0 | Any | Any | Index Not Used for HAVING Without GROUP BY or aggregate functions |
| 120476 | 2026-05-14 11:53 | 2026-05-18 8:25 | MySQL Server: Optimizer | Verified (13 days) | S2 | 9.6.0 | Linux | Any | Index Merge Union returns duplicate row for overlapping OR conditions, producing wrong result count |
| 120475 | 2026-05-14 9:09 | 2026-05-18 10:20 | MySQL Server: Optimizer | Verified (13 days) | S2 | 8.0.46 | Linux | Any | Index Merge Intersection incorrectly drops matching rows in SELECT with OR predicate, returning wrong result count |
| 120472 | 2026-05-14 4:07 | 2026-05-18 9:40 | MySQL Server: Optimizer | Verified (13 days) | S3 | 8.0.43 | Any | Any | Wrong Result After Removing Semantically Redundant RIGHT JOIN ... ON FALSE |
| 120471 | 2026-05-14 0:08 | 2026-05-18 9:15 | MySQL Server: Replication | Open (17 days) | S1 | 8.0.43, 8.0.46, 8.4.9, 9.7.0 | Any (reproduced on macOS and Linux) | Any | binary log violates read after write (commit) consistency |
| 120469 | 2026-05-13 17:00 | 2026-05-18 9:12 | MySQL Server: InnoDB storage engine | Open | S3 | Any | Any | Contribution: Fix ut_error() at ENABLE INNODB REDO_LOG when innodb_checkpo ... | |
| 120467 | 2026-05-13 15:57 | 2026-05-18 9:09 | MySQL Server: InnoDB storage engine | Open | S3 | 8.0.45 | Any | Any | dd_open_fk_tables function heap-use-after-free |
| 120465 | 2026-05-13 8:31 | 2026-05-28 1:13 | MySQL Server: Optimizer | Patch pending (13 days) | S3 | 8.0.46 | Any | Any | AVG(ASCII()) result truncated to 99.9999 with SQL_BUFFER_RESULT due to incorrect decimal precision |
| 120457 | 2026-05-12 15:03 | 2026-05-28 1:13 | MySQL Server: Optimizer | Patch pending (14 days) | S2 | 9.7 | CentOS | x86 | Hypergraph optimizer returns wrong results for LEFT JOIN LATERAL with SEMI JOIN when derived_merge |
| 120456 | 2026-05-12 15:02 | 2026-05-17 23:00 | MySQL Server: Optimizer | Verified (14 days) | S2 | 8.0.46 | Linux | Any | Semijoin Nested Loop index lookup uses raw VARCHAR keys against a DOUBLE B-tree, causing mismatches when the string over |
| 120441 | 2026-05-11 11:29 | 2026-05-12 2:31 | MySQL Server: InnoDB storage engine | Open (19 days) | S2 | trunk 8.0.24 8.4.9 | Any | Any | InnoDB btr_create() can hold page latches for a long time because buf_stat_per_index->inc() may synchronously run ut_loc |
| 120437 | 2026-05-11 8:47 | 2026-05-11 8:57 | MySQL Server: Information schema | Open (20 days) | S2 | 8.0.35, 8.4.8, 9.3.0, 9.7.0 | Any | Any | information_schema.partitions returns UINT64_MAX (18446744073709551615) for DATA_LENGTH of partition dropped during conc |
| 120435 | 2026-05-11 7:21 | 2026-05-19 14:18 | MySQL Server: DDL | Open | S3 | Any | Any | Add DDL Triggers Support in MySQL | |
| 120429 | 2026-05-10 7:04 | 2026-05-28 1:13 | MySQL Server: Optimizer | Documenting (20 days) | S2 | 9.7.0 | Windows (Windows Server 2022) | Any | IFNULL function does not handle NULL |
| 120422 | 2026-05-08 8:56 | 2026-05-08 8:56 | MySQL Server: Optimizer | Open | S2 | 9.7.0 (also reproducible in 8.0.x) | Any | Any | ORDER BY ignored when internal_tmp_mem_storage_engine = TempTable with GROUP BY on CTE |
| 120420 | 2026-05-08 8:19 | 2026-05-08 8:19 | MySQL Server: Optimizer | Open | S3 | 9.7.0 (also reproducible in 8.0.x) | Any | Any | ORDER BY ignored when internal_tmp_mem_storage_engine = TempTable with GROUP BY on temp table |
| 120419 | 2026-05-08 7:50 | 2026-05-08 19:26 | MySQL Server: Optimizer | Verified (23 days) | S3 | 8.0.46 | Linux | Any | rematerialized temptable cause wrong order |
| 120417 | 2026-05-08 6:22 | 2026-05-20 11:16 | MySQL Server: InnoDB storage engine | Open | S3 | 8.0.40 | Linux | x86 | MY-013028] [InnoDB] MySQL is freeing a thd though trx->n_mysql_tables_in_use is X and trx->mysql_n_tables_locked is Y |
| 120416 | 2026-05-08 0:28 | 2026-05-11 8:05 | MySQL Server: Documentation | Open | S3 | 8.4.9 | Any | Any | Missing system variable in document for 8.4 |
| 120414 | 2026-05-07 15:19 | 2026-05-11 12:42 | MySQL Server: InnoDB storage engine | Open (20 days) | S5 | 8.0.32 - 9.7 | Any | Any | InnoDB performance regression because of validate_rec_offset |
| 120406 | 2026-05-06 4:46 | 2026-05-06 9:43 | MySQL Server: Documentation | Verified (25 days) | S3 | Any | Any | Inconsistent GBK-to-utf8mb4 conversion between implicit INSERT ... SELECT assignment and explicit CONVERT() | |
| 120403 | 2026-05-05 13:47 | 2026-05-28 1:13 | MySQL Server: Optimizer | Documenting (25 days) | S2 | 8.0.46, 8.4.9, 9.7.0 | Any | Any | Regression in MySQL 8.0.46, 8.4.9 & 9.7.0: WHERE equality condition fails to match existing row |
| 120400 | 2026-05-04 17:19 | 2026-05-04 17:46 | MySQL Server: Documentation | Open (27 days) | S3 | Any | Any | Docs for innodb_sort_buffer_size are wrong or confusing | |
| 120395 | 2026-05-04 6:49 | 2026-05-04 6:49 | MySQL Server: Documentation | Open | S3 | 9.7.0 | Any | Any | Documentation for enable_cascade_triggers has incorrect Scope and Dynamic attributes |
| 120389 | 2026-05-01 2:10 | 2026-05-27 6:49 | MySQL Server: Command-line Clients | Open | S3 | 9.7 | Any | Any | HELP result contains the link to MySQL 9.1 |
| 120388 | 2026-04-30 19:36 | 2026-05-01 9:44 | MySQL Server: InnoDB storage engine | Open | S5 | 8.4.9 | Oracle Linux (9.5) | x86 | High contention on InnoDB per-page BUF_BLOCK_MUTEX during concurrent range-selects to same row/page |
| 120377 | 2026-04-29 8:45 | 2026-04-29 10:47 | MySQL Server: Optimizer | Verified (32 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | Incorrect row count in MySQL when using LATERAL derived table with DISTINCT and CASE |
| 120370 | 2026-04-28 16:33 | 2026-05-22 14:45 | MySQL Server: DDL | Open (9 days) | S2 | 8.0.46 | Any | Any | Regression (from 8.0.45) on Row size too large |
| 120363 | 2026-04-28 6:58 | 2026-04-30 8:28 | MySQL Server: Optimizer | Verified (31 days) | S3 | 8.0.43 | Any (Docker container) | Any (x86_64) | LEFT JOIN ON FALSE causes incorrect NULL comparison result in MySQL |
| 120362 | 2026-04-28 6:13 | 2026-04-28 9:37 | MySQL Server: Documentation | Verified (33 days) | S2 | 9.7.0 | Any | Any | Incorrect syntax for CREATE VIEW in docs |
| 120356 | 2026-04-27 14:52 | 2026-04-27 17:21 | MySQL Server: DDL | Duplicate (34 days) | S2 | 8.0.46 | Linux (Debian 12) | x86 | ERROR 1118 Row size too large (> 8126) on 8.0.46 |
| 120353 | 2026-04-27 11:55 | 2026-04-29 11:43 | MySQL Server: InnoDB storage engine | Can't repeat (32 days) | S2 | <=8.0.42-debug | Any | Any | InnoDB crashes with assertion failure (ut_dbg_assertion_failed) when creating index with ALGORITHM COPY on table with F |
| 120352 | 2026-04-27 9:34 | 2026-04-28 4:26 | MySQL Server: Optimizer | Verified (33 days) | S2 | 9.6.0 | Linux | Any | Prefix index with length 1 causes incorrect "Zero rows" optimization with float overflow literal in range condition |
| 120350 | 2026-04-27 8:35 | 2026-04-28 4:31 | MySQL Server: Optimizer | Verified (33 days) | S2 | 9.6.0 | Linux | Any | Prefix index on TEXT column causes range scan to miss qualifying rows in MySQL |
| 120348 | 2026-04-27 4:37 | 2026-04-30 12:52 | MySQL Server: Documentation | Open | S3 | 9.7 | Any | Any | Doc Request: What Is New in MySQL 9.7 between MySQL 8.4 LTS and MySQL 9.7 LTS |
| 120344 | 2026-04-26 6:43 | 2026-04-27 4:04 | MySQL Server: Optimizer | Verified (34 days) | S2 | 9.6.0 | Any | Any | VIEW and equivalent CTE return different results with UNION, YEAR(0), and repeated reference in subquery |
| 120338 | 2026-04-23 20:37 | 2026-04-23 20:37 | MySQL Server: Documentation | Open | S3 | 9.6, 9.7 | Any | Any | What Is New in MySQL 9.7 manual page has contents from 9.5 |
| 120327 | 2026-04-23 7:46 | 2026-04-23 12:40 | MySQL Server: Replication | Open | S2 | MySQL 8.4 | Any | Any | Unsigned integer wraparound in Binlog_sender::run() when binlog_row_event_max_size is set to a large value |
| 120323 | 2026-04-22 12:51 | 2026-05-22 13:34 | MySQL Server: DDL | Verified (38 days) | S1 | 8.4.9 | Debian (12) | x86 | Regression : "Row size too large (> 8126)" error with table using InnoDb DYNAMIC row format |
| 120321 | 2026-04-22 8:52 | 2026-04-22 8:52 | MySQL Server: Documentation | Open | S3 | 9.7 | Any | Any | Typo in 9.7 doc describing about offline_mode |
| 120319 | 2026-04-22 7:11 | 2026-04-22 9:43 | MySQL Server: Optimizer | Duplicate (39 days) | S2 | MySQL 8.4.6 LTS | Any | Any | IN() clause containing over-length string values for VARCHAR(N) column causes full table scan in MySQL 8.4.x, while sing |
| 120318 | 2026-04-22 6:31 | 2026-04-22 6:31 | MySQL Server: InnoDB storage engine | Open | S3 | 9.6.0 | Linux | Any | InnoDB partition statistics not auto-updated after ALTER TABLE REORGANIZE PARTITION |
| 120313 | 2026-04-21 17:11 | 2026-04-22 4:43 | MySQL Server: Optimizer | Verified (39 days) | S1 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result when only GROUP BY key order is changed in a join query with nested window-function input |
| 120312 | 2026-04-21 16:58 | 2026-04-22 4:40 | MySQL Server: Optimizer | Verified (39 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result for MIN(TIME) UNION ALL DATE after view extraction |
| 120311 | 2026-04-21 16:52 | 2026-04-22 4:38 | MySQL Server: Optimizer | Verified (39 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result for grouped SUM(DISTINCT ...) with DENSE_RANK() after view extraction |
| 120310 | 2026-04-21 16:45 | 2026-04-22 4:34 | MySQL Server: Optimizer | Verified (39 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result for MAX(BIT(8)) UNION ALL BLOB after view extraction in a window-function workload |
| 120308 | 2026-04-21 14:03 | 2026-04-22 4:27 | MySQL Server: Optimizer | Verified (39 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result for string-vs-`BIT` comparison in a window-function query |
| 120307 | 2026-04-21 14:02 | 2026-04-22 4:23 | MySQL Server: Optimizer | Verified (39 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result for `<= ANY (subquery)` in a window-function query |
| 120306 | 2026-04-21 2:23 | 2026-04-21 5:49 | MySQL Server: DDL | Verified (40 days) | S3 | 8.0.43 | Any | Any | ALGORITHM=INPLACE allows creating a VIRTUAL GENERATED COLUMN with invalid expressions for existing data, causing subsequ |
| 120304 | 2026-04-20 22:05 | 2026-05-06 4:55 | MySQL Server: InnoDB storage engine | Duplicate (25 days) | S1 | 8.0.44 | CentOS (07) | x86 (x86_64) | MySQL 8.0.44 crashes with InnoDB assertion failure on replica when TRUNCATE TABLE is applied to a table whose tablespace |
| 120302 | 2026-04-20 9:51 | 2026-04-20 11:26 | MySQL Server: Optimizer | Verified (41 days) | S2 | 9.6.0 | Any | Any | Inconsistent results between VIEW and CTE involving YEAR(DATETIME), UNION, and JOIN. |
| 120300 | 2026-04-20 9:02 | 2026-04-20 11:03 | MySQL Server: Optimizer | Verified (41 days) | S2 | 8.0.45 | Any (Observed on Linux via the `mysql:9.6` ) | Any | Window function logic mismatch across engines |
| 120299 | 2026-04-20 9:00 | 2026-04-20 10:41 | MySQL Server: Optimizer | Verified (41 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | mismatch in `DELETE ... EXISTS` under window function query |
| 120298 | 2026-04-20 8:58 | 2026-04-20 10:56 | MySQL Server: DML | Can't repeat (41 days) | S3 | 8.0.31-tr-debug | Any | Any | opt_explain_json.cc:507 assert failure — EXPLAIN FORMAT=JSON on INTERSECT subquery crashes mysqld |
| 120297 | 2026-04-20 8:44 | 2026-04-20 10:04 | MySQL Server: Optimizer | Verified (41 days) | S2 | 8.0.32 | Any | Any | query_term.cc:320 assert(false) crash — UNION query triggers unhandled AccessPath |
| 120296 | 2026-04-20 7:50 | 2026-04-20 9:24 | MySQL Server: Optimizer | Verified (41 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Materialized Correlated EXISTS Loses Implicit VARCHAR-to-YEAR Coercion,Causing Plan-Dependent Result Divergence |
| 120294 | 2026-04-19 17:16 | 2026-04-27 14:11 | MySQL Server: Optimizer | Verified (34 days) | S3 | 9.6.0; 8.0.45 | Any | Any | Inconsistent fractional seconds precision (FSP) for TIME function results between VIEW and CTE |
| 120293 | 2026-04-19 17:10 | 2026-04-27 14:10 | MySQL Server: Optimizer | Verified (34 days) | S1 | 9.6.0; 8.0.45 | Any | Any | Query result inconsistency between VIEW and CTE involving a UNION of scalar aggregation and grouped aggregation |
| 120292 | 2026-04-19 17:01 | 2026-04-27 14:09 | MySQL Server: Optimizer | Verified (34 days) | S2 | 9.6.0; 8.0.45 | Any | Any | Inconsistent results between VIEW and CTE involving IN subquery and RIGHT JOIN |
| 120291 | 2026-04-19 16:45 | 2026-04-27 13:16 | MySQL Server: Optimizer | Verified (34 days) | S2 | 9.6.0 | Any | Any | Inconsistent results between VIEW and CTE involving EXISTS subquery and LEFT JOIN |
| 120289 | 2026-04-19 14:35 | 2026-04-20 8:13 | MySQL Server: Optimizer | Verified (41 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Mismatch in indexed `IN` under windows function query |
| 120288 | 2026-04-19 14:29 | 2026-04-20 8:04 | MySQL Server: Optimizer | Verified (41 days) | S2 | 8.0.45 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Window function logic mismatch in indexed `NOT IN` |
| 120286 | 2026-04-19 5:14 | 2026-04-20 7:53 | MySQL Server: Optimizer | Verified (41 days) | S2 | 8.0.45 | Any | Any | `SUM(DISTINCT pk)` returns `NULL` with a window function when a secondary index is used for group-by scanning |
| 120285 | 2026-04-18 15:49 | 2026-04-18 15:54 | MySQL Server: Optimizer | Open (43 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Materialized Semijoin + Outer ORDER BY Loses Rows for Correlated EXISTS,Causing Plan-Dependent Result Divergence |
| 120284 | 2026-04-18 15:46 | 2026-04-20 7:33 | MySQL Server: Optimizer | Verified (41 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Materialized `IN (subquery)` Loses VARCHAR-to-YEAR Coercion,Causing Plan-Dependent Result Divergence |
| 120283 | 2026-04-17 13:00 | 2026-04-20 7:22 | MySQL Server: Optimizer | Not a Bug (41 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | DATE Column Printed as NULL Still Satisfies `IS NOT NULL`,Allowing a Contradictory Predicate to Return Rows |
| 120281 | 2026-04-17 9:21 | 2026-04-17 11:32 | MySQL Server: Replication | Open (44 days) | S2 | 8.0.42 | Linux (any) | Any | replica_preserve_commit_order causes infinite deadlock in group commit pipeline, blocking all application writes |
| 120279 | 2026-04-17 7:23 | 2026-04-17 14:09 | MySQL Server: Optimizer | Verified (44 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any | Any | Severe performance degradation with window function + joins (works fast in PostgreSQL/DuckDB/TiDB) |
| 120278 | 2026-04-17 2:44 | 2026-05-12 2:31 | MySQL Server: Replication | Open (19 days) | S2 | 8.0.44 8.4.9 | Any | Any | mts_event_coord_cmp() uses strcmp() for binlog filename comparison, causing incorrect ordering when binlog index exceeds |
| 120275 | 2026-04-16 7:10 | 2026-04-20 6:51 | MySQL Server: Optimizer | Verified (41 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | DATE Index Lookup Loses Existing JOIN Matches Even with Explicit CAST(MEDIUMTEXT AS DATE), Causing S1/S2 Divergence |
| 120272 | 2026-04-15 11:21 | 2026-04-22 9:30 | MySQL Server: InnoDB storage engine | Verified (39 days) | S2 | 8.0.45 | Any | Any | ddl stuck in Waiting for clone PAGE_COPY state |
| 120271 | 2026-04-15 10:54 | 2026-04-16 21:39 | MySQL Server: Optimizer | Verified (45 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | Logic error: EXISTS subquery treated as constant TRUE yields different result than literal TRUE |
| 120270 | 2026-04-15 9:49 | 2026-04-16 21:20 | MySQL Server: Optimizer | Verified (45 days) | S1 | 8.0.45 | Any | Any | Incorrect result for INTERSECT ALL with semantically equivalent EXCEPT operands when right EXCEPT left operand is wrap |
| 120268 | 2026-04-14 19:38 | 2026-05-05 13:11 | MySQL Server: Documentation | Verified (26 days) | S1 | 5.7, 8.0, 8.4, 9.x | Any | Any | Clarify Symbolic Link Usage and Alternative for InnoDB |
| 120266 | 2026-04-14 9:12 | 2026-04-14 9:12 | MySQL Server: Replication | Open | S3 | MySQL 8.4 | Any | Any | Replication delay when SQL thread skips large already-executed transactions |
| 120265 | 2026-04-14 8:24 | 2026-04-14 9:47 | MySQL Server: Optimizer | Verified (47 days) | S1 | 9.6.0 | Any | Any | Query returns with UNION, INTERSECT ALL and Derived SELECT DISTINCT |
| 120262 | 2026-04-14 2:54 | 2026-04-16 20:55 | MySQL Server: Optimizer | Not a Bug (45 days) | S2 | 8.4.8 | Any | Any | CREATE VIEW materialization changes INTERSECT result cardinality for an aggregate branch |
| 120261 | 2026-04-14 2:52 | 2026-04-14 4:32 | MySQL Server: Optimizer | Verified (47 days) | S2 | 8.4.8 | Any | Any | CREATE VIEW materialization changes a key scalar output |
| 120260 | 2026-04-14 2:48 | 2026-04-14 4:42 | MySQL Server: Optimizer | Verified (47 days) | S2 | 8.4.8 | Any | Any | CREATE VIEW materialization changes byte-valued outputs after aggregate or window processing |
| 120259 | 2026-04-14 2:43 | 2026-04-14 4:49 | MySQL Server: Optimizer | Verified (47 days) | S2 | 8.4.8 | Any | Any | CREATE VIEW materialization changes byte-valued UNION results |
| 120258 | 2026-04-14 2:07 | 2026-04-14 4:45 | MySQL Server: Optimizer | Verified (47 days) | S2 | 8.4.8 | Any | Any | CREATE VIEW materialization changes NULL aggregate outputs into numeric values after GROUP BY |
| 120256 | 2026-04-13 11:44 | 2026-04-13 12:48 | MySQL Server: Optimizer | Verified (48 days) | S2 | 8.4.8 | Any | Any | CREATE VIEW materialization turns zero datetime values into runtime timestamps in UNION ALL output |
| 120255 | 2026-04-13 11:24 | 2026-04-13 13:04 | MySQL Server: Optimizer | Verified (48 days) | S2 | 8.4.8 | Any | Any | CREATE VIEW materialization changes grouped results when replacing a grouped CTE or derived input |
| 120254 | 2026-04-13 10:04 | 2026-04-14 8:48 | MySQL Server: Optimizer | Not a Bug (47 days) | S1 | 9.6.0 | Any | Any | Equivalent queries show different behavior due to short-circuit optimization failure |
| 120253 | 2026-04-13 9:14 | 2026-04-13 10:18 | MySQL Server: Optimizer | Verified (48 days) | S3 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Index Lookup Skips CAST for LONGTEXT-to-DATE Coercion in JOIN,Causing Plan-Dependent Result Divergence |
| 120251 | 2026-04-12 11:47 | 2026-04-13 4:58 | MySQL Server: DDL | Verified (48 days) | S2 | 9.6.0 | Any | Any | REPLACE INTO silently bypasses ON DELETE FK rules with innodb_native_foreign_keys=OFF |
| 120248 | 2026-04-11 9:16 | 2026-04-13 4:56 | MySQL Server: Optimizer | Verified (48 days) | S3 | 8.4.8 | Ubuntu | Any | Changing the order of GROUPING columns gives wrong results |
| 120247 | 2026-04-11 9:03 | 2026-05-29 11:40 | MySQL Server: Optimizer | Duplicate (2 days) | S3 | 8.4.8 | Ubuntu | Any | CREATE VIEW materialization changes RIGHT JOIN preserved-side filtering result cardinality |
| 120245 | 2026-04-10 13:14 | 2026-04-10 13:55 | MySQL Server: DDL | Open | S1 | 9.6.0 | Any | Any | Unexpected error `Got error -1 - 'Unknown error -1' from storage engine` |
| 120244 | 2026-04-10 12:40 | 2026-04-10 13:51 | MySQL Server: DDL | Open | S1 | 9.6.0 | Any | Any | Unexpected error `'0' for column '' at row -1` triggered by ALTER |
| 120241 | 2026-04-09 11:02 | 2026-04-09 11:02 | MySQL Server: InnoDB storage engine | Open | S3 | trunk | Any | Any | Fix ambiguity in the name and doxygen of method buf_flush_sync_all_buf_pools() |
| 120238 | 2026-04-09 9:16 | 2026-04-09 9:34 | MySQL Server: Replication | Open | S3 | 5.7 8.0 | Linux | Any | maybe cause "could not find next log" if rotate binary log without fsync @@log_bin_index's parent dir |
| 120237 | 2026-04-08 17:05 | 2026-04-09 8:59 | MySQL Server: DDL | Verified (52 days) | S3 | 9.6 and 8.4 | Any | Any | DEFAULT(UUID()) allowed at CREATE TABLE but rejected in ALTER TABLE with binary logging enabled |
| 120235 | 2026-04-08 10:17 | 2026-04-08 10:17 | MySQL Server: XML functions | Open | S3 | 8.0 | Windows (Win11) | x86 (na) | Un/Comment Selection |
| 120231 | 2026-04-08 4:55 | 2026-04-11 11:50 | MySQL Server: Documentation | Verified (50 days) | S3 | 8.0.29 | Any | Any | Typo in MySQL 8.0.29 release note |
| 120225 | 2026-04-07 13:40 | 2026-04-08 4:30 | MySQL Server: Optimizer | Verified (53 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | Inconsistent behavior between SELECT and DELETE/UPDATE with EXISTS and LEFT JOIN subquery |
| 120224 | 2026-04-07 12:25 | 2026-04-08 4:34 | MySQL Server: Optimizer | Verified (53 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | Inconsistent row counts for DELETE vs SELECT with EXISTS and lateral subquery on the same table |
| 120223 | 2026-04-07 12:06 | 2026-04-09 19:33 | MySQL Server: Data Types | Verified (52 days) | S2 | 9.6.0 | Linux | Any | VECTOR(0) silently accepted, produces unusable column with corrupted metadata (dimension 4294967295) |
| 120222 | 2026-04-07 12:02 | 2026-04-09 19:30 | MySQL Server: Data Types | Verified (52 days) | S2 | 9.6.0 | Linux | Any | VECTOR(n) dimension silently wraps to wrong value due to integer overflow in parser |
| 120217 | 2026-04-05 12:27 | 2026-04-06 5:24 | MySQL Server: Optimizer | Verified (55 days) | S3 | 9.6.0 | Ubuntu (22.04) | Any | GROUPING() in ORDER BY of EXISTS/IN/ALL/ANY subquery: invalid arguments not rejected |
| 120215 | 2026-04-04 16:59 | 2026-04-06 5:38 | MySQL Server: Optimizer | Verified (55 days) | S3 | 9.6.0 | Ubuntu (22.04) | Any | Inconsistent window aggregate results with GROUP BY ... WITH ROLLUP |
| 120208 | 2026-04-03 7:57 | 2026-05-04 1:00 | MySQL Server: DML | No Feedback (28 days) | S1 | 8.0.28 | Any (Aurora MySQL 3.04.4) | Any | SIGSEGV crash in TABLE_LIST::query_block_id_for_explain() when running EXPLAIN on CTE (WITH clause) query |
| 120206 | 2026-04-02 19:48 | 2026-04-02 19:48 | MySQL Server: Partitions | Open | S2 | 9.6.0 | Any | Any | EXCHANGE PARTITION bypasses CHECK CONSTRAINT validation |
| 120204 | 2026-04-02 7:52 | 2026-04-02 7:52 | MySQL Server: InnoDB storage engine | Open | S2 | 9.4.0 | Any | Any | UPDATE statements fail to update rows or acquire locks after being released |
| 120203 | 2026-04-02 2:35 | 2026-04-04 19:49 | MySQL Server: Optimizer | Verified (57 days) | S2 | 8.0.45 | Any | Any | MySQL returns an incorrect result for an indexed comparison between an `INT` column and a non-integer function value. |
| 120199 | 2026-04-01 8:00 | 2026-04-01 8:00 | MySQL Server: InnoDB storage engine | Open | S2 | 9.4.0 | Any | Any | Two transactions simultaneously acquire the same exclusive lock |
| 120198 | 2026-04-01 7:45 | 2026-04-16 14:30 | MySQL Server: Replication | Verified (45 days) | S3 | 8.0.45 | Any | Any | Lost gtid after crash recovery |
| 120196 | 2026-03-31 23:50 | 2026-04-03 6:23 | MySQL Server: InnoDB storage engine | Open | S3 | 9.6.0 | Any | Any | n_mysql_tables_in_use uint32 underflow via MRR dsmrr_init() error path in handler.cc |
| 120185 | 2026-03-31 8:58 | 2026-04-06 4:47 | MySQL Server: DML | Can't repeat (55 days) | S2 | 8.0.32-debug | Any | Any | Assertion Failure in add_key_fields with Nested CTE |
| 120183 | 2026-03-30 21:14 | 2026-03-30 21:14 | MySQL Server: General | Open | S3 | Any | Any | Contribution: Consolidate duplicated cmake flags in MySQL RPM spec using sh ... | |
| 120182 | 2026-03-30 21:14 | 2026-03-30 21:14 | MySQL Server: General | Open | S3 | Any | Any | Contribution: Consolidate duplicated cmake flags in MySQL DEB packaging usi ... | |
| 120181 | 2026-03-30 21:14 | 2026-04-20 13:09 | MySQL Server: Replication | Open | S3 | Any | Any | Contribution: Fix stale sql_mode values in Query_event Doxygen documentatio ... | |
| 120179 | 2026-03-30 10:54 | 2026-03-30 12:26 | MySQL Server: Optimizer | Verified (62 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | NoREC Test: COUNT(*) vs SUM(CASE...) produces inconsistent results with RIGHT JOIN + LEFT JOIN |
| 120177 | 2026-03-30 6:38 | 2026-04-01 12:10 | MySQL Server: Replication | Open | S3 | 5.7.44 | Any | Any | Lost gtids after crash recovery |
| 120174 | 2026-03-28 9:25 | 2026-03-29 20:21 | MySQL Server: Optimizer | Verified (63 days) | S3 | 8.0.45 | Ubuntu (22.04) | Any | Incorrect empty result for BETWEEN on binary string columns when a UNIQUE index is used |
| 120172 | 2026-03-28 9:14 | 2026-03-29 20:15 | MySQL Server: Optimizer | Verified (63 days) | S3 | 8.0.45 | Ubuntu (22.04) | Any | Inconsistent result: NOT IN (subquery on BIT column) differs when using secondary index vs IGNORE INDEX |
| 120171 | 2026-03-28 8:58 | 2026-03-29 20:06 | MySQL Server: Optimizer | Verified (63 days) | S3 | 8.0.45 | Ubuntu (22.04) | Any | Wrong result: LEFT JOIN empty derived table + WHERE equality uses literal from SELECT list |
| 120170 | 2026-03-28 8:33 | 2026-03-28 8:33 | MySQL Server: InnoDB storage engine | Open | S2 | 8.0.39 | Any | Any | Missing Update in READ COMMITTED during concurrent UPDATE with row re-evaluation failure. |
| 120161 | 2026-03-26 14:19 | 2026-03-27 4:56 | MySQL Server: Optimizer | Duplicate (65 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | Incorrect partial row duplication with RIGHT JOIN and empty subquery |
| 120159 | 2026-03-26 11:41 | 2026-03-27 4:57 | MySQL Server: Optimizer | Verified (66 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | RIGHT JOIN + Complex Subqueries Returns Extra Rows |
| 120158 | 2026-03-26 6:04 | 2026-03-29 19:37 | MySQL Server: Optimizer | Verified (63 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Incorrect result (NULL included) in index lookup/MAX() on FLOAT ZEROFILL column when filtering by 0.0 |
| 120153 | 2026-03-25 16:15 | 2026-03-25 16:18 | MySQL Server: Options | Open | S3 | 9.5 | Any | Any | Wrong default value for default_collation_for_utf8mb4 |
| 120152 | 2026-03-25 8:50 | 2026-03-26 9:05 | MySQL Server: Optimizer | Verified (66 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | Unexpected behavior of LEFT JOIN + empty subquery with NULL comparison in WHERE clause |
| 120146 | 2026-03-25 6:22 | 2026-05-28 14:53 | MySQL Server: Optimizer | Open (3 days) | S2 | 9.6.0 | Linux (ubuntu 20.04) | x86 | Wrong result due to incorrect const-table pruning for NOT IN on FLOAT UNIQUE column in MEMORY engine |
| 120145 | 2026-03-25 6:05 | 2026-03-25 19:22 | MySQL Server: Optimizer | Verified (67 days) | S2 | 8.0.45 | Linux (ubuntu 20.04) | x86 | Incorrect empty result after relocating a HAVING predicate into a derived-table boolean column with WHERE ref1 |
| 120144 | 2026-03-25 6:03 | 2026-03-25 19:10 | MySQL Server: Optimizer | Closed (67 days) | S3 | 9.6.0 | Any | Any | Submitted by mistake |
| 120135 | 2026-03-24 2:02 | 2026-03-31 6:50 | MySQL Server: Replication | Duplicate (61 days) | S3 | 8.0.* | Any | Any | When explicit_defaults_for_timestamp is off, replication exceptions when insert a null value. |
| 120132 | 2026-03-23 11:28 | 2026-03-24 7:45 | MySQL Server: Optimizer | Verified (68 days) | S3 | 8.4.8 | Any | Any | Unexpected Query Results Caused by Prefix Index on TEXT Column |
| 120131 | 2026-03-23 11:27 | 2026-03-24 7:40 | MySQL Server: Optimizer | Verified (68 days) | S3 | 8.0.45 | Any | Any | Bug in Query Behavior due to ZEROFILL in DOUBLE Column |
| 120129 | 2026-03-23 9:29 | 2026-03-23 9:29 | MySQL Server: InnoDB storage engine | Open | S3 | 8.0.39 | Any | Any | Non-deterministic semi-consistent read behavior: UPDATE randomly blocks on non-matching locked rows in READ UNCOMMITTED. |
| 120128 | 2026-03-23 8:14 | 2026-05-28 1:13 | MySQL Server: Replication | Documenting (53 days) | S3 | 8.0.* | Any | Any | When explicit_defaults_for_timestamp is off, inserting a null value causes replication exceptions. |
| 120124 | 2026-03-22 10:29 | 2026-03-22 10:29 | MySQL Server: DDL | Open | S3 | 9.6 | Any | Any | Remove unused partition states from enum partition_state { |
| 120123 | 2026-03-20 7:15 | 2026-03-20 12:18 | MySQL Server: Optimizer | Verified (72 days) | S3 | 8.0.45 | Any | Any | Inconsistent query results when using EXISTS subqueries with MyISAM engine in derived tables. |
| 120122 | 2026-03-20 4:58 | 2026-03-20 12:06 | MySQL Server: Optimizer | Verified (72 days) | S3 | 8.0.45 | Linux | x86 | Inconsistent evaluation of GREATEST() with ZEROFILL column in OUTER JOIN queries |
| 120121 | 2026-03-20 4:51 | 2026-03-20 9:41 | MySQL Server: Optimizer | Duplicate (72 days) | S1 | 9.5.0 | Any | Any | Phantom Drift: Wrong Result in INTERSECT with NULL caused by Prefix Primary Key and Cartesian Join |
| 120115 | 2026-03-19 15:21 | 2026-03-19 15:32 | MySQL Server: Replication | Open | S3 | 8.4 | Any | Any | CHANGE REPLICATION FILTER REPLICATE_IGNORE_DB with ROW BASED REPLICATION NOT WORKING AS DESCRIBED |
| 120114 | 2026-03-19 12:05 | 2026-03-19 14:31 | MySQL Server: Optimizer | Not a Bug (73 days) | S3 | 9.6.0 | Any | Any | Inconsistent result when using MAX(c0) inside GREATEST compared to standalone evaluation |
| 120106 | 2026-03-19 7:49 | 2026-03-19 8:33 | MySQL Server: Optimizer | Verified (73 days) | S1 | 8.0.45 | Any | Any | Optimizer incorrectly handles constant derived table in RIGHT JOIN |
| 120105 | 2026-03-19 7:42 | 2026-04-17 17:11 | MySQL Server: InnoDB storage engine | Can't repeat (51 days) | S2 | 8.0.22 | Any | Any | mysql crash on fil_report_invalid_page_access_low |
| 120104 | 2026-03-19 7:36 | 2026-03-30 7:32 | MySQL Server: DDL | Open (62 days) | S3 | 8.4.7 | Any | Any | Modify VARCHAR column leads to unexpected rebuild of table |
| 120099 | 2026-03-18 12:08 | 2026-03-19 8:04 | MySQL Server: Optimizer | Verified (73 days) | S1 | 8.0.45 | Any | Any | Query returns wrong result when condition involves CAST(division AS CHAR) |
| 120098 | 2026-03-18 9:58 | 2026-03-18 10:59 | MySQL Server: Optimizer | Verified (74 days) | S1 | 8.0.45 | Any | Any | Incorrect result when using EXISTS with INTERSECT ALL and correlated subquery |
| 120097 | 2026-03-18 9:34 | 2026-03-18 9:48 | MySQL Server: Optimizer | Verified (74 days) | S1 | 8.0.45 | Any | Any | Incorrect result set when use INTERSECT ALL |
| 120095 | 2026-03-18 8:42 | 2026-03-31 1:45 | MySQL Server: DML | Open (61 days) | S3 | 8.4.8, 8.0.41 | Any | Any | query result changed after UPDATE HISTOGRAM, caused by query plan changed to "skip scan" |
| 120094 | 2026-03-18 8:29 | 2026-03-18 9:35 | MySQL Server: Optimizer | Verified (74 days) | S1 | 8.0.45 | Any | Any | Query returns incorrect results due to incorrect handling of predicate logic |
| 120093 | 2026-03-18 8:12 | 2026-03-18 9:18 | MySQL Server: Optimizer | Not a Bug (74 days) | S3 | 8.0.45 | Linux | x86 | Incorrect result with OUTE JOIN and NULL-dependent LIKE predicate on FLOAT values when partitioned by IS NULL conditions |
| 120091 | 2026-03-18 6:13 | 2026-03-18 9:01 | MySQL Server: Optimizer | Verified (74 days) | S3 | 8.0.45 | Linux | x86 | Incorrect result with OUTER JOIN on DECIMAL compared to floating-point condition when partitioned by IS NOT NULL predica |
| 120090 | 2026-03-18 4:40 | 2026-03-18 8:13 | MySQL Server: Optimizer | Not a Bug (74 days) | S3 | Linux | x86 | Incorrect result with OUTER JOIN and CASE expression with string literal in join condition | |
| 120087 | 2026-03-17 13:12 | 2026-03-18 4:58 | MySQL Server: Optimizer | Verified (74 days) | S2 | 8.0.45 | Linux | x86 | Incorrect result with RIGHT JOIN and IS NULL predicate on partitioned indexed table |
| 120084 | 2026-03-17 9:40 | 2026-03-17 11:47 | MySQL Server: Optimizer | Verified (75 days) | S3 | 8.0.45 | Linux | x86 | Incorrect result with string-to-decimal comparison in OUTER JOIN condition |
| 120083 | 2026-03-17 8:59 | 2026-03-17 11:38 | MySQL Server: Optimizer | Verified (75 days) | S2 | 8.0.45 | Linux | x86 | incorrect result when comparing floating constant in OUTER JOIN condition |
| 120080 | 2026-03-17 5:35 | 2026-03-17 11:23 | MySQL Server: Optimizer | Not a Bug (75 days) | S3 | 9.6.0 | Any | Any | Inconsistent result when using LEAST() with string literal and VAR_POP(), especially when combined with CAST to SIGNED |
| 120079 | 2026-03-17 5:04 | 2026-03-17 11:12 | MySQL Server: Optimizer | Not a Bug (75 days) | S3 | 9.6.0 | Any | Any | Incorrect result when casting VARIANCE() inside IF() expression to SIGNED |
| 120075 | 2026-03-16 14:26 | 2026-03-25 12:47 | MySQL Server: Optimizer | Verified (74 days) | S1 | 8.0.45 | Linux (ubuntu 20.04) | x86 | Silent Data Truncation of DOUBLE (DBL_MAX) in Subqueries/Temporary Tables |
| 120072 | 2026-03-16 8:39 | 2026-03-16 14:44 | MySQL Server: Optimizer | Duplicate (76 days) | S3 | 9.5.0 | Any | Any | aftter changing UNION ALL to INTERSECT,the rows matched unexpectedly become more |
| 120058 | 2026-03-14 10:40 | 2026-03-14 14:52 | MySQL Server: Optimizer | Verified (78 days) | S3 | 8.0.45 | Any | Any | UPDATE IGNORE fails to match rows when combining OR-weakened predicates with complex CASE expressions |
| 120057 | 2026-03-14 4:32 | 2026-03-14 14:43 | MySQL Server: Optimizer | Verified (78 days) | S3 | 8.0.45 | Any | Any | Multi-table UPDATE with CTE returns zero rows when weakening a predicate from '=' to '<=' |
| 120056 | 2026-03-14 4:22 | 2026-03-14 14:24 | MySQL Server: Optimizer | Verified (78 days) | S3 | 8.0.45 | Any | Any | UPDATE IGNORE returns empty result after weakening WHERE clause with OR in a JOIN context |
| 120053 | 2026-03-13 10:58 | 2026-03-13 15:09 | MySQL Server: Optimizer | Duplicate (79 days) | S1 | 9.5.0 | Any | Any | EXCEPT Returns Different Results Based on Composite Primary Key, WHERE Conditions, BNL Optimization |
| 120051 | 2026-03-13 9:31 | 2026-03-13 21:16 | MySQL Server: Optimizer | Verified (79 days) | S1 | 8.0.45 | Linux (ubuntu 20.04) | Any | Wrong result for derived-table rewrite of GROUP BY ... HAVING query |
| 120050 | 2026-03-13 9:00 | 2026-03-17 12:22 | MySQL Server: InnoDB storage engine | Open | S5 | 8.0.44 | Any | Any | remove dead code |
| 120049 | 2026-03-13 7:41 | 2026-03-30 13:52 | MySQL Server: Optimizer | Duplicate (62 days) | S3 | 9.5.0 | Any | Any | DELETE with STRAIGHT_JOIN fails to match rows after simplifying INTERSECT sequence in EXISTS subquery |
| 120047 | 2026-03-13 5:08 | 2026-03-13 5:57 | MySQL Server: Optimizer | Verified (79 days) | S3 | 9.5.0 | Any | Any | Incorrect empty update result when weakening WHERE clause in UPDATE IGNORE with CROSS JOIN and IN subquery |
| 120045 | 2026-03-13 2:54 | 2026-03-30 13:41 | MySQL Server: Optimizer | Duplicate (62 days) | S1 | 9.5.0 | Any | Any | INTERSECT Returns Inconsistent Results Based on optimizer_switch and WHERE Clause |
| 120037 | 2026-03-12 2:46 | 2026-03-13 11:31 | MySQL Server: Optimizer | Verified (79 days) | S3 | 8.4.8 | Any | Any | Query Results Differ Between Tables with Same Data and Query Due to RENAME Operation |
| 120036 | 2026-03-12 2:09 | 2026-03-13 13:15 | MySQL Server: Optimizer | Verified (79 days) | S3 | 8.0.45 | Any | Any | Different results for semantically equivalent expressions using CASE and MIN(CASE ...) with GROUP BY on a FLOAT column |
| 120034 | 2026-03-11 15:13 | 2026-03-11 21:10 | MySQL Server: Optimizer | Verified (81 days) | S3 | 8.4.8 | Any | Any | Wrong Results with LOG(1, N) <=> NULL: UNIQUE Constraint Causes Incorrect Row Deduplication |
| 120033 | 2026-03-11 15:01 | 2026-03-11 21:02 | MySQL Server: Optimizer | Verified (81 days) | S3 | 8.4.8 | Any | Any | Inconsistent Results with SUBTIME(1, SYSDATE()) in HAVING Clause: UNIQUE Constraint Affects Optimizer Evaluation |
| 120032 | 2026-03-11 14:56 | 2026-03-11 20:56 | MySQL Server: Optimizer | Verified (81 days) | S3 | 8.4.8 | Any | Any | Inconsistent Aggregation Results in Derived Tables: PRIMARY KEY Affects AVG(NOT(...)) Evaluation and Optimizer Execution |
| 120031 | 2026-03-11 14:48 | 2026-03-11 20:46 | MySQL Server: Optimizer | Verified (81 days) | S3 | 8.4.8 | Any | Any | Inconsistent INTERSECT Results in Derived Tables: Impact of PRIMARY KEY on JSON_OBJECTAGG and LEAST Operators |
| 120030 | 2026-03-11 14:44 | 2026-03-11 20:31 | MySQL Server: Optimizer | Verified (81 days) | S3 | 8.4.8 | Any | Any | Query Results Differ Due to Primary Key and INTERSECT Operation |
| 120029 | 2026-03-11 14:42 | 2026-03-11 20:19 | MySQL Server: Optimizer | Verified (81 days) | S3 | 8.4.8 | Any | Any | Query Results Differ Due to Primary Key Column - Issue with MIN, MAX, and Time-Related Functions |
| 120028 | 2026-03-11 14:38 | 2026-03-11 19:59 | MySQL Server: Optimizer | Verified (81 days) | S3 | 8.4.8 | Any | Any | Query Results Differ Due to Primary Key Column and TRUNCATE Function Behavior |
| 120027 | 2026-03-11 14:34 | 2026-03-11 19:48 | MySQL Server: Optimizer | Verified (81 days) | S3 | 8.4.8 | Any | Any | Query Results Differ Due to Presence of Primary Key - Issue with MIN and DATE_ADD Functions |
| 120026 | 2026-03-11 14:30 | 2026-03-11 19:37 | MySQL Server: Optimizer | Can't repeat (81 days) | S3 | 8.4.8 | Any | Any | Query Results Differ Between Tables with Same Data and Query Due to RENAME Operation |
| 120022 | 2026-03-11 2:22 | 2026-03-11 7:10 | MySQL Server: Optimizer | Verified (81 days) | S3 | MySQL 8.0.28 | Any | Any | CAST(AVG()) returns a different result than CAST(SUM()/COUNT()) on DECIMAL values |
| 120019 | 2026-03-10 12:29 | 2026-03-10 14:40 | MySQL Server: Optimizer | Verified (82 days) | S2 | 8.0.41 | Any | Any | query result change after removing partitioning |
| 120016 | 2026-03-09 17:41 | 2026-03-10 7:58 | MySQL Server: Documentation | Verified (82 days) | S2 | 8.0, 8.4, 9.x | Any | Any | Documentation "Exchanging Partitions and Subpartitions with Tables" not mentioning limitation about ALGORITHM=INSTANT. |
| 120015 | 2026-03-09 13:48 | 2026-04-02 6:16 | MySQL Server: Optimizer | Duplicate (59 days) | S1 | 8.0.45 | Any | Any | Incorrect retention of NULL rows due to CASE evaluation error in WHERE clause. |
| 120013 | 2026-03-09 11:27 | 2026-03-09 13:50 | MySQL Server: Optimizer | Not a Bug (83 days) | S1 | 9.6.0 | Any | Any | Inconsistent results between equivalent queries involving logical predicates and set operations |
| 120011 | 2026-03-09 10:29 | 2026-03-09 11:16 | MySQL Server: Optimizer | Verified (83 days) | S1 | 8.0.44 | Any | Any | The normal query generated a non-optimal query plan with index. |
| 120010 | 2026-03-09 9:56 | 2026-04-03 10:55 | MySQL Server: Optimizer | Duplicate (59 days) | S1 | 8.0.45 | Any | Any | Incorrect result set when evaluating IS NULL on a derived table containing logical AND expressions |
| 120005 | 2026-03-08 0:14 | 2026-03-10 8:04 | MySQL Server: Optimizer | Verified (82 days) | S2 | 8.4.7 | Any | Any | Wrong results with subquery with semijoin=on and antijoin optimization |
| 120004 | 2026-03-07 19:38 | 2026-03-09 9:48 | MySQL Server: Optimizer | Verified (83 days) | S2 | 8.0.31 | Any | Any | IndexSkipScanIterator Assertion Failure |
| 120003 | 2026-03-07 12:14 | 2026-03-09 9:41 | MySQL Server: Optimizer | Verified (83 days) | S3 | 8.0.45 | Any | Any | column name unexpectedly change because of '1' as a column |
| 119998 | 2026-03-06 14:56 | 2026-03-09 11:52 | MySQL Server: Optimizer | Not a Bug (83 days) | S3 | 8.4.8 | Ubuntu (22.04) | Any | ERROR 1292 Incorrect value on INSERT…SELECT when CAST result is NULL |
| 119997 | 2026-03-06 13:12 | 2026-03-20 15:06 | MySQL Server: InnoDB storage engine | Open (73 days) | S3 | 8.0.40 | Any | Any | Setting innodb_use_native_aio to OFF can lead to severe lock contention. |
| 119996 | 2026-03-06 11:07 | 2026-05-28 1:13 | MySQL Server: DDL | Documenting (75 days) | S2 | 9.6 | Any | Any | Row delete from a table with selfreferental FK breaks replication |
| 119995 | 2026-03-06 9:51 | 2026-04-27 10:07 | MySQL Server: Optimizer | Closed (34 days) | S2 | 8.0.45 | Any | Any | Function find_in_set return wrong result |
| 119994 | 2026-03-06 8:20 | 2026-03-09 8:17 | MySQL Server: Optimizer | Duplicate (83 days) | S2 | Linux | x86 | Incorrect result with LEFT/RIGHT JOIN using functional index and boolean expression comparison | |
| 119993 | 2026-03-06 7:57 | 2026-03-09 8:14 | MySQL Server: Optimizer | Duplicate (83 days) | S2 | Linux | x86 | Incorrect result with LEFT/RIGHT JOIN when using functional index and boolean expression comparison | |
| 119992 | 2026-03-06 6:23 | 2026-03-09 8:07 | MySQL Server: Optimizer | Duplicate (83 days) | S2 | 8.0.45 | Linux | x86 | Incorrect result for LEFT/RIGHT JOIN when using IS TRUE / IS FALSE expressions on the right table with NULL padding. |
| 119991 | 2026-03-06 5:56 | 2026-03-06 11:27 | MySQL Server: Optimizer | Verified (86 days) | S2 | 8.0.45 | Linux | x86 | Incorrect result with LEFT/RIGHT JOIN when comparing boolean expression with = 0 in presence of functional index |
| 119986 | 2026-03-05 11:29 | 2026-05-15 12:08 | MySQL Server: InnoDB storage engine | Open (86 days) | S3 | 8.4.7 | Any | Any | Value of sys var temptable_max_mmap not honored unless temptable_use_mmap is ON |
| 119980 | 2026-03-04 11:56 | 2026-03-04 11:56 | MySQL Server: FULLTEXT search | Open | S3 | 8.4.8 | Any | Any | Optimize full text only not working when trying to fix FTS index after tablespace import |
| 119978 | 2026-03-03 16:41 | 2026-04-08 9:16 | MySQL Server: InnoDB storage engine | Open (53 days) | S3 | 8.0 | SUSE (SLES 15 SP6) | x86 | In-place upgrade of Mysql 5.7.x/8.0.19 to revision after 8.0.23 fails due to undo_00x tablespace ID |
| 119977 | 2026-03-03 13:44 | 2026-03-03 20:55 | MySQL Server: Optimizer | Verified (89 days) | S3 | 8.0.36 | Any (windows 11) | Any | NULL > ALL(subquery) produces NULL but IS NULL / IS UNKNOWN both return FALSE |
| 119974 | 2026-03-03 2:29 | 2026-04-16 2:50 | MySQL Server: InnoDB storage engine | Open (89 days) | S3 | 8.0, 8.4, 9.6 | Any | Any | inplace algorithm dropping multi full text indexes only drops FTS AUX tables of the last index, leading orphaned tables |
| 119973 | 2026-03-02 21:01 | 2026-03-03 8:45 | MySQL Server: Optimizer | Verified (89 days) | S1 | 8.0.45 | Any | Any | Inconsistent results depending on whether the column has a PRIMARY KEY index |
| 119972 | 2026-03-02 19:47 | 2026-03-03 9:47 | MySQL Server: Optimizer | Verified (89 days) | S1 | 8.0.45 | Any | Any | Incorrect Result from IN Subquery with UNIQUE Index |
| Showing all 245 (Edit, Save, CSV, Feed) |
