Showing all 245 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
1205822026-05-31
10:11
2026-05-31
10:11
MySQL Server: OptimizerOpenS38.0.44MacOSAnyunique index causes incorrect result when comparing DOUBLE and BIGINT
1205812026-05-31
9:02
2026-05-31
9:02
MySQL Server: OptimizerOpenS28.0.44MacOSAnyunique index causes incorrect result for IN comparison with implicit type conversion
1205802026-05-31
7:52
2026-05-31
7:53
MySQL Server: OptimizerOpenS38.0.44AnyAnyMyISAM prefix index causes incorrect range query result
1205792026-05-30
11:39
2026-05-30
11:39
MySQL Server: OptimizerOpenS38.0.45AnyAnyLIKE query returns inconsistent results with MyISAM prefix index
1205782026-05-30
9:05
2026-05-30
9:05
MySQL Server: OptimizerOpenS38.0.45AnyAnyMultiple-Column Index Creation Changes Query Results
1205752026-05-30
6:57
2026-05-30
6:57
MySQL Server: OptimizerOpenS28.0.41+AnyAnyRange optimizer chooses bad range plan for large IN lists and execution is very slow and memory usage spikes.
1205742026-05-29
14:05
2026-05-29
14:12
MySQL Server: OptimizerOpenS28.0.41AnyAnyRange optimizer exceeds memory limit and chooses bad range plan for large IN lists
1205642026-05-29
6:43
2026-05-29
6:46
MySQL Server: InnoDB storage engineOpenS39.7.0AnyAnyInnoDB FTS: Off-by-one error in fts_init_index() causes unsynced document to be lost after crash recovery
1205622026-05-28
12:53
2026-05-28
12:53
MySQL Server: InnoDB storage engineOpenS19.6.0LinuxAnyInnoDB crashes with assertion failure when UPDATE touches a table with many secondary indexes
1205612026-05-28
11:11
2026-05-29
4:41
MySQL Server: DDLOpen
(3 days)
S39.7/8.4/8.0AnyAnytablespace marked missing after rollback of copy-style ALTER
1205582026-05-27
11:21
2026-05-27
11:41
MySQL Server: InnoDB storage engineOpen
(4 days)
S38.4.8AnyAnyRedo log archiving started by dead connection cannot be disabled later
1205552026-05-27
8:22
2026-05-27
11:39
MySQL Server: OptimizerVerified
(4 days)
S28.0.45UbuntuAnyEquivalent VIEW and CTE queries return different row counts with EXISTS, BINARY ENUM comparison, and LEFT JOIN
1205442026-05-25
10:47
2026-05-27
12:38
MySQL Server: OptimizerDuplicate
(4 days)
S38.4.8AnyAnyMySQL `MERGE` vs `TEMPTABLE` view evaluation changes `CROSS JOIN ... ON EXISTS(...)` cardinality
1205432026-05-25
9:57
2026-05-27
5:37
MySQL Server: OptimizerVerified
(4 days)
S28.4.8AnyAnyMySQL `MERGE` vs `TEMPTABLE` view evaluation changes `MAX(SET)` result
1205402026-05-25
1:44
2026-05-29
5:20
MySQL Server: OptimizerPatch pending
(4 days)
S29.7.0Ubuntux86A negated `IS TRUE` guard can still match a DECIMAL row for which the guarded predicate is true
1205392026-05-24
15:26
2026-05-24
15:26
MySQL Server: FULLTEXT searchOpenS29.6.0LinuxAnyDuplicate FULLTEXT index on a column returns wrong MATCH...AGAINST results when combined with a STORED generated column
1205382026-05-24
13:46
2026-05-27
13:53
MySQL Server: OptimizerDuplicate
(4 days)
S29.7.0Ubuntux86A RIGHT JOIN predicate treats IFNULL(NULL, non-NULL DECIMAL ZEROFILL) as non-matching and drops obvious rows
1205352026-05-24
5:29
2026-05-26
12:42
MySQL Server: OptimizerVerified
(5 days)
S38.0.45AnyAnyIncorrect Query Result: IN and NOT IN return the same row simultaneously (boolean logic violation)
1205342026-05-24
5:19
2026-05-26
12:26
MySQL Server: OptimizerVerified
(5 days)
S38.0.45AnyAnyWrong Query Result Due to Incorrect Evaluation of GREATEST() with Mixed Types in OR (||) Boolean Context
1205332026-05-23
12:35
2026-05-26
8:30
MySQL Server: OptimizerVerified
(5 days)
S28.0.45Ubuntux86A LEFT JOIN over DECIMAL ZEROFILL UNIQUE wrongly loses an obvious match
1205322026-05-23
12:34
2026-05-27
13:43
MySQL Server: OptimizerDuplicate
(4 days)
S29.7.0Ubuntux86An unused derived subquery triggers a DISTINCT/IFNULL wrong-result in the original path
1205312026-05-23
12:33
2026-05-26
7:24
MySQL Server: OptimizerVerified
(5 days)
S28.0.45Ubuntux86A NULL comparison inside an IN subquery becomes spuriously true in the original path
1205292026-05-22
17:08
2026-05-27
16:48
MySQL Server: InnoDB storage engineOpenS3AnyAnyContribution: Log a warning when history list length exceeds threshold
1205272026-05-22
11:47
2026-05-27
11:56
MySQL Server: OptimizerCan't repeat
(4 days)
S29.6.0LinuxAnyFULLTEXT index scan with ORDER BY and numeric WHERE filter returns empty result set
1205262026-05-22
11:47
2026-05-26
6:59
MySQL Server: OptimizerVerified
(5 days)
S38.0.43AnyAnyWrong result for IN subquery involving CURRENT_USER(), BIT column, and UNIQUE prefix index
1205252026-05-22
9:41
2026-05-26
6:49
MySQL Server: OptimizerVerified
(5 days)
S28.0.45Ubuntu (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
1205242026-05-22
9:40
2026-05-26
6:27
MySQL Server: OptimizerVerified
(5 days)
S28.0.45Ubuntu (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
1205232026-05-22
9:13
2026-05-25
20:10
MySQL Server: OptimizerVerified
(6 days)
S38.0.43AnyAnyWrong result for arithmetic expression involving DAYNAME() and BIT column
1205222026-05-22
6:39
2026-05-22
6:39
MySQL Server: OptimizerOpenS59.7.0AnyAnySub‑optimal execution plan for multi‑table row‑value IN condition leads to full index scan instead of index range scans
1205202026-05-21
16:34
2026-05-25
19:58
MySQL Server: OptimizerVerified
(6 days)
S38.0.43AnyAnyWrong result for IS NOT UNKNOWN when NULLIF() uses CURRENT_USER() as an argument
1205192026-05-21
15:49
2026-05-25
19:43
MySQL Server: OptimizerVerified
(6 days)
S38.0.43AnyAnyWrong result for BETWEEN predicate with LONGBLOB prefix PRIMARY KEY and implicit type conversion
1205182026-05-21
14:29
2026-05-25
19:27
MySQL Server: OptimizerVerified
(6 days)
S38.0.43AnyAnyWrong result for SOME quantified comparison with ELT() returning NULL and PRIMARY KEY optimization
1205152026-05-21
10:36
2026-05-21
11:55
MySQL Server: OptimizerVerified
(10 days)
S38.0AnyAnyWrong result for NOT BETWEEN involving interval arithmetic and implicit type conversion
1205142026-05-21
9:19
2026-05-21
11:47
MySQL Server: OptimizerUnsupported
(10 days)
S38.0AnyAnyWrong result for ALL quantified comparison involving interval arithmetic and PRIMARY KEY optimization
1205122026-05-21
7:43
2026-05-21
11:23
MySQL Server: OptimizerVerified
(10 days)
S38.0AnyAnyALL quantified comparison involving implicit numeric conversion of BLOB values
1205112026-05-21
7:24
2026-05-21
8:26
MySQL Server: OptimizerVerified
(10 days)
S38.0.46Ubuntux86LEFT JOIN ON with IN (empty subquery) produces a spurious match
1205042026-05-20
11:53
2026-05-29
10:36
MySQL Server: InnoDB storage engineVerified
(2 days)
S39.7AnyAnyCan't create some of tables with SPATIAL KEY because of ER_TOO_BIG_ROWSIZE
1205022026-05-20
10:16
2026-05-20
10:16
MySQL Server: OptimizerOpenS59.7.0AnyAnyImpossible WHERE with inequality-only contradictions not optimized
1204992026-05-20
5:02
2026-05-20
5:02
MySQL Server: Stored RoutinesOpenS29.6.0Linuxx86 (AMD EPYC 9K65)Recursive stored procedure with max_sp_recursion_depth >= 250 crashes mysqld
1204972026-05-19
3:12
2026-05-21
6:37
MySQL Server: OptimizerDuplicate
(12 days)
S38.4.8, 9.7.0AnyAnyINDEX Hint Prevents Reuse of InnoDB Primary-Key Suffix Order and Forces a Temporary Table
1204952026-05-18
16:12
2026-05-27
6:34
MySQL Server: OptimizerVerified
(4 days)
S59.7.0AnyAnyIncorrect Cardinality Estimation for Index Lookup with Equality Predicate on the Index Column
1204932026-05-18
14:26
2026-05-19
19:53
MySQL Server: OptimizerVerified
(12 days)
S38.0AnyAnyWrong result for SOME quantified comparison in WHERE clause
1204912026-05-18
5:53
2026-05-18
12:22
MySQL Server: OptimizerVerified
(13 days)
S28.0.46CentOSAnySemijoin returns wrong results for VARCHAR-to-DECIMAL comparison with non-canonical numeric strings
1204902026-05-18
3:24
2026-05-18
8:26
MySQL Server: OptimizerVerified
(13 days)
S59.7.0AnyAnyJoin Not Eliminated When Constant Table is Empty Due to PrimaryKeyCol IN (NULL) Condition
1204802026-05-14
20:59
2026-05-20
23:19
MySQL Server: ReplicationOpen
(11 days)
S38.0.40AnyAnyCrash in set_and_validate_user_attributes during relay log recovery
1204772026-05-14
15:50
2026-05-18
10:26
MySQL Server: OptimizerVerified
(13 days)
S59.7.0AnyAnyIndex Not Used for HAVING Without GROUP BY or aggregate functions
1204762026-05-14
11:53
2026-05-18
8:25
MySQL Server: OptimizerVerified
(13 days)
S29.6.0LinuxAnyIndex Merge Union returns duplicate row for overlapping OR conditions, producing wrong result count
1204752026-05-14
9:09
2026-05-18
10:20
MySQL Server: OptimizerVerified
(13 days)
S28.0.46LinuxAnyIndex Merge Intersection incorrectly drops matching rows in SELECT with OR predicate, returning wrong result count
1204722026-05-14
4:07
2026-05-18
9:40
MySQL Server: OptimizerVerified
(13 days)
S38.0.43AnyAnyWrong Result After Removing Semantically Redundant RIGHT JOIN ... ON FALSE
1204712026-05-14
0:08
2026-05-18
9:15
MySQL Server: ReplicationOpen
(17 days)
S18.0.43, 8.0.46, 8.4.9, 9.7.0Any (reproduced on macOS and Linux)Anybinary log violates read after write (commit) consistency
1204692026-05-13
17:00
2026-05-18
9:12
MySQL Server: InnoDB storage engineOpenS3AnyAnyContribution: Fix ut_error() at ENABLE INNODB REDO_LOG when innodb_checkpo ...
1204672026-05-13
15:57
2026-05-18
9:09
MySQL Server: InnoDB storage engineOpenS38.0.45AnyAnydd_open_fk_tables function heap-use-after-free
1204652026-05-13
8:31
2026-05-28
1:13
MySQL Server: OptimizerPatch pending
(13 days)
S38.0.46AnyAnyAVG(ASCII()) result truncated to 99.9999 with SQL_BUFFER_RESULT due to incorrect decimal precision
1204572026-05-12
15:03
2026-05-28
1:13
MySQL Server: OptimizerPatch pending
(14 days)
S29.7CentOSx86Hypergraph optimizer returns wrong results for LEFT JOIN LATERAL with SEMI JOIN when derived_merge
1204562026-05-12
15:02
2026-05-17
23:00
MySQL Server: OptimizerVerified
(14 days)
S28.0.46LinuxAnySemijoin Nested Loop index lookup uses raw VARCHAR keys against a DOUBLE B-tree, causing mismatches when the string over
1204412026-05-11
11:29
2026-05-12
2:31
MySQL Server: InnoDB storage engineOpen
(19 days)
S2trunk 8.0.24 8.4.9 AnyAnyInnoDB btr_create() can hold page latches for a long time because buf_stat_per_index->inc() may synchronously run ut_loc
1204372026-05-11
8:47
2026-05-11
8:57
MySQL Server: Information schemaOpen
(20 days)
S28.0.35, 8.4.8, 9.3.0, 9.7.0AnyAnyinformation_schema.partitions returns UINT64_MAX (18446744073709551615) for DATA_LENGTH of partition dropped during conc
1204352026-05-11
7:21
2026-05-19
14:18
MySQL Server: DDLOpenS3AnyAnyAdd DDL Triggers Support in MySQL
1204292026-05-10
7:04
2026-05-28
1:13
MySQL Server: OptimizerDocumenting
(20 days)
S29.7.0Windows (Windows Server 2022)AnyIFNULL function does not handle NULL
1204222026-05-08
8:56
2026-05-08
8:56
MySQL Server: OptimizerOpenS29.7.0 (also reproducible in 8.0.x)AnyAnyORDER BY ignored when internal_tmp_mem_storage_engine = TempTable with GROUP BY on CTE
1204202026-05-08
8:19
2026-05-08
8:19
MySQL Server: OptimizerOpenS39.7.0 (also reproducible in 8.0.x)AnyAnyORDER BY ignored when internal_tmp_mem_storage_engine = TempTable with GROUP BY on temp table
1204192026-05-08
7:50
2026-05-08
19:26
MySQL Server: OptimizerVerified
(23 days)
S38.0.46LinuxAnyrematerialized temptable cause wrong order
1204172026-05-08
6:22
2026-05-20
11:16
MySQL Server: InnoDB storage engineOpenS38.0.40Linuxx86MY-013028] [InnoDB] MySQL is freeing a thd though trx->n_mysql_tables_in_use is X and trx->mysql_n_tables_locked is Y
1204162026-05-08
0:28
2026-05-11
8:05
MySQL Server: DocumentationOpenS38.4.9AnyAnyMissing system variable in document for 8.4
1204142026-05-07
15:19
2026-05-11
12:42
MySQL Server: InnoDB storage engineOpen
(20 days)
S58.0.32 - 9.7AnyAnyInnoDB performance regression because of validate_rec_offset
1204062026-05-06
4:46
2026-05-06
9:43
MySQL Server: DocumentationVerified
(25 days)
S3AnyAnyInconsistent GBK-to-utf8mb4 conversion between implicit INSERT ... SELECT assignment and explicit CONVERT()
1204032026-05-05
13:47
2026-05-28
1:13
MySQL Server: OptimizerDocumenting
(25 days)
S28.0.46, 8.4.9, 9.7.0AnyAnyRegression in MySQL 8.0.46, 8.4.9 & 9.7.0: WHERE equality condition fails to match existing row
1204002026-05-04
17:19
2026-05-04
17:46
MySQL Server: DocumentationOpen
(27 days)
S3AnyAnyDocs for innodb_sort_buffer_size are wrong or confusing
1203952026-05-04
6:49
2026-05-04
6:49
MySQL Server: DocumentationOpenS39.7.0AnyAnyDocumentation for enable_cascade_triggers has incorrect Scope and Dynamic attributes
1203892026-05-01
2:10
2026-05-27
6:49
MySQL Server: Command-line ClientsOpenS39.7AnyAnyHELP result contains the link to MySQL 9.1
1203882026-04-30
19:36
2026-05-01
9:44
MySQL Server: InnoDB storage engineOpenS58.4.9Oracle Linux (9.5)x86High contention on InnoDB per-page BUF_BLOCK_MUTEX during concurrent range-selects to same row/page
1203772026-04-29
8:45
2026-04-29
10:47
MySQL Server: OptimizerVerified
(32 days)
S38.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
1203702026-04-28
16:33
2026-05-22
14:45
MySQL Server: DDLOpen
(9 days)
S28.0.46AnyAnyRegression (from 8.0.45) on Row size too large
1203632026-04-28
6:58
2026-04-30
8:28
MySQL Server: OptimizerVerified
(31 days)
S38.0.43Any (Docker container)Any (x86_64)LEFT JOIN ON FALSE causes incorrect NULL comparison result in MySQL
1203622026-04-28
6:13
2026-04-28
9:37
MySQL Server: DocumentationVerified
(33 days)
S29.7.0AnyAnyIncorrect syntax for CREATE VIEW in docs
1203562026-04-27
14:52
2026-04-27
17:21
MySQL Server: DDLDuplicate
(34 days)
S28.0.46Linux (Debian 12)x86ERROR 1118 Row size too large (> 8126) on 8.0.46
1203532026-04-27
11:55
2026-04-29
11:43
MySQL Server: InnoDB storage engineCan't repeat
(32 days)
S2<=8.0.42-debugAnyAny InnoDB crashes with assertion failure (ut_dbg_assertion_failed) when creating index with ALGORITHM COPY on table with F
1203522026-04-27
9:34
2026-04-28
4:26
MySQL Server: OptimizerVerified
(33 days)
S29.6.0LinuxAnyPrefix index with length 1 causes incorrect "Zero rows" optimization with float overflow literal in range condition
1203502026-04-27
8:35
2026-04-28
4:31
MySQL Server: OptimizerVerified
(33 days)
S29.6.0LinuxAnyPrefix index on TEXT column causes range scan to miss qualifying rows in MySQL
1203482026-04-27
4:37
2026-04-30
12:52
MySQL Server: DocumentationOpenS39.7AnyAnyDoc Request: What Is New in MySQL 9.7 between MySQL 8.4 LTS and MySQL 9.7 LTS
1203442026-04-26
6:43
2026-04-27
4:04
MySQL Server: OptimizerVerified
(34 days)
S29.6.0AnyAnyVIEW and equivalent CTE return different results with UNION, YEAR(0), and repeated reference in subquery
1203382026-04-23
20:37
2026-04-23
20:37
MySQL Server: DocumentationOpenS39.6, 9.7AnyAnyWhat Is New in MySQL 9.7 manual page has contents from 9.5
1203272026-04-23
7:46
2026-04-23
12:40
MySQL Server: ReplicationOpenS2MySQL 8.4AnyAnyUnsigned integer wraparound in Binlog_sender::run() when binlog_row_event_max_size is set to a large value
1203232026-04-22
12:51
2026-05-22
13:34
MySQL Server: DDLVerified
(38 days)
S18.4.9Debian (12)x86Regression : "Row size too large (> 8126)" error with table using InnoDb DYNAMIC row format
1203212026-04-22
8:52
2026-04-22
8:52
MySQL Server: DocumentationOpenS39.7AnyAnyTypo in 9.7 doc describing about offline_mode
1203192026-04-22
7:11
2026-04-22
9:43
MySQL Server: OptimizerDuplicate
(39 days)
S2MySQL 8.4.6 LTSAnyAnyIN() clause containing over-length string values for VARCHAR(N) column causes full table scan in MySQL 8.4.x, while sing
1203182026-04-22
6:31
2026-04-22
6:31
MySQL Server: InnoDB storage engineOpenS39.6.0LinuxAnyInnoDB partition statistics not auto-updated after ALTER TABLE REORGANIZE PARTITION
1203132026-04-21
17:11
2026-04-22
4:43
MySQL Server: OptimizerVerified
(39 days)
S19.6Linux (Observed on Linux via the `mysql:9.6` )AnyWrong result when only GROUP BY key order is changed in a join query with nested window-function input
1203122026-04-21
16:58
2026-04-22
4:40
MySQL Server: OptimizerVerified
(39 days)
S29.6Linux (Observed on Linux via the `mysql:9.6` )AnyWrong result for MIN(TIME) UNION ALL DATE after view extraction
1203112026-04-21
16:52
2026-04-22
4:38
MySQL Server: OptimizerVerified
(39 days)
S29.6Linux (Observed on Linux via the `mysql:9.6` )AnyWrong result for grouped SUM(DISTINCT ...) with DENSE_RANK() after view extraction
1203102026-04-21
16:45
2026-04-22
4:34
MySQL Server: OptimizerVerified
(39 days)
S29.6Linux (Observed on Linux via the `mysql:9.6` )AnyWrong result for MAX(BIT(8)) UNION ALL BLOB after view extraction in a window-function workload
1203082026-04-21
14:03
2026-04-22
4:27
MySQL Server: OptimizerVerified
(39 days)
S29.6Linux (Observed on Linux via the `mysql:9.6` )AnyWrong result for string-vs-`BIT` comparison in a window-function query
1203072026-04-21
14:02
2026-04-22
4:23
MySQL Server: OptimizerVerified
(39 days)
S29.6Linux (Observed on Linux via the `mysql:9.6` )AnyWrong result for `<= ANY (subquery)` in a window-function query
1203062026-04-21
2:23
2026-04-21
5:49
MySQL Server: DDLVerified
(40 days)
S38.0.43AnyAnyALGORITHM=INPLACE allows creating a VIRTUAL GENERATED COLUMN with invalid expressions for existing data, causing subsequ
1203042026-04-20
22:05
2026-05-06
4:55
MySQL Server: InnoDB storage engineDuplicate
(25 days)
S18.0.44CentOS (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
1203022026-04-20
9:51
2026-04-20
11:26
MySQL Server: OptimizerVerified
(41 days)
S29.6.0AnyAnyInconsistent results between VIEW and CTE involving YEAR(DATETIME), UNION, and JOIN.
1203002026-04-20
9:02
2026-04-20
11:03
MySQL Server: OptimizerVerified
(41 days)
S28.0.45Any (Observed on Linux via the `mysql:9.6` )AnyWindow function logic mismatch across engines
1202992026-04-20
9:00
2026-04-20
10:41
MySQL Server: OptimizerVerified
(41 days)
S29.6Linux (Observed on Linux via the `mysql:9.6` )Anymismatch in `DELETE ... EXISTS` under window function query
1202982026-04-20
8:58
2026-04-20
10:56
MySQL Server: DMLCan't repeat
(41 days)
S38.0.31-tr-debug AnyAnyopt_explain_json.cc:507 assert failure — EXPLAIN FORMAT=JSON on INTERSECT subquery crashes mysqld
1202972026-04-20
8:44
2026-04-20
10:04
MySQL Server: OptimizerVerified
(41 days)
S2 8.0.32AnyAnyquery_term.cc:320 assert(false) crash — UNION query triggers unhandled AccessPath
1202962026-04-20
7:50
2026-04-20
9:24
MySQL Server: OptimizerVerified
(41 days)
S28.0.45Ubuntu (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
1202942026-04-19
17:16
2026-04-27
14:11
MySQL Server: OptimizerVerified
(34 days)
S39.6.0; 8.0.45AnyAnyInconsistent fractional seconds precision (FSP) for TIME function results between VIEW and CTE
1202932026-04-19
17:10
2026-04-27
14:10
MySQL Server: OptimizerVerified
(34 days)
S19.6.0; 8.0.45AnyAnyQuery result inconsistency between VIEW and CTE involving a UNION of scalar aggregation and grouped aggregation
1202922026-04-19
17:01
2026-04-27
14:09
MySQL Server: OptimizerVerified
(34 days)
S29.6.0; 8.0.45AnyAnyInconsistent results between VIEW and CTE involving IN subquery and RIGHT JOIN
1202912026-04-19
16:45
2026-04-27
13:16
MySQL Server: OptimizerVerified
(34 days)
S29.6.0AnyAnyInconsistent results between VIEW and CTE involving EXISTS subquery and LEFT JOIN
1202892026-04-19
14:35
2026-04-20
8:13
MySQL Server: OptimizerVerified
(41 days)
S29.6Linux (Observed on Linux via the `mysql:9.6` )AnyMismatch in indexed `IN` under windows function query
1202882026-04-19
14:29
2026-04-20
8:04
MySQL Server: OptimizerVerified
(41 days)
S28.0.45Linux (Observed on Linux via the `mysql:9.6` )AnyWindow function logic mismatch in indexed `NOT IN`
1202862026-04-19
5:14
2026-04-20
7:53
MySQL Server: OptimizerVerified
(41 days)
S28.0.45AnyAny`SUM(DISTINCT pk)` returns `NULL` with a window function when a secondary index is used for group-by scanning
1202852026-04-18
15:49
2026-04-18
15:54
MySQL Server: OptimizerOpen
(43 days)
S28.0.45Ubuntu (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
1202842026-04-18
15:46
2026-04-20
7:33
MySQL Server: OptimizerVerified
(41 days)
S28.0.45Ubuntu (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
1202832026-04-17
13:00
2026-04-20
7:22
MySQL Server: OptimizerNot a Bug
(41 days)
S28.0.45Ubuntu (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
1202812026-04-17
9:21
2026-04-17
11:32
MySQL Server: ReplicationOpen
(44 days)
S28.0.42Linux (any)Anyreplica_preserve_commit_order causes infinite deadlock in group commit pipeline, blocking all application writes
1202792026-04-17
7:23
2026-04-17
14:09
MySQL Server: OptimizerVerified
(44 days)
S38.0.43 (MySQL Community Server - GPL)AnyAnySevere performance degradation with window function + joins (works fast in PostgreSQL/DuckDB/TiDB)
1202782026-04-17
2:44
2026-05-12
2:31
MySQL Server: ReplicationOpen
(19 days)
S28.0.44 8.4.9AnyAnymts_event_coord_cmp() uses strcmp() for binlog filename comparison, causing incorrect ordering when binlog index exceeds
1202752026-04-16
7:10
2026-04-20
6:51
MySQL Server: OptimizerVerified
(41 days)
S28.0.45Ubuntu (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
1202722026-04-15
11:21
2026-04-22
9:30
MySQL Server: InnoDB storage engineVerified
(39 days)
S28.0.45AnyAnyddl stuck in Waiting for clone PAGE_COPY state
1202712026-04-15
10:54
2026-04-16
21:39
MySQL Server: OptimizerVerified
(45 days)
S38.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
1202702026-04-15
9:49
2026-04-16
21:20
MySQL Server: OptimizerVerified
(45 days)
S18.0.45AnyAnyIncorrect result for INTERSECT ALL with semantically equivalent EXCEPT operands when right EXCEPT left operand is wrap
1202682026-04-14
19:38
2026-05-05
13:11
MySQL Server: DocumentationVerified
(26 days)
S15.7, 8.0, 8.4, 9.xAnyAnyClarify Symbolic Link Usage and Alternative for InnoDB
1202662026-04-14
9:12
2026-04-14
9:12
MySQL Server: ReplicationOpenS3MySQL 8.4AnyAnyReplication delay when SQL thread skips large already-executed transactions
1202652026-04-14
8:24
2026-04-14
9:47
MySQL Server: OptimizerVerified
(47 days)
S19.6.0AnyAnyQuery returns with UNION, INTERSECT ALL and Derived SELECT DISTINCT
1202622026-04-14
2:54
2026-04-16
20:55
MySQL Server: OptimizerNot a Bug
(45 days)
S28.4.8AnyAnyCREATE VIEW materialization changes INTERSECT result cardinality for an aggregate branch
1202612026-04-14
2:52
2026-04-14
4:32
MySQL Server: OptimizerVerified
(47 days)
S28.4.8AnyAnyCREATE VIEW materialization changes a key scalar output
1202602026-04-14
2:48
2026-04-14
4:42
MySQL Server: OptimizerVerified
(47 days)
S28.4.8AnyAnyCREATE VIEW materialization changes byte-valued outputs after aggregate or window processing
1202592026-04-14
2:43
2026-04-14
4:49
MySQL Server: OptimizerVerified
(47 days)
S28.4.8AnyAnyCREATE VIEW materialization changes byte-valued UNION results
1202582026-04-14
2:07
2026-04-14
4:45
MySQL Server: OptimizerVerified
(47 days)
S28.4.8AnyAnyCREATE VIEW materialization changes NULL aggregate outputs into numeric values after GROUP BY
1202562026-04-13
11:44
2026-04-13
12:48
MySQL Server: OptimizerVerified
(48 days)
S28.4.8AnyAnyCREATE VIEW materialization turns zero datetime values into runtime timestamps in UNION ALL output
1202552026-04-13
11:24
2026-04-13
13:04
MySQL Server: OptimizerVerified
(48 days)
S28.4.8AnyAnyCREATE VIEW materialization changes grouped results when replacing a grouped CTE or derived input
1202542026-04-13
10:04
2026-04-14
8:48
MySQL Server: OptimizerNot a Bug
(47 days)
S19.6.0AnyAnyEquivalent queries show different behavior due to short-circuit optimization failure
1202532026-04-13
9:14
2026-04-13
10:18
MySQL Server: OptimizerVerified
(48 days)
S38.0.45Ubuntu (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
1202512026-04-12
11:47
2026-04-13
4:58
MySQL Server: DDLVerified
(48 days)
S29.6.0AnyAnyREPLACE INTO silently bypasses ON DELETE FK rules with innodb_native_foreign_keys=OFF
1202482026-04-11
9:16
2026-04-13
4:56
MySQL Server: OptimizerVerified
(48 days)
S38.4.8UbuntuAnyChanging the order of GROUPING columns gives wrong results
1202472026-04-11
9:03
2026-05-29
11:40
MySQL Server: OptimizerDuplicate
(2 days)
S38.4.8UbuntuAnyCREATE VIEW materialization changes RIGHT JOIN preserved-side filtering result cardinality
1202452026-04-10
13:14
2026-04-10
13:55
MySQL Server: DDLOpenS19.6.0AnyAnyUnexpected error `Got error -1 - 'Unknown error -1' from storage engine`
1202442026-04-10
12:40
2026-04-10
13:51
MySQL Server: DDLOpenS19.6.0AnyAnyUnexpected error `'0' for column '' at row -1` triggered by ALTER
1202412026-04-09
11:02
2026-04-09
11:02
MySQL Server: InnoDB storage engineOpenS3trunkAnyAnyFix ambiguity in the name and doxygen of method buf_flush_sync_all_buf_pools()
1202382026-04-09
9:16
2026-04-09
9:34
MySQL Server: ReplicationOpenS35.7 8.0LinuxAnymaybe cause "could not find next log" if rotate binary log without fsync @@log_bin_index's parent dir
1202372026-04-08
17:05
2026-04-09
8:59
MySQL Server: DDLVerified
(52 days)
S39.6 and 8.4AnyAnyDEFAULT(UUID()) allowed at CREATE TABLE but rejected in ALTER TABLE with binary logging enabled
1202352026-04-08
10:17
2026-04-08
10:17
MySQL Server: XML functionsOpenS38.0Windows (Win11)x86 (na)Un/Comment Selection
1202312026-04-08
4:55
2026-04-11
11:50
MySQL Server: DocumentationVerified
(50 days)
S38.0.29AnyAnyTypo in MySQL 8.0.29 release note
1202252026-04-07
13:40
2026-04-08
4:30
MySQL Server: OptimizerVerified
(53 days)
S38.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
1202242026-04-07
12:25
2026-04-08
4:34
MySQL Server: OptimizerVerified
(53 days)
S38.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
1202232026-04-07
12:06
2026-04-09
19:33
MySQL Server: Data TypesVerified
(52 days)
S29.6.0LinuxAnyVECTOR(0) silently accepted, produces unusable column with corrupted metadata (dimension 4294967295)
1202222026-04-07
12:02
2026-04-09
19:30
MySQL Server: Data TypesVerified
(52 days)
S29.6.0LinuxAnyVECTOR(n) dimension silently wraps to wrong value due to integer overflow in parser
1202172026-04-05
12:27
2026-04-06
5:24
MySQL Server: OptimizerVerified
(55 days)
S39.6.0Ubuntu (22.04)AnyGROUPING() in ORDER BY of EXISTS/IN/ALL/ANY subquery: invalid arguments not rejected
1202152026-04-04
16:59
2026-04-06
5:38
MySQL Server: OptimizerVerified
(55 days)
S39.6.0Ubuntu (22.04)AnyInconsistent window aggregate results with GROUP BY ... WITH ROLLUP
1202082026-04-03
7:57
2026-05-04
1:00
MySQL Server: DMLNo Feedback
(28 days)
S18.0.28Any (Aurora MySQL 3.04.4)AnySIGSEGV crash in TABLE_LIST::query_block_id_for_explain() when running EXPLAIN on CTE (WITH clause) query
1202062026-04-02
19:48
2026-04-02
19:48
MySQL Server: PartitionsOpenS29.6.0AnyAnyEXCHANGE PARTITION bypasses CHECK CONSTRAINT validation
1202042026-04-02
7:52
2026-04-02
7:52
MySQL Server: InnoDB storage engineOpenS29.4.0AnyAnyUPDATE statements fail to update rows or acquire locks after being released
1202032026-04-02
2:35
2026-04-04
19:49
MySQL Server: OptimizerVerified
(57 days)
S28.0.45AnyAnyMySQL returns an incorrect result for an indexed comparison between an `INT` column and a non-integer function value.
1201992026-04-01
8:00
2026-04-01
8:00
MySQL Server: InnoDB storage engineOpenS29.4.0AnyAnyTwo transactions simultaneously acquire the same exclusive lock
1201982026-04-01
7:45
2026-04-16
14:30
MySQL Server: ReplicationVerified
(45 days)
S38.0.45AnyAnyLost gtid after crash recovery
1201962026-03-31
23:50
2026-04-03
6:23
MySQL Server: InnoDB storage engineOpenS39.6.0AnyAnyn_mysql_tables_in_use uint32 underflow via MRR dsmrr_init() error path in handler.cc
1201852026-03-31
8:58
2026-04-06
4:47
MySQL Server: DMLCan't repeat
(55 days)
S28.0.32-debugAnyAny Assertion Failure in add_key_fields with Nested CTE
1201832026-03-30
21:14
2026-03-30
21:14
MySQL Server: GeneralOpenS3AnyAnyContribution: Consolidate duplicated cmake flags in MySQL RPM spec using sh ...
1201822026-03-30
21:14
2026-03-30
21:14
MySQL Server: GeneralOpenS3AnyAnyContribution: Consolidate duplicated cmake flags in MySQL DEB packaging usi ...
1201812026-03-30
21:14
2026-04-20
13:09
MySQL Server: ReplicationOpenS3AnyAnyContribution: Fix stale sql_mode values in Query_event Doxygen documentatio ...
1201792026-03-30
10:54
2026-03-30
12:26
MySQL Server: OptimizerVerified
(62 days)
S38.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
1201772026-03-30
6:38
2026-04-01
12:10
MySQL Server: ReplicationOpenS35.7.44AnyAnyLost gtids after crash recovery
1201742026-03-28
9:25
2026-03-29
20:21
MySQL Server: OptimizerVerified
(63 days)
S38.0.45Ubuntu (22.04)AnyIncorrect empty result for BETWEEN on binary string columns when a UNIQUE index is used
1201722026-03-28
9:14
2026-03-29
20:15
MySQL Server: OptimizerVerified
(63 days)
S38.0.45Ubuntu (22.04)AnyInconsistent result: NOT IN (subquery on BIT column) differs when using secondary index vs IGNORE INDEX
1201712026-03-28
8:58
2026-03-29
20:06
MySQL Server: OptimizerVerified
(63 days)
S38.0.45Ubuntu (22.04)AnyWrong result: LEFT JOIN empty derived table + WHERE equality uses literal from SELECT list
1201702026-03-28
8:33
2026-03-28
8:33
MySQL Server: InnoDB storage engineOpenS28.0.39AnyAny Missing Update in READ COMMITTED during concurrent UPDATE with row re-evaluation failure.
1201612026-03-26
14:19
2026-03-27
4:56
MySQL Server: OptimizerDuplicate
(65 days)
S38.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Incorrect partial row duplication with RIGHT JOIN and empty subquery
1201592026-03-26
11:41
2026-03-27
4:57
MySQL Server: OptimizerVerified
(66 days)
S38.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)RIGHT JOIN + Complex Subqueries Returns Extra Rows
1201582026-03-26
6:04
2026-03-29
19:37
MySQL Server: OptimizerVerified
(63 days)
S28.0.45Ubuntu (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
1201532026-03-25
16:15
2026-03-25
16:18
MySQL Server: OptionsOpenS39.5AnyAnyWrong default value for default_collation_for_utf8mb4
1201522026-03-25
8:50
2026-03-26
9:05
MySQL Server: OptimizerVerified
(66 days)
S38.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
1201462026-03-25
6:22
2026-05-28
14:53
MySQL Server: OptimizerOpen
(3 days)
S29.6.0Linux (ubuntu 20.04)x86Wrong result due to incorrect const-table pruning for NOT IN on FLOAT UNIQUE column in MEMORY engine
1201452026-03-25
6:05
2026-03-25
19:22
MySQL Server: OptimizerVerified
(67 days)
S28.0.45Linux (ubuntu 20.04)x86Incorrect empty result after relocating a HAVING predicate into a derived-table boolean column with WHERE ref1
1201442026-03-25
6:03
2026-03-25
19:10
MySQL Server: OptimizerClosed
(67 days)
S39.6.0AnyAnySubmitted by mistake
1201352026-03-24
2:02
2026-03-31
6:50
MySQL Server: ReplicationDuplicate
(61 days)
S38.0.*AnyAnyWhen explicit_defaults_for_timestamp is off, replication exceptions when insert a null value.
1201322026-03-23
11:28
2026-03-24
7:45
MySQL Server: OptimizerVerified
(68 days)
S38.4.8AnyAnyUnexpected Query Results Caused by Prefix Index on TEXT Column
1201312026-03-23
11:27
2026-03-24
7:40
MySQL Server: OptimizerVerified
(68 days)
S38.0.45AnyAnyBug in Query Behavior due to ZEROFILL in DOUBLE Column
1201292026-03-23
9:29
2026-03-23
9:29
MySQL Server: InnoDB storage engineOpenS38.0.39AnyAnyNon-deterministic semi-consistent read behavior: UPDATE randomly blocks on non-matching locked rows in READ UNCOMMITTED.
1201282026-03-23
8:14
2026-05-28
1:13
MySQL Server: ReplicationDocumenting
(53 days)
S38.0.*AnyAnyWhen explicit_defaults_for_timestamp is off, inserting a null value causes replication exceptions.
1201242026-03-22
10:29
2026-03-22
10:29
MySQL Server: DDLOpenS39.6AnyAnyRemove unused partition states from enum partition_state {
1201232026-03-20
7:15
2026-03-20
12:18
MySQL Server: OptimizerVerified
(72 days)
S38.0.45AnyAnyInconsistent query results when using EXISTS subqueries with MyISAM engine in derived tables.
1201222026-03-20
4:58
2026-03-20
12:06
MySQL Server: OptimizerVerified
(72 days)
S38.0.45Linuxx86Inconsistent evaluation of GREATEST() with ZEROFILL column in OUTER JOIN queries
1201212026-03-20
4:51
2026-03-20
9:41
MySQL Server: OptimizerDuplicate
(72 days)
S19.5.0AnyAnyPhantom Drift: Wrong Result in INTERSECT with NULL caused by Prefix Primary Key and Cartesian Join
1201152026-03-19
15:21
2026-03-19
15:32
MySQL Server: ReplicationOpenS38.4AnyAnyCHANGE REPLICATION FILTER REPLICATE_IGNORE_DB with ROW BASED REPLICATION NOT WORKING AS DESCRIBED
1201142026-03-19
12:05
2026-03-19
14:31
MySQL Server: OptimizerNot a Bug
(73 days)
S39.6.0AnyAnyInconsistent result when using MAX(c0) inside GREATEST compared to standalone evaluation
1201062026-03-19
7:49
2026-03-19
8:33
MySQL Server: OptimizerVerified
(73 days)
S18.0.45AnyAnyOptimizer incorrectly handles constant derived table in RIGHT JOIN
1201052026-03-19
7:42
2026-04-17
17:11
MySQL Server: InnoDB storage engineCan't repeat
(51 days)
S28.0.22AnyAnymysql crash on fil_report_invalid_page_access_low
1201042026-03-19
7:36
2026-03-30
7:32
MySQL Server: DDLOpen
(62 days)
S38.4.7AnyAnyModify VARCHAR column leads to unexpected rebuild of table
1200992026-03-18
12:08
2026-03-19
8:04
MySQL Server: OptimizerVerified
(73 days)
S18.0.45AnyAnyQuery returns wrong result when condition involves CAST(division AS CHAR)
1200982026-03-18
9:58
2026-03-18
10:59
MySQL Server: OptimizerVerified
(74 days)
S18.0.45AnyAnyIncorrect result when using EXISTS with INTERSECT ALL and correlated subquery
1200972026-03-18
9:34
2026-03-18
9:48
MySQL Server: OptimizerVerified
(74 days)
S18.0.45AnyAnyIncorrect result set when use INTERSECT ALL
1200952026-03-18
8:42
2026-03-31
1:45
MySQL Server: DMLOpen
(61 days)
S38.4.8, 8.0.41AnyAnyquery result changed after UPDATE HISTOGRAM, caused by query plan changed to "skip scan"
1200942026-03-18
8:29
2026-03-18
9:35
MySQL Server: OptimizerVerified
(74 days)
S18.0.45AnyAnyQuery returns incorrect results due to incorrect handling of predicate logic
1200932026-03-18
8:12
2026-03-18
9:18
MySQL Server: OptimizerNot a Bug
(74 days)
S38.0.45Linuxx86Incorrect result with OUTE JOIN and NULL-dependent LIKE predicate on FLOAT values when partitioned by IS NULL conditions
1200912026-03-18
6:13
2026-03-18
9:01
MySQL Server: OptimizerVerified
(74 days)
S38.0.45Linuxx86Incorrect result with OUTER JOIN on DECIMAL compared to floating-point condition when partitioned by IS NOT NULL predica
1200902026-03-18
4:40
2026-03-18
8:13
MySQL Server: OptimizerNot a Bug
(74 days)
S3Linuxx86Incorrect result with OUTER JOIN and CASE expression with string literal in join condition
1200872026-03-17
13:12
2026-03-18
4:58
MySQL Server: OptimizerVerified
(74 days)
S28.0.45Linuxx86Incorrect result with RIGHT JOIN and IS NULL predicate on partitioned indexed table
1200842026-03-17
9:40
2026-03-17
11:47
MySQL Server: OptimizerVerified
(75 days)
S38.0.45Linuxx86Incorrect result with string-to-decimal comparison in OUTER JOIN condition
1200832026-03-17
8:59
2026-03-17
11:38
MySQL Server: OptimizerVerified
(75 days)
S28.0.45Linuxx86incorrect result when comparing floating constant in OUTER JOIN condition
1200802026-03-17
5:35
2026-03-17
11:23
MySQL Server: OptimizerNot a Bug
(75 days)
S39.6.0AnyAnyInconsistent result when using LEAST() with string literal and VAR_POP(), especially when combined with CAST to SIGNED
1200792026-03-17
5:04
2026-03-17
11:12
MySQL Server: OptimizerNot a Bug
(75 days)
S39.6.0AnyAnyIncorrect result when casting VARIANCE() inside IF() expression to SIGNED
1200752026-03-16
14:26
2026-03-25
12:47
MySQL Server: OptimizerVerified
(74 days)
S18.0.45Linux (ubuntu 20.04)x86Silent Data Truncation of DOUBLE (DBL_MAX) in Subqueries/Temporary Tables
1200722026-03-16
8:39
2026-03-16
14:44
MySQL Server: OptimizerDuplicate
(76 days)
S39.5.0AnyAnyaftter changing UNION ALL to INTERSECT,the rows matched unexpectedly become more
1200582026-03-14
10:40
2026-03-14
14:52
MySQL Server: OptimizerVerified
(78 days)
S38.0.45AnyAnyUPDATE IGNORE fails to match rows when combining OR-weakened predicates with complex CASE expressions
1200572026-03-14
4:32
2026-03-14
14:43
MySQL Server: OptimizerVerified
(78 days)
S38.0.45AnyAnyMulti-table UPDATE with CTE returns zero rows when weakening a predicate from '=' to '<='
1200562026-03-14
4:22
2026-03-14
14:24
MySQL Server: OptimizerVerified
(78 days)
S38.0.45AnyAnyUPDATE IGNORE returns empty result after weakening WHERE clause with OR in a JOIN context
1200532026-03-13
10:58
2026-03-13
15:09
MySQL Server: OptimizerDuplicate
(79 days)
S19.5.0AnyAnyEXCEPT Returns Different Results Based on Composite Primary Key, WHERE Conditions, BNL Optimization
1200512026-03-13
9:31
2026-03-13
21:16
MySQL Server: OptimizerVerified
(79 days)
S18.0.45Linux (ubuntu 20.04)AnyWrong result for derived-table rewrite of GROUP BY ... HAVING query
1200502026-03-13
9:00
2026-03-17
12:22
MySQL Server: InnoDB storage engineOpenS58.0.44AnyAnyremove dead code
1200492026-03-13
7:41
2026-03-30
13:52
MySQL Server: OptimizerDuplicate
(62 days)
S39.5.0AnyAnyDELETE with STRAIGHT_JOIN fails to match rows after simplifying INTERSECT sequence in EXISTS subquery
1200472026-03-13
5:08
2026-03-13
5:57
MySQL Server: OptimizerVerified
(79 days)
S39.5.0AnyAnyIncorrect empty update result when weakening WHERE clause in UPDATE IGNORE with CROSS JOIN and IN subquery
1200452026-03-13
2:54
2026-03-30
13:41
MySQL Server: OptimizerDuplicate
(62 days)
S19.5.0AnyAnyINTERSECT Returns Inconsistent Results Based on optimizer_switch and WHERE Clause
1200372026-03-12
2:46
2026-03-13
11:31
MySQL Server: OptimizerVerified
(79 days)
S38.4.8AnyAnyQuery Results Differ Between Tables with Same Data and Query Due to RENAME Operation
1200362026-03-12
2:09
2026-03-13
13:15
MySQL Server: OptimizerVerified
(79 days)
S38.0.45AnyAnyDifferent results for semantically equivalent expressions using CASE and MIN(CASE ...) with GROUP BY on a FLOAT column
1200342026-03-11
15:13
2026-03-11
21:10
MySQL Server: OptimizerVerified
(81 days)
S38.4.8AnyAnyWrong Results with LOG(1, N) <=> NULL: UNIQUE Constraint Causes Incorrect Row Deduplication
1200332026-03-11
15:01
2026-03-11
21:02
MySQL Server: OptimizerVerified
(81 days)
S38.4.8AnyAnyInconsistent Results with SUBTIME(1, SYSDATE()) in HAVING Clause: UNIQUE Constraint Affects Optimizer Evaluation
1200322026-03-11
14:56
2026-03-11
20:56
MySQL Server: OptimizerVerified
(81 days)
S38.4.8AnyAnyInconsistent Aggregation Results in Derived Tables: PRIMARY KEY Affects AVG(NOT(...)) Evaluation and Optimizer Execution
1200312026-03-11
14:48
2026-03-11
20:46
MySQL Server: OptimizerVerified
(81 days)
S38.4.8AnyAnyInconsistent INTERSECT Results in Derived Tables: Impact of PRIMARY KEY on JSON_OBJECTAGG and LEAST Operators
1200302026-03-11
14:44
2026-03-11
20:31
MySQL Server: OptimizerVerified
(81 days)
S38.4.8AnyAnyQuery Results Differ Due to Primary Key and INTERSECT Operation
1200292026-03-11
14:42
2026-03-11
20:19
MySQL Server: OptimizerVerified
(81 days)
S38.4.8AnyAnyQuery Results Differ Due to Primary Key Column - Issue with MIN, MAX, and Time-Related Functions
1200282026-03-11
14:38
2026-03-11
19:59
MySQL Server: OptimizerVerified
(81 days)
S38.4.8AnyAnyQuery Results Differ Due to Primary Key Column and TRUNCATE Function Behavior
1200272026-03-11
14:34
2026-03-11
19:48
MySQL Server: OptimizerVerified
(81 days)
S38.4.8AnyAnyQuery Results Differ Due to Presence of Primary Key - Issue with MIN and DATE_ADD Functions
1200262026-03-11
14:30
2026-03-11
19:37
MySQL Server: OptimizerCan't repeat
(81 days)
S38.4.8AnyAnyQuery Results Differ Between Tables with Same Data and Query Due to RENAME Operation
1200222026-03-11
2:22
2026-03-11
7:10
MySQL Server: OptimizerVerified
(81 days)
S3MySQL 8.0.28AnyAnyCAST(AVG()) returns a different result than CAST(SUM()/COUNT()) on DECIMAL values
1200192026-03-10
12:29
2026-03-10
14:40
MySQL Server: OptimizerVerified
(82 days)
S28.0.41AnyAnyquery result change after removing partitioning
1200162026-03-09
17:41
2026-03-10
7:58
MySQL Server: DocumentationVerified
(82 days)
S28.0, 8.4, 9.xAnyAnyDocumentation "Exchanging Partitions and Subpartitions with Tables" not mentioning limitation about ALGORITHM=INSTANT.
1200152026-03-09
13:48
2026-04-02
6:16
MySQL Server: OptimizerDuplicate
(59 days)
S18.0.45AnyAnyIncorrect retention of NULL rows due to CASE evaluation error in WHERE clause.
1200132026-03-09
11:27
2026-03-09
13:50
MySQL Server: OptimizerNot a Bug
(83 days)
S19.6.0AnyAnyInconsistent results between equivalent queries involving logical predicates and set operations
1200112026-03-09
10:29
2026-03-09
11:16
MySQL Server: OptimizerVerified
(83 days)
S18.0.44AnyAnyThe normal query generated a non-optimal query plan with index.
1200102026-03-09
9:56
2026-04-03
10:55
MySQL Server: OptimizerDuplicate
(59 days)
S18.0.45AnyAnyIncorrect result set when evaluating IS NULL on a derived table containing logical AND expressions
1200052026-03-08
0:14
2026-03-10
8:04
MySQL Server: OptimizerVerified
(82 days)
S28.4.7AnyAnyWrong results with subquery with semijoin=on and antijoin optimization
1200042026-03-07
19:38
2026-03-09
9:48
MySQL Server: OptimizerVerified
(83 days)
S28.0.31 AnyAnyIndexSkipScanIterator Assertion Failure
1200032026-03-07
12:14
2026-03-09
9:41
MySQL Server: OptimizerVerified
(83 days)
S38.0.45AnyAnycolumn name unexpectedly change because of '1' as a column
1199982026-03-06
14:56
2026-03-09
11:52
MySQL Server: OptimizerNot a Bug
(83 days)
S38.4.8Ubuntu (22.04)AnyERROR 1292 Incorrect value on INSERT…SELECT when CAST result is NULL
1199972026-03-06
13:12
2026-03-20
15:06
MySQL Server: InnoDB storage engineOpen
(73 days)
S38.0.40AnyAnySetting innodb_use_native_aio to OFF can lead to severe lock contention.
1199962026-03-06
11:07
2026-05-28
1:13
MySQL Server: DDLDocumenting
(75 days)
S29.6AnyAnyRow delete from a table with selfreferental FK breaks replication
1199952026-03-06
9:51
2026-04-27
10:07
MySQL Server: OptimizerClosed
(34 days)
S28.0.45AnyAnyFunction find_in_set return wrong result
1199942026-03-06
8:20
2026-03-09
8:17
MySQL Server: OptimizerDuplicate
(83 days)
S2Linuxx86Incorrect result with LEFT/RIGHT JOIN using functional index and boolean expression comparison
1199932026-03-06
7:57
2026-03-09
8:14
MySQL Server: OptimizerDuplicate
(83 days)
S2Linuxx86Incorrect result with LEFT/RIGHT JOIN when using functional index and boolean expression comparison
1199922026-03-06
6:23
2026-03-09
8:07
MySQL Server: OptimizerDuplicate
(83 days)
S28.0.45Linuxx86Incorrect result for LEFT/RIGHT JOIN when using IS TRUE / IS FALSE expressions on the right table with NULL padding.
1199912026-03-06
5:56
2026-03-06
11:27
MySQL Server: OptimizerVerified
(86 days)
S28.0.45Linuxx86Incorrect result with LEFT/RIGHT JOIN when comparing boolean expression with = 0 in presence of functional index
1199862026-03-05
11:29
2026-05-15
12:08
MySQL Server: InnoDB storage engineOpen
(86 days)
S38.4.7AnyAnyValue of sys var temptable_max_mmap not honored unless temptable_use_mmap is ON
1199802026-03-04
11:56
2026-03-04
11:56
MySQL Server: FULLTEXT searchOpenS38.4.8AnyAnyOptimize full text only not working when trying to fix FTS index after tablespace import
1199782026-03-03
16:41
2026-04-08
9:16
MySQL Server: InnoDB storage engineOpen
(53 days)
S38.0SUSE (SLES 15 SP6)x86In-place upgrade of Mysql 5.7.x/8.0.19 to revision after 8.0.23 fails due to undo_00x tablespace ID
1199772026-03-03
13:44
2026-03-03
20:55
MySQL Server: OptimizerVerified
(89 days)
S38.0.36Any (windows 11)AnyNULL > ALL(subquery) produces NULL but IS NULL / IS UNKNOWN both return FALSE
1199742026-03-03
2:29
2026-04-16
2:50
MySQL Server: InnoDB storage engineOpen
(89 days)
S38.0, 8.4, 9.6AnyAnyinplace algorithm dropping multi full text indexes only drops FTS AUX tables of the last index, leading orphaned tables
1199732026-03-02
21:01
2026-03-03
8:45
MySQL Server: OptimizerVerified
(89 days)
S18.0.45AnyAnyInconsistent results depending on whether the column has a PRIMARY KEY index
1199722026-03-02
19:47
2026-03-03
9:47
MySQL Server: OptimizerVerified
(89 days)
S18.0.45AnyAnyIncorrect Result from IN Subquery with UNIQUE Index
Showing all 245 (Edit, Save, CSV, Feed)