Showing 1-1000 of 2284 (Edit, Save, CSV, Feed) Show Next 1000 Entries »
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
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
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
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
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
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
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
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
1205022026-05-20
10:16		2026-05-20
10:16		MySQL Server: OptimizerOpenS59.7.0AnyAnyImpossible WHERE with inequality-only contradictions not optimized
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
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
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
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
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
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
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
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
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
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
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
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)
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
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
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
1202632026-04-14
5:30		2026-04-14
10:56		MySQL Server: JSONVerified
(47 days)		S28.0.45AnyAnyInconsistent results for query with JSON_CONTAINS and CAST(... AS SIGNED)
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
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
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
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
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.
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
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
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
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
1201422026-03-25
3:09		2026-03-25
20:29		MySQL Server: JSONVerified
(67 days)		S38.0.45AnyAnyIncorrect result with DISTINCTROW and JSON_OBJECTAGG when replacing COALESCE(SUM(NULL),0) with constant
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
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
1201112026-03-19
9:14		2026-03-19
14:10		MySQL Server: JSONVerified
(73 days)		S38.0.45AnyAnyUnexpected row elimination when using DISTINCT on JSON_SET output
1201102026-03-19
9:04		2026-03-19
14:07		MySQL Server: JSONVerified
(73 days)		S38.0.45AnyAnyWrong result: DISTINCT eliminates JSON_OBJECT result containing NULL value
1201092026-03-19
9:01		2026-03-19
14:03		MySQL Server: JSONVerified
(73 days)		S38.0.45AnyAnyWrong result: DISTINCT eliminates JSON_ARRAY(NULL) result
1201072026-03-19
8:40		2026-03-19
13:34		MySQL Server: JSONVerified
(73 days)		S38.0.45AnyAnyDISTINCT eliminates non-duplicate rows for JSON_OBJECTAGG results
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
1201022026-03-19
1:34		2026-03-19
8:22		MySQL Server: JSONVerified
(73 days)		S38.0.45AnyAnyIncorrect DISTINCT behavior with JSON_ARRAYAGG when aggregating NULL-only groups
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
1199632026-03-02
9:08		2026-03-02
13:43		MySQL Server: OptimizerVerified
(90 days)		S38.0.45AnyAnyInconsistent Results When Comparing Identical Aggregate Calculations Between Main Query and Correlated Subquery
1199592026-03-01
14:50		2026-03-02
13:16		MySQL Server: OptimizerVerified
(90 days)		S38.0.45Linux (ubuntu 20.04)x86Inconsistent results between direct query and derived table query involving NULLIF and IS NOT UNKNOWN
1199582026-02-28
13:09		2026-03-02
13:02		MySQL Server: OptimizerVerified
(90 days)		S18.0.45AnyAnyEXISTS subquery result behaves inconsistently based on source table
1199552026-02-27
5:03		2026-03-02
12:46		MySQL Server: OptimizerVerified
(90 days)		S38.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Semantically equivalent scalar expressions yield different result sets in WHERE clause involving RPAD()
1199542026-02-26
21:13		2026-02-28
17:08		MySQL Server: CompilingOpen
(92 days)		S38.4.8Ubuntu (Ubuntu 24.04.3 LTS)x86 (n.a.)libaio1.so loading shared library fails in binary tarball b/c it is renamed to libaio1t64
1199442026-02-25
22:14		2026-02-26
13:13		MySQL Server: OptimizerVerified
(94 days)		S18.0, 8.4, 9.XAnyAnyFeature Request: Extend TIMESTAMP range beyond 2038-01-19 by switching to 64-bit signed storage (Year 2038 Problem)
1199372026-02-25
4:54		2026-02-25
9:25		MySQL Server: OptimizerVerified
(95 days)		S38.0AnyAnyResult is not correct when using pow function with group by
1199272026-02-20
10:28		2026-02-25
8:56		MySQL Server: OptimizerVerified
(95 days)		S28.0.45LinuxAnyInconsistent results between direct query and derived table with BIGINT column and FLOAT predicate (IN clause)
1199182026-02-17
8:12		2026-02-17
8:31		MySQL Server: OptimizerVerified
(103 days)		S29.6.0AnyAnyTree based explain format doesn't work well with MySQL Client or MySQL Shell
1199122026-02-15
4:33		2026-02-15
12:09		MySQL Server: OptimizerVerified
(105 days)		S28.0.45LinuxAnyJOIN query returns different results depending on index visibility
1199092026-02-12
21:31		2026-02-12
21:31		MySQL Server: OptimizerOpenS29.5.0AnyAnyWrong result due to unsafe Item_max optimization triggering on homogeneous subqueries but not heterogeneous ones
1199082026-02-12
12:49		2026-02-13
7:26		MySQL Server: OptimizerVerified
(107 days)		S38.0.34AnyAnyGROUP_CONCAT returns corrupted characters when column charset is utf8mb4 and connection charset is gbk
1198342026-02-02
13:44		2026-02-03
13:20		MySQL Server: OptimizerVerified
(117 days)		S38.0.44AnyAnyInconsistent query results when selecting different columns with the same JOIN condition involving LIKE (EXISTS(subquery
1198322026-02-02
9:12		2026-02-03
12:21		MySQL Server: OptimizerVerified
(117 days)		S38.0.44AnyAnydrop index can lead to different results
1198312026-02-02
8:32		2026-02-03
12:56		MySQL Server: OptimizerVerified
(117 days)		S38.0.44AnyAnydrop index can lead to different results
1198252026-02-01
12:02		2026-02-02
3:51		MySQL Server: OptimizerVerified
(118 days)		S28.0.45, 8.4.8, 9.6AnyAnyInconsistent results between INNER JOIN and STRAIGHT_JOIN when comparing DOUBLE constant with INT UNIQUE column
1198242026-02-01
11:59		2026-02-02
3:57		MySQL Server: OptimizerVerified
(118 days)		S38.0.44AnyAnydrop index can lead to incorrect results
1198232026-02-01
11:42		2026-02-02
3:55		MySQL Server: OptimizerVerified
(118 days)		S38.0.44AnyAnydrop index can lead to different results
1198222026-01-31
17:35		2026-01-31
22:04		MySQL Server: OptimizerVerified
(120 days)		S28.0.45AnyAnyMySQL and TiDB return different results
1198192026-01-31
10:29		2026-01-31
21:41		MySQL Server: OptimizerVerified
(120 days)		S38.0.44AnyAnydrop index can lead to different results
1198182026-01-31
8:53		2026-01-31
21:34		MySQL Server: OptimizerVerified
(120 days)		S38.0.44AnyAnyA different results occured after inserting a NULL record
1198162026-01-31
7:56		2026-01-31
21:19		MySQL Server: OptimizerVerified
(120 days)		S38.0.44AnyAnyCreate index can lead to incorrect results
1198152026-01-31
7:03		2026-01-31
21:11		MySQL Server: OptimizerVerified
(120 days)		S38.0.44AnyAnyAn incorrect results after inserting a record
1198142026-01-31
4:11		2026-01-31
20:59		MySQL Server: OptimizerVerified
(120 days)		S38.0.44AnyAnydrop index can lead to incorrect results
1198082026-01-29
14:44		2026-04-20
11:52		MySQL Server: DMLOpen
(41 days)		S2AnyAnyError 3569 with HIGH_PRIORITY + VIEW + GROUP BY + FOR UPDATE
1198052026-01-29
3:21		2026-01-29
4:15		MySQL Server: DMLVerified
(122 days)		S28.0.45AnyAnycreate_tmp_field assert fail
1198022026-01-28
13:49		2026-01-28
15:52		MySQL Server: OptimizerVerified
(123 days)		S28.0.42+AnyAnyAssertion 'is_nullable()' failed in Item_typecast_signed::val_int()
1198002026-01-28
8:53		2026-01-28
11:54		MySQL Server: CompilingOpen
(123 days)		S18.4AnyAnyAn error occurred in ssl.cmake reading version information from opensslv.h, causing HAVE_TLSv13 to fail to compile.
1197992026-01-27
21:40		2026-01-28
9:08		MySQL Server: OptimizerVerified
(123 days)		S38.0.44MacOSARMOR condition incorrectly filters out NULL values in derived table with UNION
1197932026-01-27
10:32		2026-02-04
16:32		MySQL Server: Prepared statementsVerified
(116 days)		S19.5.0AnyAnyIncorrect result of prepared SELECT when running with JDBC
1197902026-01-27
10:14		2026-01-27
12:07		MySQL Server: OptimizerVerified
(124 days)		S18.0.44AnyAnyUnexpected result of expression IN NULL
1197762026-01-26
9:31		2026-01-26
13:51		MySQL Server: OptimizerVerified
(125 days)		S38.0.41AnyAnySemantically identical SQLs yield different result sets.
1197672026-01-24
12:57		2026-01-24
12:57		MySQL Server: CompilingOpenS29.6.0FreeBSD (15)x86MySQL fails to build on FreeBSD
1197522026-01-22
15:08		2026-01-22
21:36		MySQL Server: OptimizerVerified
(129 days)		S38.0.44AnyAnyafter changing MINUTE(subq.c1) to MINUTE(subq.c1 + INTERVAL '60' MINUTE),the result become empty.
1197412026-01-22
7:00		2026-01-22
8:35		MySQL Server: OptimizerVerified
(129 days)		S18.0.44AnyAnyinternal_tmp_mem_storage_engine = MEMORY setting makes the DISTINCTROW returns incorrect result on 0 and -0
1197272026-01-20
10:11		2026-01-27
18:37		MySQL Server: Data TypesVerified
(131 days)		S38.0.44AnyAnywrong result for 'value between a and null' for certain temporal types
1197242026-01-20
5:55		2026-01-20
8:08		MySQL Server: OptimizerVerified
(131 days)		S38.0.44AnyAnyafter changing asin function in group clause,column's value unexpectedly change
1197162026-01-19
1:36		2026-01-19
9:16		MySQL Server: OptimizerVerified
(132 days)		S18.0.44AnyAnySuboptimal query plan generated by normal query compare to prepared statement
1197142026-01-18
12:26		2026-01-19
9:01		MySQL Server: OptimizerVerified
(132 days)		S38.0.44AnyAnyafter changing ASIN(hpg31.c1) in group clause,the col_1’s value unexpectedly change.
1197132026-01-18
11:19		2026-01-20
9:37		MySQL Server: OptimizerVerified
(131 days)		S38.0.39, 8.0.44, 8.4.6AnyAnyMySQL has hard time using the right indexes
1197082026-01-16
14:58		2026-02-08
12:32		MySQL Server: OptimizerVerified
(112 days)		S28.0.44LinuxAnyINNER JOIN and STRAIGHT_JOIN produce different results with FLOAT UNIQUE column on MEMORY table
1197062026-01-16
10:46		2026-03-17
8:21		MySQL Server: OptimizerOpen
(75 days)		S28.0.44, 9.5.0AnyAnyIncorrect Results from ALL/ANY Subquery MIN/MAX Optimization with Type Mismatch
1197012026-01-16
7:18		2026-01-16
9:45		MySQL Server: OptimizerVerified
(135 days)		S38.0.44AnyAnyafter changing FLOOR function,col_1’s value unexpectedly change
1196982026-01-16
7:08		2026-01-16
9:16		MySQL Server: OptimizerVerified
(135 days)		S38.0.AnyAnyrows become less unexpectedly caused by on clause
1196962026-01-16
7:03		2026-01-16
8:58		MySQL Server: OptimizerVerified
(135 days)		S38.0.44AnyAnyfloat value Precision loss caused by removing distinct
1196952026-01-16
6:59		2026-01-16
8:48		MySQL Server: OptimizerVerified
(135 days)		S38.0.44AnyAnyThe appearance of rows that should not exist caused by on clause
1196942026-01-16
6:56		2026-01-16
8:39		MySQL Server: OptimizerVerified
(135 days)		S38.0.44AnyAnyrows unexpectedly become less after changing INNER to LEFT
1196932026-01-16
6:39		2026-01-16
8:28		MySQL Server: OptimizerVerified
(135 days)		S38.0.44AnyAnycolumn value change after changing INNER to LEFT
1196922026-01-16
5:23		2026-01-16
8:09		MySQL Server: OptimizerVerified
(135 days)		S18.0.44AnyAnyThe normal query generated a non-optimal query plan.
1196872026-01-15
10:23		2026-01-15
13:18		MySQL Server: OptimizerVerified
(136 days)		S18.0.44AnyAnyInconsistent behaviour between normal and prepared INSERT
1196862026-01-15
8:37		2026-01-15
13:11		MySQL Server: OptimizerVerified
(136 days)		S28.0.44Linuxx86Incorrect result when joined table has PRIMARY KEY and WHERE predicate involves CASE
1196832026-01-14
15:35		2026-01-15
12:57		MySQL Server: OptimizerVerified
(136 days)		S18.0.44Linuxx86Different results for INNER JOIN and STRAIGHT_JOIN with GREATEST() IN predicate
1196812026-01-14
14:19		2026-01-15
12:47		MySQL Server: OptimizerVerified
(136 days)		S39.5.0AnyAnyFloating-point precision loss occurs when changing avg(x) to -avg(-x)
1196802026-01-14
13:51		2026-01-15
12:25		MySQL Server: OptimizerVerified
(136 days)		S38.0.44AnyAnyafter changing AVG(cte.col_2) to -AVG(-cte.col_2) ,rows become less
1196792026-01-14
13:40		2026-01-15
11:25		MySQL Server: OptimizerVerified
(136 days)		S38.0.45AnyAnyafter changing SUM(t3.c9) to -SUM(-t3.c9),the rows become less
1196702026-01-13
13:46		2026-01-13
14:51		MySQL Server: OptimizerVerified
(138 days)		S18.0.44AnyAnyIncorrect result caused by index
1196692026-01-13
13:27		2026-01-13
14:53		MySQL Server: OptimizerVerified
(138 days)		S18.0.44AnyAnyInconsistent behaviour between normal query and prepared statement
1196662026-01-13
7:37		2026-01-13
8:16		MySQL Server: OptimizerVerified
(138 days)		S38.0.41AnyAnyYEAR column IN (1,2) does not match expected conversion behavior
1196632026-01-13
4:24		2026-01-13
7:46		MySQL Server: OptimizerVerified
(138 days)		S3 9.3.0UbuntuAnyQuery reports error when turn on optimizer_switch
1196382026-01-07
8:40		2026-01-07
9:59		MySQL Server: OptimizerVerified
(144 days)		S38.0.42AnyAnyIncorrect Condition Evaluation for BETWEEN with NULL Upper Bound
1196362026-01-07
7:55		2026-01-07
9:20		MySQL Server: OptimizerVerified
(144 days)		S38.0AnyAnyIncorrect Condition Evaluation for float unsigned zerofill Columns
1196352026-01-07
7:27		2026-01-07
11:07		MySQL Server: OptimizerVerified
(144 days)		S38.0.42+AnyAnyReturns incorrect query results when using the between keyword
1196212026-01-05
11:11		2026-02-24
12:06		MySQL Server: JSONVerified
(96 days)		S28.0.43 / 8.4.7AnyAnyquery on partitioned table report "the JSON binary value contains invalid data"
1196192026-01-04
14:07		2026-01-04
21:17		MySQL Server: OptimizerVerified
(147 days)		S18.0AnyAnyIncorrect results for REPLACE function
1196052025-12-29
9:37		2025-12-29
13:00		MySQL Server: OptimizerVerified
(153 days)		S38.0.27AnyAnyGROUP BY brings unnecessary order columns
1196032025-12-29
1:19		2026-01-04
20:40		MySQL Server: OptimizerVerified
(147 days)		S28.0AnyAnyTRUE >= ALL(...) returns incorrect result (1) when comparing against a NOT NULL column
1196012025-12-28
11:55		2026-02-08
13:32		MySQL Server: OptimizerVerified
(112 days)		S28.0.41CentOSAny (x86)Crash for show processlist when use cursor
1195992025-12-27
2:30		2025-12-29
4:51		MySQL Server: OptimizerVerified
(153 days)		S38.0.41AnyAnyUnder the same SQL, the results of hash join and nested loop join are inconsistent
1195972025-12-26
2:37		2025-12-26
17:57		MySQL Server: OptimizerVerified
(156 days)		S18.0.44AnyAnyWHERE ... IN ... incorrectly returns rows
1195962025-12-26
2:01		2025-12-29
4:55		MySQL Server: OptimizerVerified
(153 days)		S39.2,9.4AnyAnyInconsistent results use IFNULL with different query plan
1195942025-12-24
14:03		2025-12-26
6:21		MySQL Server: OptimizerVerified
(156 days)		S19.5.0AnyAnyINTERSECT (SELECT NULL) incorrectly returns non-NULL rows when column is PRIMARY KEY
1195912025-12-24
7:27		2025-12-26
17:48		MySQL Server: Data TypesVerified
(156 days)		S18.0.44AnyAnyIncorrect result type for NULLIF(DOUBLE,BIGINT) function
1195902025-12-24
6:41		2025-12-26
6:22		MySQL Server: OptimizerVerified
(156 days)		S19.5.0AnyAnyEXCEPT (SELECT NULL) returns incorrect result (missing row) on DECIMAL primary key column
1195882025-12-24
3:03		2025-12-26
17:23		MySQL Server: OptimizerVerified
(156 days)		S18.0.44AnyAnyIncorrect result in JOIN with IN subquery
1195862025-12-23
9:09		2025-12-26
16:50		MySQL Server: Data TypesVerified
(156 days)		S18.4.7AnyAnyInconsistent results for date conversion
1195842025-12-22
16:09		2025-12-22
19:42		MySQL Server: OptimizerVerified
(160 days)		S38.0.44 AnyAnyThe HAVING clause cannot recognize alias columns defined by Boolean expressions in derived tables
1195832025-12-22
7:34		2025-12-22
19:35		MySQL Server: OptimizerVerified
(160 days)		S38.0.44AnyAnyCreate index can lead to incorrect results
1195822025-12-22
6:49		2025-12-22
19:27		MySQL Server: OptimizerVerified
(160 days)		S28.0.44AnyAnyInconsistency functional dependency in ONLY_FULL_GROUP_BY mode between derived tables and physical tables
1195812025-12-20
14:54		2025-12-22
19:17		MySQL Server: OptimizerVerified
(160 days)		S38.0.33Ubuntu (22.04)AnyFLOOR function shows inconsistent overflow handling
1195652025-12-17
1:06		2026-02-05
15:32		MySQL Server: OptimizerVerified
(115 days)		S38.0.41AnyAnyTemporary table causes incorrect conversion from TIME to JSON type
1195412025-12-11
12:32		2025-12-12
8:19		MySQL Server: OptimizerVerified
(170 days)		S28.0, 8.4, 9.5AnyAnyPerformance regression due to record buffer in index range scan
1195382025-12-11
1:54		2025-12-12
5:12		MySQL Server: OptimizerVerified
(170 days)		S38.0.41AnyAnydifferent values set for sql_buffer_result and materialization lead to different query results.
1195312025-12-09
14:40		2025-12-15
14:58		MySQL Server: OptimizerVerified
(167 days)		S58.4.6AnyAnyOptimizer should use a short-circuit DESC scan for SELECT MAX(PK) WHERE ...
1195302025-12-09
12:38		2025-12-11
9:31		MySQL Server: OptimizerVerified
(171 days)		S18.4.7AnyAnyIncorrect results for NULLIF functions
1195282025-12-09
9:49		2025-12-10
12:38		MySQL Server: OptimizerVerified
(172 days)		S28.0AnyAnyhash join result incorrect
1195202025-12-06
17:55		2025-12-08
3:51		MySQL Server: OptimizerVerified
(174 days)		S29.5.0Ubuntu (22.04)AnyInconsistent NULL and Negative Zero Handling in EXISTS Subquery with HAVING Clause
1194912025-12-02
8:21		2025-12-08
21:10		MySQL Server: OptimizerVerified
(174 days)		S18.4.7AnyAnyIncorrect results for make_set operation against longtext column
1194882025-12-01
14:52		2025-12-02
4:37		MySQL Server: OptimizerVerified
(180 days)		S29.4.0, 9.5.0Ubuntu (22.04)AnyNTERSECT Bug: NULL-Handling Inconsistency Returns Non-Intersecting Row from Outer Joins with NULL Comparisons
1194872025-12-01
14:45		2026-02-05
19:41		MySQL Server: OptimizerVerified
(115 days)		S28.0.45Ubuntu (22.04)AnyJOIN, STRAIGHT_JOON Return Different Results
1194852025-12-01
14:10		2025-12-02
5:32		MySQL Server: OptimizerVerified
(180 days)		S29.5.0,8.0.41AnyAnyWrong result with left joins
1194742025-11-29
9:29		2025-12-01
4:16		MySQL Server: OptimizerVerified
(181 days)		S28.0.41AnyAnyResult error caused by the subquery_to_derived optimizer switch
1194702025-11-27
14:30		2025-11-28
13:06		MySQL Server: OptimizerVerified
(184 days)		S18.0.44+AnyAnysql injection
1194632025-11-26
6:23		2026-02-05
20:07		MySQL Server: CharsetsVerified
(115 days)		S29.5.0AnyAnysome charactor may be truncated use utf8mb4_general_ci collation_connection
1194562025-11-25
6:52		2025-11-28
14:55		MySQL Server: OptimizerVerified
(184 days)		S38.0.44, 8.4.7, 9.5AnyAnyQuery block name uses mixed decimal/hexadecimal in optimizer trace and hint
1194542025-11-24
16:04		2025-11-27
5:11		MySQL Server: OptimizerVerified
(185 days)		S29.4.0AnyAnyHash join has wrong result when the join equality involves FLOAT or DECIMAL column
1194532025-11-24
14:12		2025-12-07
22:36		MySQL Server: OptimizerVerified
(175 days)		S28.0AnyAnyDEFAULT(column) returns wrong result when column is to the right of left join
1194472025-11-23
8:34		2025-11-27
5:04		MySQL Server: OptimizerVerified
(185 days)		S58.0.41CentOSx86Prepare Statement execute much slower than normal select query
1194462025-11-23
6:46		2025-11-27
4:57		MySQL Server: OptimizerVerified
(185 days)		S39.4.0AnyAnyrows become more after changing COUNT to COUNT(DISTINCT)
1194332025-11-20
9:30		2025-12-07
21:58		MySQL Server: Data TypesVerified
(175 days)		S18.4.6AnyAnyInconsistent date conversion behaviors between text and integer
1194322025-11-20
8:47		2025-12-07
21:44		MySQL Server: Data TypesVerified
(175 days)		S18.0AnyAnyInconsistent time conversion behaviors between text and integer
1194162025-11-18
6:11		2025-12-07
21:23		MySQL Server: OptimizerVerified
(175 days)		S39.4.0AnyAnyIncorrect in Subquery on MEMORY Engine
1194152025-11-18
6:07		2025-12-07
21:17		MySQL Server: OptimizerVerified
(175 days)		S39.4.0AnyAny Incorrect IN Subquery on ARCHIVE Engine
1194132025-11-17
23:52		2025-12-07
21:06		MySQL Server: OptimizerVerified
(175 days)		S3mysql Ver 9.4.AnyAnyIntersection order
1194032025-11-15
9:38		2025-12-07
20:55		MySQL Server: OptimizerVerified
(175 days)		S39.4.0AnyAnyINTERSECT operation incorrectly gets rows with NULL and non-NULL combination
1194022025-11-15
8:39		2025-12-07
20:50		MySQL Server: OptimizerVerified
(175 days)		S39.4.0AnyAnyEXCEPT operation incorrectly removes rows with NULL and non-NULL combination when subtracting sets with NULL values
1194002025-11-15
7:20		2025-12-07
20:08		MySQL Server: OptimizerVerified
(175 days)		S38.0AnyAnyrows become less after changing join clause
1193992025-11-15
7:00		2025-12-07
19:31		MySQL Server: OptimizerVerified
(175 days)		S39.4.0AnyAnyColumn name change after adding DISTINCT
1193982025-11-15
6:56		2025-12-07
19:21		MySQL Server: OptimizerVerified
(175 days)		S39.4.0AnyAnyrows become less after removing Except clause
1193912025-11-14
7:19		2025-11-27
7:19		MySQL Server: CompilingOpenS39.5.0Linux (mysqld --no-defaults --help failed)x86/mysql-9.5.0/cmake/info_bin.cmake:37 (CREATE_INFO_BIN)
1193862025-11-13
11:44		2026-01-15
12:35		MySQL Server: OptimizerVerified
(136 days)		S19.4.0AnyAnyunexpected error "Can't write; duplicate key in table '/tmp/#sql1_372_1'"
1193852025-11-13
9:41		2025-12-06
22:51		MySQL Server: OptimizerVerified
(176 days)		S38.0.41AnyAnyAfter replacing the expressions inside BETWEEN ... AND with constants, the results become inconsistent.
1193812025-11-13
8:14		2026-01-13
19:17		MySQL Server: DMLVerified
(138 days)		S28.0.43, 9.4.0AnyAnyContribution by Tencent: Duplicate auto-increment values happened with partitioned tables and uk conflict
1193702025-11-12
10:07		2025-12-06
22:40		MySQL Server: OptimizerVerified
(176 days)		S39.4.0 8.4.6AnyAnyFLOAT Value Returned by CASE Statement Evaluates Incorrectly in Bitwise Operation
1193652025-11-12
3:14		2025-12-06
22:25		MySQL Server: OptimizerVerified
(176 days)		S39.4.0 8.4.6AnyAnyIncorrect NOT IN Evaluation for NULL on Indexed TEXT Column
1193642025-11-12
3:01		2025-12-06
22:14		MySQL Server: OptimizerVerified
(176 days)		S39.4.0 8.4.6AnyAnyIncorrect Evaluation of = ANY Subquery with NULL on Indexed DECIMAL Column
1193632025-11-12
2:52		2025-11-12
3:10		MySQL Server: OptimizerVerified
(200 days)		S39.4.0 8.4.6AnyAnyComplex WHERE Expression on Indexed FLOAT Column Evaluates Incorrectly
1193602025-11-11
8:42		2026-02-08
14:00		MySQL Server: OptimizerVerified
(112 days)		S38.0.41AnyAnyResult inconsistency due to sorting in temporary tables
1193562025-11-10
16:20		2025-12-06
22:04		MySQL Server: CharsetsVerified
(176 days)		S3AnyAnyContribution: Fix NUL characters in FORMAT() output
1193552025-11-10
16:15		2025-12-06
22:02		MySQL Server: OptimizerVerified
(176 days)		S39.4.0 8.4.6AnyAnyBETWEEN ... AND NULL evaluates incorrectly with bitwise shift
1193542025-11-10
15:51		2025-12-06
21:52		MySQL Server: OptimizerVerified
(176 days)		S39.4.0 8.4.6AnyAnyIN subquery evaluates incorrectly when using IFNULL and CAST AS DATETIME
1193532025-11-10
14:30		2026-02-05
20:53		MySQL Server: OptimizerVerified
(115 days)		S39.4.0AnyAnyColumn Value change after removing DISTINCT in query
1193522025-11-10
13:11		2026-02-05
21:02		MySQL Server: OptimizerVerified
(115 days)		S38.0.45AnyAnyrow number become less after changing where clause
1193512025-11-10
13:00		2026-02-05
21:15		MySQL Server: OptimizerVerified
(115 days)		S38.0.45AnyAnyIndex caused different result
1193502025-11-10
12:14		2025-11-20
13:15		MySQL Server: OptimizerVerified
(192 days)		S38.0AnyAnyColumn name change after changing having clause
1193492025-11-10
12:06		2025-11-20
13:05		MySQL Server: OptimizerVerified
(192 days)		S39.4.0AnyAny Incorrect String Comparison with MyISAM BIT Column in IN Subquery
1193482025-11-10
11:01		2025-11-20
12:58		MySQL Server: OptimizerVerified
(192 days)		S38.0AnyAnyIncorrect row number after changing having clause
1193472025-11-10
10:43		2025-11-20
12:48		MySQL Server: OptimizerVerified
(192 days)		S38.0AnyAnyIN predicate incorrectly evaluates RADIANS() and TINYINT with key
1193462025-11-10
9:43		2025-11-20
12:40		MySQL Server: OptimizerVerified
(192 days)		S38.0AnyAnyCASE expression evaluates incorrectly
1193452025-11-10
9:21		2025-11-20
11:33		MySQL Server: OptimizerVerified
(192 days)		S38.0AnyAnyPresence of UNIQUE index on INT column causes inconsistent results for IF with ANY subquery
1193442025-11-10
8:47		2025-11-12
3:04		MySQL Server: OptimizerVerified
(200 days)		S39.4.0AnyAnyFloating-point precision loss happen after changing UNION to UNION ALL
1193422025-11-10
8:26		2025-11-11
8:10		MySQL Server: OptimizerVerified
(201 days)		S39.4.0AnyAnyBits value change after changing UNION to UNION ALL
1193412025-11-10
8:24		2025-11-11
7:56		MySQL Server: OptimizerVerified
(201 days)		S39.4.0AnyAnyALL subquery evaluates incorrectly in SELECT list when comparing against a BIT column
1193392025-11-08
17:27		2025-11-11
7:31		MySQL Server: OptimizerVerified
(201 days)		S38.0.41AnyAnyThe results are different after extracting the value of the COALESCE function
1193292025-11-07
8:13		2025-11-11
14:02		MySQL Server: OptimizerVerified
(205 days)		S38.0.44AnyAnyColumn name unexpectedly change after changing COUNT to COUNT(DISTINCT)
1193272025-11-07
7:52		2026-02-05
21:26		MySQL Server: OptimizerVerified
(115 days)		S38.0.45AnyAnyafter adding an index ,the result return different
1193262025-11-07
7:40		2025-11-07
9:07		MySQL Server: OptimizerVerified
(205 days)		S38.0.41AnyAnyUsing the COALESCE function, two opposite conditions return the same result.
1193232025-11-07
5:59		2025-11-07
7:26		MySQL Server: OptimizerVerified
(205 days)		S39.4.0AnyAnyrow number become less after changing COUNT(DISTINCT) to COUNT
1193222025-11-07
4:58		2025-11-07
7:29		MySQL Server: OptimizerVerified
(205 days)		S39.4.0AnyAnyUnexpected None after adding a window column
1193212025-11-07
4:35		2025-11-07
7:37		MySQL Server: OptimizerVerified
(205 days)		S39.4.0AnyAnyUnexpected None after changing SUM to SUM (x*2)
1193132025-11-06
3:03		2025-12-06
21:22		MySQL Server: OptimizerVerified
(176 days)		S38.0.41AnyAnyBETWEEN clause returns incorrect results when comparing numeric literal with DATETIME columns
1193062025-11-05
7:02		2025-11-06
5:34		MySQL Server: OptimizerVerified
(206 days)		S38.0, 9.5AnyAnyThe EXPLAIN plan may be inconsistent with the actual execution.
1193052025-11-05
4:02		2025-12-16
13:55		MySQL Server: OptimizerVerified
(166 days)		S38.0.41Linuxx86The query results of enabling and disabling materialization are inconsistent.
1193032025-11-05
1:49		2025-11-05
5:00		MySQL Server: DMLVerified
(207 days)		S38.0.41AnyAnyThe query is normal without using the histogram, but an error occurs when using the histogram
1192872025-11-01
10:08		2025-11-04
21:01		MySQL Server: OptimizerVerified
(208 days)		S38.0.41AnyAnyDecimal Precision Mismatch in UNION Query with CONCAT Function
1192622025-10-29
9:01		2025-11-04
23:01		MySQL Server: OptimizerVerified
(208 days)		S38.0.44,8.4.6,9.4.0AnyAnyIncorrect result on comparison between a float expression and an indexed SMALLINT column.
1192462025-10-27
15:02		2026-04-13
14:33		MySQL Server: CompilingOpen
(48 days)		S38.4.8, 9.7.0-er2MacOS (26.0.1)ARM9.7.0-er2 compilation error with LLVM 21
1192422025-10-27
12:13		2025-10-27
12:35		MySQL Server: CompilingOpen
(216 days)		S38.4.7MacOS (26.0.1)ARM8.4.7 fails to build with clang 21
1192392025-10-27
7:53		2026-01-23
10:19		MySQL Server: CompilingOpen
(128 days)		S38.0.45, 8.4.8MacOS (26.0.1)ARMCompilation error with clang 21
1192382025-10-27
7:31		2026-01-23
7:48		MySQL Server: CompilingOpen
(128 days)		S38.0.45MacOS (26.0.1)ARMCompilation error with clang 20
1192252025-10-24
9:11		2025-10-31
5:22		MySQL Server: OptimizerVerified
(212 days)		S38.0.43AnyAnyweedout not work for rematerialized temptable
1192202025-10-23
14:55		2025-11-07
9:22		MySQL Server: OptimizerVerified
(205 days)		S28.4.6Anyx86Subquery materialization in LEFT JOIN ON clause loses WHERE conditions
1192042025-10-22
8:10		2025-10-23
10:04		MySQL Server: DMLVerified
(220 days)		S28.0,9.5AnyAnyThe change of join order may lead to inconsistent update data
1192032025-10-21
12:46		2025-11-04
23:25		MySQL Server: OptimizerVerified
(208 days)		S38.0.41AnyAnyAn expression that returns NULL instead of NULL is used to perform the <=> operation. the sql retrun wrong result.
1191722025-10-16
10:00		2026-01-15
10:04		MySQL Server: OptimizerVerified
(136 days)		S39.4.0 8.4.6AnyAny Inconsistent Result for NOT BETWEEN When Date Interval Arithmetic Produces NULLs
1191712025-10-16
9:34		2026-01-15
9:37		MySQL Server: Data TypesVerified
(136 days)		S39.4.0 8.4.6AnyAnyInconsistent Result for BETWEEN NULL AND NULL on a DECIMAL Column
1191682025-10-16
8:47		2026-01-14
14:52		MySQL Server: OptimizerVerified
(137 days)		S39.4.0AnyAnyInconsistent results for CHAR IN (subquery returning BIT)
1191602025-10-15
9:32		2026-01-13
11:27		MySQL Server: OptimizerVerified
(138 days)		S38.0.41AnyAnyFound different values set for sql_buffer_result and materialization lead to different query results.
1191562025-10-15
2:01		2026-01-13
11:13		MySQL Server: OptimizerVerified
(138 days)		S28.0.41CentOSx86Query returns incorrect result (12 vs 2) when using FORCE INDEX compared to optimizer's automatic index selection, when
1191542025-10-14
13:24		2026-01-13
10:22		MySQL Server: Data TypesVerified
(138 days)		S18.4.6AnyAnyIncorrect BIT_COUNT value for TEXT column
1191472025-10-13
13:39		2026-01-13
10:02		MySQL Server: OptimizerVerified
(138 days)		S38.0AnyAny>= SOME Operator Returns Incorrect Empty Set for TIMESTAMP Comparison
1191462025-10-13
12:53		2026-01-13
9:48		MySQL Server: OptimizerVerified
(138 days)		S39.4.0 8.4.6AnyAnyWHERE IN with Subquery Incorrectly Matches VARCHAR to DECIMAL via Implicit Casting
1191442025-10-13
12:49		2026-01-06
12:48		MySQL Server: OptimizerVerified
(145 days)		S28.4.6WindowsAny (x64)INNER JOIN and STRAIGHT_JOIN return different results with identical ABS function conditions
1191432025-10-13
12:37		2026-01-06
12:44		MySQL Server: OptimizerVerified
(145 days)		S38.4.6AnyAny INNER JOIN and STRAIGHT_JOIN return different results with ATAN function
1191412025-10-13
8:21		2026-01-06
11:28		MySQL Server: DMLVerified
(145 days)		S38.0.41Linuxx86The results returned by the prepare query are different from those returned by the non-prepare query.
1191402025-10-13
8:01		2026-01-06
14:56		MySQL Server: OptimizerVerified
(145 days)		S18.4AnyAnyDISTINCT works inconsistently in normal SELECT and prepared statement for 0 and -0
1191392025-10-13
7:30		2025-12-18
8:56		MySQL Server: OptimizerVerified
(164 days)		S19.4.0AnyAnyUnexpected error `Incorrect DECIMAL value: '0' for column '' at row -1`
1191382025-10-13
3:45		2026-01-06
14:41		MySQL Server: OptimizerVerified
(145 days)		S38.0AnyAnyIncorrect result with BINARY EXISTS(...) IN (...) on TIMESTAMP column
1191372025-10-13
3:23		2026-01-06
14:32		MySQL Server: OptimizerVerified
(145 days)		S38.0AnyAnyIncorrect result for ADDTIME expression
1191322025-10-11
3:44		2025-12-18
8:37		MySQL Server: DMLVerified
(164 days)		S38.0.41AnyAnyUnexpected query result when using complex boolean expressions with UNION ALL and LIKE in SELECT query
1191302025-10-11
2:30		2025-12-17
9:33		MySQL Server: OptimizerVerified
(165 days)		S38.0.41AnyAnyDifferent values set for sql_buffer_result and materialization lead to different query results.
1191272025-10-10
11:58		2025-12-17
8:20		MySQL Server: OptimizerVerified
(165 days)		S28.4.6AnyAnyINNER JOIN and INTERSECT of LEFT/RIGHT JOINs return different results when unique index is present
1191252025-10-10
3:52		2025-12-17
8:10		MySQL Server: OptimizerVerified
(165 days)		S38.0.41AnyAnyafter modifying the insertion sequence of the table,the results of the same query are inconsistent.
1191242025-10-10
3:28		2025-12-16
9:19		MySQL Server: DMLVerified
(166 days)		S38.0.41AnyAnyThe result of the COALESCE function varies depending on its different parameters.
1191222025-10-09
11:53		2025-12-16
9:14		MySQL Server: DMLVerified
(166 days)		S38.0.41AnyAnyThe query is normal without using the histogram, but an error occurs when using the histogram
1191182025-10-09
8:17		2025-12-15
12:50		MySQL Server: OptimizerVerified
(167 days)		S38.0.41AnyAnyThe difference in results caused by enabling or disabling the optimizer's index_merge_union.
1190972025-09-30
9:04		2025-12-15
11:15		MySQL Server: OptimizerVerified
(167 days)		S2MySQL 8.4.6WindowsOther (x64)STRAIGHT_JOIN returns different results compared to INNER JOIN with identical conditions
1190942025-09-29
13:03		2025-12-12
13:38		MySQL Server: OptimizerVerified
(170 days)		S3AnyAnyPerformance optimization patches
1190872025-09-28
5:54		2025-12-12
9:33		MySQL Server: OptimizerVerified
(170 days)		S39.4.0 8.4.6AnyAnyIncorrect result for subquery with BIGINT UNSIGNED
1190812025-09-27
8:35		2025-10-02
7:12		MySQL Server: OptimizerVerified
(244 days)		S38.0.43AnyAnyUPDATE with CASE/IFNULL expression produces unexpected error: Incorrect DECIMAL value: '0' for column '' at row -1
1190802025-09-27
8:16		2025-10-01
13:58		MySQL Server: OptimizerVerified
(244 days)		S38.0.43AnyAnySELECT vs. TLP partitioning query returns different cardinalities (cardinality mismatch)
1190682025-09-25
8:43		2025-10-01
14:05		MySQL Server: OptimizerVerified
(244 days)		S2 9.4.0 Linuxx86RIGHT JOIN on VIEW with IN subquery returns incorrect non-NULL value instead of NULL
1190662025-09-24
13:06		2025-10-03
11:03		MySQL Server: OptimizerVerified
(244 days)		S58.0.40+AnyAnyMySQL 8.0.40+ is about 2-3x times slower than 8.0.39 in particular index scan scenario
1190622025-09-23
11:08		2025-09-25
16:09		MySQL Server: OptimizerVerified
(250 days)		S59.4.0AnyAnyA missed optimization opportunity of "FALSE and any_expr" in WHERE clause
1190592025-09-23
3:44		2025-09-25
16:07		MySQL Server: OptimizerVerified
(250 days)		S29.2.0, 9.4.0AnyAnyInconsistent result behavior when using EXCEPT equivalent NATRUAL JOIN
1190582025-09-23
0:57		2025-09-25
16:08		MySQL Server: Prepared statementsVerified
(250 days)		S19.4.0AnyAny`\` is inconsistent in prepared statement and normal query
1190562025-09-22
15:21		2025-09-23
2:40		MySQL Server: OptimizerVerified
(250 days)		S39.4.0AnyAnycolumn value change cased by SUM(DISTINCT) changed to AVG(DISTINCT)*COUNT(DISTINCT)
1190532025-09-22
9:22		2025-09-23
2:40		MySQL Server: OptimizerVerified
(250 days)		S39.4.0 8.4.6AnyAnyIncorrect filtering for NOT BETWEEN on a FLOAT PRIMARY KEY
1190522025-09-22
9:22		2025-09-23
2:43		MySQL Server: OptimizerVerified
(250 days)		S58.0.43Linux (5.10.134-19.al8.x86_64)x86 (x86_64)Performance regression in 8.0.40
1190482025-09-21
12:57		2025-09-23
1:27		MySQL Server: Prepared statementsVerified
(251 days)		S29.4.0AnyAnyinconsistent result of two equivalent query with operator ~
1190412025-09-19
8:19		2025-09-23
9:57		MySQL Server: OptimizerVerified
(250 days)		S28.0.25 8.0.40AnyAnystatistics automatic update cause poor execution plan
1190402025-09-19
6:46		2025-09-23
1:39		MySQL Server: OptimizerVerified
(254 days)		S38.0.41Linuxx86The execution performance of the default execution plan is poor. If ignore index is used, the query performance is great
1190352025-09-18
10:11		2025-09-23
0:48		MySQL Server: OptimizerVerified
(251 days)		S39.4.0 8.4.6AnyAnyIncorrect result for BETWEEN with mixed types on a BINARY column with a UNIQUE key
1190342025-09-18
9:34		2025-09-23
0:50		MySQL Server: OptimizerVerified
(251 days)		S39.4.0 8.4.6AnyAnyIncorrect result when comparing a numeric string literal to a BIT column with a UNIQUE key
1190332025-09-18
9:16		2025-09-23
0:51		MySQL Server: OptimizerVerified
(251 days)		S39.4.0 8.4.6AnyAnyIncorrect filtering when comparing a BINARY-cast integer to a BIT column with a UNIQUE key
1190322025-09-18
7:52		2025-09-23
0:51		MySQL Server: OptimizerVerified
(251 days)		S29.2.0AnyAnyInconsistency with MySQL 8.0.36 in MySQL 9.2.0: Equivalent INTERSECT query does not match INNER JOIN result and returns
1190292025-09-18
0:40		2025-09-22
14:34		MySQL Server: OptimizerVerified
(254 days)		S59.4.0AnyAnyTwo missed optimization opportunities of "TRUE OR any_expr"
1190282025-09-18
0:20		2025-09-22
14:33		MySQL Server: OptimizerVerified
(254 days)		S59.4.0AnyAnytwo missed optimization oppotunities of "FALSE and any_expr"
1190222025-09-17
12:40		2025-09-23
0:51		MySQL Server: OptimizerVerified
(251 days)		S29.4.0AnyAnycolumn value change cased by Union ALL
1189812025-09-10
3:41		2025-09-22
14:32		MySQL Server: DMLVerified
(254 days)		S38.0.41AnyAnyadding DEFAULT FUNCTION in the where clause, the query returns a wrong result caused by the cached value.
1189802025-09-10
2:52		2025-09-15
16:00		MySQL Server: OptimizerVerified
(262 days)		S2MySQL8.0.41 AnyAnyqueries have different results using and without index
1189492025-09-05
13:57		2025-09-10
0:42		MySQL Server: OptimizerVerified
(265 days)		S29.2.0Linux (ubuntu 20.04)AnyMySQL 9.2.0: Complex CASE in JOIN makes INNER vs INTERSECT yield different rows
1189412025-09-05
8:19		2025-09-10
14:45		MySQL Server: OptimizerVerified
(263 days)		S28.0.x, 8.4.xAnyAnyBug Report: DECIMAL(22,2) Column Comparison with -0.001 Excludes 0.00 Row
1189372025-09-04
4:36		2025-09-10
0:43		MySQL Server: OptimizerVerified
(264 days)		S2 9.4.0 AnyAny LEFT JOIN with constant functions returns incorrect results when condition is ON FALSE
1189132025-08-29
3:40		2025-09-01
10:19		MySQL Server: OptimizerVerified
(272 days)		S28.0.41, 9.4.0AnyAnyqueries have different results for non primary key table and table with primary key
1189122025-08-28
16:24		2025-09-04
11:48		MySQL Server: OptimizerVerified
(272 days)		S18 and above, 8.0.42, 8.4.5, 9.3.0AnyAnyMismatch in Column values with SUM of IFNULL vs IFNULL of SUM
1189092025-08-28
11:04		2025-09-04
11:49		MySQL Server: OptimizerVerified
(270 days)		S38.0.41, 9.4.0 Linuxx86Inconsistent evaluation of WHERE predicate between table-scan and covering-index paths; result set changes with projecti
1189042025-08-28
3:20		2025-09-04
11:46		MySQL Server: OptimizerVerified
(272 days)		S28.0.41+AnyAnyIncorrect results could be returned when using index condition pushdown and Range checked for each record
1188932025-08-26
8:31		2025-09-04
11:53		MySQL Server: OptimizerVerified
(272 days)		S39.4.0-1.el9LinuxAny"SELECT AUTO_INCREMENT FROM information_schema.TABLES" reports a value that is reduced by one
1188872025-08-25
2:49		2025-08-29
11:06		MySQL Server: OptimizerVerified
(279 days)		S39.4.0CentOSAnyZero '0000-00-00 00:00:00' datetime returned when SQL_BUFFER_RESULT is used
1188752025-08-21
12:42		2025-08-21
13:16		MySQL Server: DMLVerified
(283 days)		S38.0.41, 8.0.43AnyAnyset optimizer_switch='block_nested_loop=off/on', result is different.
1188712025-08-21
2:37		2025-08-29
11:12		MySQL Server: OptimizerVerified
(279 days)		S38.0.43 MySQL Community Server - GPLLinux (Linux (Rocky Linux release 8.8 (Green Obsidian)))AnyConstant conditions in SQL with derived views are not passed.new
1188632025-08-20
14:23		2025-08-21
6:30		MySQL Server: OptimizerVerified
(283 days)		S28.4.x, 8.4.6AnyAnyComplex collection query incorrectly missing '0'
1188622025-08-20
14:05		2025-08-21
6:28		MySQL Server: OptimizerVerified
(283 days)		S38.0.x, 8.4.x, 8.0.43AnyAnyMySQL Returns Incorrect Results for Complex Query with Set Operations
1188582025-08-20
8:51		2025-09-23
4:03		MySQL Server: OptimizerVerified
(250 days)		S29.2.0LinuxAnyInconsistency between the results returned by MySQL and other vendors' database systems was found during differentiation
1188572025-08-20
8:39		2025-08-20
10:19		MySQL Server: OptimizerVerified
(284 days)		S29.2.0LinuxAnyBug Summary: MySQL Returns Incorrect Results for Complex Query with Set Operations
1188492025-08-18
12:14		2025-08-18
23:50		MySQL Server: OptimizerVerified
(286 days)		S38.0.41AnyAnyafter add HINT:JOIN_ORDER, the result is wrong.
1188462025-08-15
8:50		2025-08-19
7:34		MySQL Server: OptimizerVerified
(285 days)		S39.3.0UbuntuAnycolumn name change cased by where
1188392025-08-14
3:13		2025-08-18
23:50		MySQL Server: DMLVerified
(286 days)		S38.0.41AnyAnya query including the having subclause that returns NULL, return a wrong nonempty result.
1188372025-08-14
3:05		2025-08-18
23:51		MySQL Server: OptimizerVerified
(286 days)		S38.0.41AnyAnyAfter having(col) in the query statement is changed to having min(col), the returned result is incorrect.
1188362025-08-14
3:01		2025-08-18
23:56		MySQL Server: OptimizerVerified
(286 days)		S38.0.41AnyAnyadding a having clause that return 1/TRUE, the query returns a different and wrong empty result.
1188352025-08-14
2:56		2025-08-19
0:17		MySQL Server: OptimizerVerified
(285 days)		S38.0.41AnyAnyA query statement that returns 0/FALSE in the having clause, the returned result is not null.
1188332025-08-14
2:43		2025-08-19
0:36		MySQL Server: OptimizerVerified
(285 days)		S38.0.41AnyAnyTwo queries that use the where clause with opposite semantics return the same result.
1188322025-08-14
2:39		2025-08-19
7:34		MySQL Server: OptimizerVerified
(285 days)		S38.0.41, 9.4.0AnyAnyusing the return value replacing the IFNUILL function , the query returns different value;
1188312025-08-14
2:33		2025-08-19
10:51		MySQL Server: OptimizerVerified
(285 days)		S38.0.41, 9.4.0AnyAny !(expression1 or expression2) return a different result from !(expression1), while expression2 is 0.
1188302025-08-14
2:26		2025-08-19
10:51		MySQL Server: DMLVerified
(285 days)		S38.0.41, 9.4.0AnyAnyAfter a constant value is replaced by a LEAST function returnning the same value, the sql returns different result;
1188112025-08-11
3:31		2025-08-11
12:02		MySQL Server: OptimizerVerified
(293 days)		S38.0.43Linuxx86When hints are added, different execution plans are used for query. The query result are different.
1188102025-08-11
3:19		2025-08-11
10:35		MySQL Server: OptimizerVerified
(293 days)		S38.0.41, 8.0.43, 8.4.6Linuxx86he query result are inconsistent，when select difference indexes
1188082025-08-10
11:26		2025-08-11
7:00		MySQL Server: OptimizerVerified
(293 days)		S29.4.0, 8.4.3, 8.4.6AnyAnyDifferent result with range scan and table scan in sql with subquery
1188062025-08-09
13:00		2025-08-11
5:39		MySQL Server: OptimizerVerified
(293 days)		S38.0,9.0, 8.0.43, 8.4.6, 9.4.0Ubuntux86NULLIF with VARCHAR omits rows unexpectedly
1187882025-08-06
9:33		2025-08-21
8:59		MySQL Server: OptimizerVerified
(298 days)		S38.0.41, 8.0.43Linuxx86When two tables are joined, the execution results are different in different join order.
1187652025-08-01
2:56		2025-08-01
5:26		MySQL Server: DMLVerified
(303 days)		S38.0, 9.0, 8.4.6, 8.0.43AnyAnySubstring_index with negative index returns inconsistent results across different character sets
1187292025-07-28
13:17		2025-07-29
6:37		MySQL Server: OptimizerVerified
(306 days)		S38.4.4 (Any), 8.0.43, 8.4.6, 9.4.0AnyAnySelect Query is showing wrong column name alias from sub-query
1187102025-07-23
12:08		2025-07-23
12:42		MySQL Server: OptimizerVerified
(312 days)		S18.0.36, 8.0.42, 8.0.43, 8.4.6WindowsAnyOptimizer incorrectly simplifies negative float/decimal comparison in JOIN condition, leading to wrong results
1186942025-07-22
7:03		2025-07-22
11:45		MySQL Server: DMLVerified
(313 days)		S38.0.41 5.7, 8.0.42AnyAnyItem_func_between deal with decimel different from other methods
1186842025-07-18
14:54		2025-07-21
6:07		MySQL Server: OptimizerVerified
(314 days)		S29.2.0, 8.0.42, 8.4.5LinuxAnyInconsistent rows are returned
1186822025-07-18
3:52		2025-10-10
7:41		MySQL Server: OptimizerVerified
(311 days)		S28.0, 8.0.42AnyAnyconnection_memory_limit and global_connection_memory_limit don't work
1186692025-07-16
5:22		2025-07-16
6:46		MySQL Server: OptimizerVerified
(319 days)		S18 and above, 8.0.42, 8.4.5, 9.3.0AnyAnyIssue in applying limit on aggregated data
1186212025-07-09
12:39		2025-07-09
14:19		MySQL Server: OptimizerVerified
(326 days)		S39.3.0, 8.0.42AnyAnysubquery_to_derived optimizer makes query produce incorrect result
1185852025-07-03
16:35		2025-07-04
6:42		MySQL Server: OptimizerVerified
(331 days)		S58.0.39, 8.0.42, 8.4.5, 9.3.0Ubuntu (Ubuntu 20.04.2)Anysystem variable "range_alloc_block_size" arouse different execution plan
1185702025-07-02
2:29		2025-07-03
9:32		MySQL Server: DMLVerified
(333 days)		S58.0.42Linux (22.04)x86Performance regression occurs with INSERT statements after c17d86b
1185562025-06-29
19:07		2025-06-30
8:14		MySQL Server: DMLVerified
(335 days)		S39.3.0Ubuntux86Queries on tables with same data return different results
1185552025-06-29
18:55		2025-06-30
8:09		MySQL Server: DMLVerified
(335 days)		S39.3.0Ubuntux86Inconsistant results in tables containing NULL values
1185542025-06-29
18:42		2025-06-30
8:05		MySQL Server: DMLVerified
(335 days)		S39.3.0Ubuntux86Inconsistent results on same tables with different PRIMARY KEY constraint
1185532025-06-29
18:26		2025-06-30
8:03		MySQL Server: DMLVerified
(335 days)		S39.3.0Ubuntux86SELECT returns different results on tables with same data
1185522025-06-29
18:14		2025-06-30
8:00		MySQL Server: DMLVerified
(335 days)		S39.3.0Ubuntux86Inconsistant result on tables with same data but different constraints
1185512025-06-29
17:59		2025-06-30
7:42		MySQL Server: DMLVerified
(335 days)		S39.3.0Ubuntux86Inconsistant result after removing constraints on table
1185442025-06-27
14:18		2025-09-23
4:03		MySQL Server: OptimizerVerified
(250 days)		S29.2.0 , 9.3.0LinuxAnyA potential join operator bug
1185412025-06-27
8:31		2025-09-23
4:02		MySQL Server: OptimizerVerified
(250 days)		S29.2.0 , 8.0.42LinuxAnyInconsistent Results Between NATURAL JOIN and its Equivalent Form Using EXCEPT ALL with Implicit Type Casting
1185402025-06-27
7:27		2025-09-23
4:02		MySQL Server: OptimizerVerified
(250 days)		S29.2.0 , 8.0.42LinuxAnyInconsistent results between NATURAL JOIN and INNER JOIN simulated via LEFT JOIN, RIGHT JOIN, and EXCEPT ALL with NULL v
1184952025-06-20
7:40		2025-06-20
10:32		MySQL Server: DMLVerified
(345 days)		S38.0.41Linuxx86The query returned wrong result with l"imit offset"
1184752025-06-18
7:58		2025-06-18
8:40		MySQL Server: DMLVerified
(347 days)		S38.0.41, 8.4.5AnyAnyWhen the IF function is invoked to replace the specified column name, the returned results are inconsistent.
1184642025-06-17
7:24		2026-02-05
22:02		MySQL Server: OptimizerVerified
(115 days)		S38.0.41AnyAnyInserting into a float value exceeding the precision, using IF function and using the column return different result.
1184012025-06-09
13:37		2025-06-10
6:32		MySQL Server: DMLVerified
(356 days)		S38.0.41Linuxx86When innodb_buffer_pool_size is set a small value , the update value is abnormal.
1184002025-06-09
13:34		2025-07-24
12:28		MySQL Server: DMLVerified
(356 days)		S38.0.41Linuxx86ERROR 3854 (HY000): Cannot convert string '\xF0\x9F\x98\xA6\xF0\x9F...' from utf8mb4 to latin1
1183992025-06-09
12:35		2025-06-09
12:46		MySQL Server: DMLVerified
(356 days)		S38.0.41Linuxx86multijoin and related subqueries are used, the query result is incorrect during optimizer_switch="derived_merge=on"
1183982025-06-09
8:00		2025-06-11
12:40		MySQL Server: DMLVerified
(354 days)		S38.0.41AnyAnyUsing temporary with avg cause wrong result
1183942025-06-09
2:04		2026-02-05
22:18		MySQL Server: OptimizerVerified
(115 days)		S38.0.41AnyAnywhile (NOT XX NOT IN ()) return 0, the query with where (NOT XX NOT IN ()) returns a wrong result.
1183932025-06-09
1:36		2026-02-05
22:47		MySQL Server: OptimizerVerified
(115 days)		S38.0.41AnyAnywhile the having subquery return NULL actually, the query using this having query returns a wrong result.
1183912025-06-08
16:43		2025-06-10
12:23		MySQL Server: DMLVerified
(356 days)		S38.4.2, 8.0AnyAnyInconsistent BIGINT overflow behavior with unary minus operator in multiplication
1183752025-06-06
3:41		2026-02-06
12:01		MySQL Server: OptimizerVerified
(114 days)		S38.0.41AnyAnywhile (NOT ((t0.c1) >= (t1.c2))) returns 1 actually, the query return an empty result set.
1183692025-06-05
11:21		2026-02-06
12:16		MySQL Server: OptimizerVerified
(114 days)		S38.0.41AnyAny"having column" and "having MIN(column)" return different result.something wrong during Aggregate using temporary table
1183522025-06-04
4:38		2025-06-04
8:51		MySQL Server: CharsetsVerified
(361 days)		S38.0, 8.4AnyAnyIllegal mix of collations when modify collation_connection
1183512025-06-04
2:24		2025-06-04
6:34		MySQL Server: DMLVerified
(361 days)		S38.0.41Linuxx86When Backward index scan is used for query SQL statements, the returned result is incorrect.
1183502025-06-04
2:03		2025-06-04
6:32		MySQL Server: OptimizerVerified
(361 days)		S39.xAnyAnyContribution: Adding fuzz directory and modifications to support it.
1183492025-06-04
2:03		2025-06-04
19:16		MySQL Server: OptimizerVerified
(361 days)		S39.xAnyAnyContribution: fuzz: parse_sql target
1183362025-06-03
8:24		2026-02-06
12:26		MySQL Server: OptimizerVerified
(114 days)		S38.0.41AnyAnyafter adding a having clause equivalent to "having 1", the returned result set is wrong
1183132025-05-30
9:17		2025-05-30
10:19		MySQL Server: OptimizerVerified
(366 days)		S38.0.41, 8.0.42, 8.4.5, 9.3.0AnyAnyThe query result is incorrect.
1183122025-05-30
8:12		2025-05-30
10:32		MySQL Server: DMLVerified
(366 days)		S28.0.42, 8.4.5, 9.3.0AnyAnyInconsistent results when evaluating `EXCEPT` or `INTERSECT` operations involving `NULL`
1183102025-05-30
3:36		2026-02-06
12:34		MySQL Server: OptimizerVerified
(114 days)		S38.0.41AnyAnya query with a impossile having clause, return wrong results
1182982025-05-29
2:46		2026-02-06
12:48		MySQL Server: OptimizerVerified
(114 days)		S38.0.41AnyAny"(t1.c4)<-(-1.7976931348623157E308)" and "(t1.c4)<(1.7976931348623157E308)" in where clause return different results
1182962025-05-29
2:32		2025-05-29
6:03		MySQL Server: DMLVerified
(367 days)		S38.0.41Linuxx86When join_buffer_size is set to a different value, the query returns different results.
1182782025-05-27
8:29		2026-02-06
13:01		MySQL Server: OptimizerVerified
(114 days)		S38.0.41AnyAnytwo query SQL statements filling with opposite semantics in the where clause, result same result
1182772025-05-27
8:02		2026-02-06
13:11		MySQL Server: OptimizerVerified
(114 days)		S38.0.41AnyAnyWhen a constant value is replaced by the IFNULL(NULL, CONST_VALUE) function, the sql returns different value;
1182682025-05-26
7:47		2026-02-06
13:22		MySQL Server: OptimizerVerified
(114 days)		S38.0.41AnyAnyThe returned results of two queries with the same semantics are inconsistent.
1182642025-05-25
15:04		2025-08-13
11:05		MySQL Server: OptimizerVerified
(298 days)		S59.3.0UbuntuAnyPerformance bug in SEMI JOIN with empty tables
1182392025-05-21
13:05		2025-05-29
13:12		MySQL Server: DMLVerified
(367 days)		S39.3.0Ubuntu (22.04)AnyLogical Inconsistency in MySQL String Comparison with LIKE and NOT LIKE Operators
1182242025-05-19
2:46		2026-02-07
19:22		MySQL Server: OptimizerVerified
(113 days)		S38.0.41AnyAnyWhen a constant value is replaced by the LEST function, the sql returns different value;
1181982025-05-14
14:16		2025-05-19
22:49		MySQL Server: OptimizerVerified
(377 days)		S29.3.0Ubuntu (22.04)AnyDifferent intersection orders lead to more than 20,000 times performance gap
1181812025-05-13
12:36		2025-07-03
9:33		MySQL Server: DMLVerified
(334 days)		S58.0.42Linuxx86Performance regression on query statements after commit 0fa789a
1181772025-05-13
8:53		2025-05-22
6:28		MySQL Server: OptimizerVerified
(374 days)		S38.0.35AnyAnyUnnecessary filter operator in the execution plan
1181742025-05-13
6:43		2025-05-14
7:18		MySQL Server: OptimizerVerified
(382 days)		S38.0AnyAnySkip Scan doesn't support non-covering key scan
1181732025-05-13
6:42		2025-07-03
9:24		MySQL Server: DMLVerified
(333 days)		S58.0.42Ubuntu (22.04)x86The insert statement suffers a performance penalty after commit cd66c5c.
1181642025-05-12
8:38		2025-05-12
13:01		MySQL Server: DMLVerified
(384 days)		S38.0.41Linuxx86When sort_buffer_size is set to a different value, group_concat returns different results.
1181612025-05-12
6:57		2025-10-27
6:49		MySQL Server: CompilingVerified
(216 days)		S38.0.43MacOS (15.4.1)ARMHaving Homebrew-installed googletest breaks build
1181582025-05-09
20:09		2025-05-12
12:05		MySQL Server: OptimizerVerified
(384 days)		S58.4.5AnyAnyEndless loop while executing some CTE
1181442025-05-08
23:35		2025-05-14
10:18		MySQL Server: OptimizerVerified
(382 days)		S58.0.40, 8.0.42Red Hat (RHEL9)x86Performance regression at 8.0.40 related to record buffer usage
1181372025-05-08
11:49		2025-05-08
12:10		MySQL Server: DMLVerified
(388 days)		S39.3, 8.0, 8.4AnyAnyContradictory query results for decimal data type
1181122025-05-04
21:32		2025-05-05
13:34		MySQL Server: CompilingVerified
(391 days)		S39.3.0Windows (11)x86openssl build bug
1180922025-04-30
3:31		2025-08-06
12:51		MySQL Server: DMLVerified
(396 days)		S28.0.41, 8.0.42, 8.4.5, 9.3.0LinuxAnyThe query result using index is different with not used index
1180892025-04-29
14:56		2025-05-08
13:57		MySQL Server: OptimizerVerified
(396 days)		S38.0.42, 8.4.5, 9.3.0AnyAnyCOALESCE with BIT field may return wrong values
1180852025-04-29
12:14		2025-04-29
13:43		MySQL Server: OptimizerVerified
(397 days)		S19.3,9.0,8.0,8.0.42, 8.4.5AnyAnyWrong right join result involving subquery
1180802025-04-29
6:51		2025-04-29
8:08		MySQL Server: OptimizerVerified
(397 days)		S38.0.42AnyAnyThe execution plan for the view with UNION ALL uses a full table scan instead of an index.
1180732025-04-28
15:10		2025-04-29
6:29		MySQL Server: OptimizerVerified
(397 days)		S19.3,9.0,8.0, 8.0.42AnyAnyWrong Inner Join Result
1180712025-04-28
13:09		2025-04-28
14:07		MySQL Server: OptimizerVerified
(398 days)		S28.0.41, 8.0.42, 8.4.5, 9.3.0AnyAnyIndexed table fails WHERE filtering with different charset value
1180632025-04-27
19:02		2025-04-28
7:39		MySQL Server: OptimizerVerified
(398 days)		S19.0, 8.0, 8.0.42, 8.4.5, 9.3.0AnyAnyWrong Join Result after creating index on expressions
1180612025-04-26
13:02		2025-04-28
7:40		MySQL Server: OptimizerVerified
(398 days)		S19.3, 8.4.5, 8.0.42AnyAnywrong inner join result when adding an additional true expression
1180602025-04-25
16:53		2026-05-18
12:38		MySQL Server: DMLVerified
(113 days)		S28.0.40AnyAnyAfter an error occurs when importing data containing NULL fields, insert can not be executed normally.
1180262025-04-21
15:03		2025-04-22
7:02		MySQL Server: CompilingVerified
(404 days)		S38.0.42MacOSAnyBuild failed with apple clang 17
1180242025-04-21
12:46		2025-04-23
8:07		MySQL Server: OptimizerVerified
(405 days)		S19.3.0AnyAnyWrong Right Join involving a predicate containing IFNULL and IN
1180202025-04-20
23:23		2025-08-12
4:14		MySQL Server: OptimizerVerified
(377 days)		S19.2.0, 9.3.0Any (22.04)AnyA critical logic bug and performance bug
1180182025-04-20
13:49		2025-08-12
4:14		MySQL Server: OptimizerVerified
(377 days)		S19.2.0, 9.3.0Ubuntu (22.04)AnyA query expose a logic bug and performance bug
1180172025-04-20
10:59		2025-08-12
4:13		MySQL Server: OptimizerVerified
(377 days)		S59.2.0, 9.3.0Ubuntu (22.04)AnyA very serious performance bug
1180162025-04-20
10:34		2025-04-21
12:52		MySQL Server: OptimizerVerified
(406 days)		S29.3, 9.0, 8.0, 8.0.42AnyAnyWrong inner join result involving subquery containing distinct
1180152025-04-20
7:18		2025-08-12
4:13		MySQL Server: OptimizerVerified
(377 days)		S59.2.0, 9.3.0Ubuntu (22.04)AnyThe query which always return a empty result should not comsume executing time
1180142025-04-19
16:53		2025-04-20
13:53		MySQL Server: OptimizerVerified
(406 days)		S29.3.0,8.0, 8.0.42, 8.4.5, 9.3.0AnyAnyWrong Left Join Result
1180112025-04-18
13:26		2026-04-16
2:26		MySQL Server: Data TypesVerified
(403 days)		S38.0.41AnyAnyTimestamp literals with fractional seconds and time zone offset do not convert correctly
1180012025-04-17
4:15		2025-04-21
12:26		MySQL Server: DMLVerified
(405 days)		S28.4.3, 8.4.5AnyAnydelete sql returns error: Temporary file write failure.
1179592025-04-13
0:31		2025-04-13
16:37		MySQL Server: OptimizerVerified
(413 days)		S29.2.0Ubuntu (22.04)AnyPRIMARY KEY leads to incorrect INTERSECT result
1179412025-04-10
13:29		2025-04-10
14:45		MySQL Server: OptimizerVerified
(416 days)		S28.0.41, 8.4.4, 9.2.0AnyAnyInconsistent query results with / without NOT NULL for BLOB type
1179272025-04-10
6:25		2025-04-10
7:35		MySQL Server: JSONVerified
(416 days)		S28.0.41, 8.4AnyAnyduplicate key in table while using tmp table for group by a json data
1178672025-04-03
8:32		2025-04-09
10:19		MySQL Server: OptimizerVerified
(417 days)		S58.0.41AnyAnyuse distinct+left join, MySQL 8.0 excute long time than MySQL 5.7
1178602025-04-02
10:44		2025-05-12
12:20		MySQL Server: OptimizerVerified
(384 days)		S29.2.0Any (Ubuntu 22.04)AnyRead another insertion WITH CONSISTENT SNAPSHOT
1178562025-04-02
7:42		2025-04-02
8:01		MySQL Server: OptimizerVerified
(424 days)		S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyREPEAT Function Causes Row Loss in WHERE Clause
1178552025-04-02
7:37		2025-04-02
8:15		MySQL Server: OptimizerVerified
(424 days)		S2 9.1.0 , 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyQUOTE Function Incorrectly Handles NULL Values
1178542025-04-02
7:31		2025-04-02
8:35		MySQL Server: OptimizerVerified
(424 days)		S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Filtering Behavior of MAKE_SET Function
1178532025-04-02
7:23		2025-04-02
9:27		MySQL Server: OptimizerVerified
(424 days)		S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Result When Using LEFT OUTER JOIN with Subquery
1178522025-04-02
7:14		2025-04-08
15:00		MySQL Server: OptimizerVerified
(424 days)		S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Handling of NULL Values with FIELD Function in SQL Query
1178512025-04-02
7:05		2025-04-02
9:45		MySQL Server: OptimizerVerified
(424 days)		S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Behavior of EXISTS Condition with OR in SQL Query
1178492025-04-02
6:52		2025-04-02
9:48		MySQL Server: OptimizerVerified
(424 days)		S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Query Results When Using Nested String Operation Functions with Conditional Expressions as Inner Parameters
1178482025-04-02
6:37		2025-04-02
9:50		MySQL Server: OptimizerVerified
(424 days)		S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyINTERVAL Function Incorrectly Filters Results in WHERE Clause
1178472025-04-02
6:29		2025-04-02
7:47		MySQL Server: OptimizerVerified
(424 days)		S2 9.1.0 , 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyNULLIF Filtering Fails in WHERE Clause
1178342025-03-31
3:43		2025-04-01
7:20		MySQL Server: OptimizerVerified
(425 days)		S39.2, 8.0.41, 8.4.4Ubuntux86Double negation on booleans incorrectly returns negated value
1178112025-03-27
15:19		2025-04-03
14:22		MySQL Server: OptimizerVerified
(429 days)		S18.4.4, 8.0.41, 9.2.0AnyAnyIncorrect query results for BLOB type
1178092025-03-27
13:06		2025-03-27
20:10		MySQL Server: OptimizerVerified
(430 days)		S5AnyAny Statistics update failed.
1178082025-03-27
7:21		2025-03-27
10:01		MySQL Server: Prepared statementsVerified
(430 days)		S38.0.41, 8.4.2AnyAnyUnexpected JSON column DML error with prepare statement
1177912025-03-25
13:30		2026-03-23
2:03		MySQL Server: OptimizerOpen
(69 days)		S38.0, 8.4, 9.2AnyAnyFORCE INDEX does not skip records_in_range() for 'x IS NULL'
1177832025-03-25
8:45		2025-03-26
8:20		MySQL Server: OptimizerVerified
(431 days)		S28.0.32, 8.0.41AnyAnyoptimizer selects the wrong index due to the "low_limit" mechanism
1177762025-03-24
5:01		2025-03-24
7:46		MySQL Server: OptimizerVerified
(433 days)		S38.0, 8.4, 9.2AnyAnyIndex statistics is unexpectedly used to estimate eq ranges with null part
1177702025-03-22
5:32		2025-03-24
7:54		MySQL Server: OptimizerVerified
(433 days)		S58.0.36, 8.0.41, 8.4.4, 9.2.0AnyAnyrechecking_index_usage causes the materialized table to be generated using table scan in Materialize semijoin strategy
1177652025-03-21
3:09		2025-03-21
9:01		MySQL Server: OptimizerVerified
(436 days)		S29.2.0, 8.0.41, 8.4.4AnyAnyQuery result may be wrong if using compound order by inside GROUP_CONCAT
1177212025-03-17
3:20		2025-03-17
7:59		MySQL Server: DMLVerified
(440 days)		S38.0, 8.0.41Ubuntux86Inferred type of functional index is ambiguous and restricts column values
1177142025-03-14
15:36		2025-03-21
1:11		MySQL Server: OptimizerVerified
(439 days)		S25.7.42AnyAnyIncorrect row filtering when using CAST(... AS DATE) adding an AND condition.
1177062025-03-14
9:41		2025-03-14
10:18		MySQL Server: OptimizerVerified
(443 days)		S3 9.1.0 , 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyInconsistent Behavior when use a <=> b and a = b in queries
1177052025-03-14
9:39		2025-03-17
8:15		MySQL Server: OptimizerVerified
(440 days)		S58.0AnyAnySubquery performance degregation
1177042025-03-14
9:24		2025-03-14
10:49		MySQL Server: OptimizerVerified
(443 days)		S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyWHERE Clause Fails to Filter NULL Values in Condition (col1 = col2)
1177032025-03-14
9:00		2025-03-14
10:39		MySQL Server: OptimizerVerified
(443 days)		S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Query Results When Using REPEAT (Branch Structure) in Subquery
1177022025-03-14
8:48		2025-03-14
10:29		MySQL Server: OptimizerVerified
(443 days)		S2 9.1.0 , 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Query Results When Using DISTINCT and Logical AND in Subquery
1176742025-03-12
6:20		2025-03-17
9:46		MySQL Server: JSONVerified
(440 days)		S28.0.37, 8.0.41, 8.4.4AnyAnyJSON value is not recognized by Mysql inside Stored Routines
1176632025-03-11
8:29		2025-03-11
8:57		MySQL Server: JSONVerified
(446 days)		S39.2.0AnyAnyJSON_ARRAY func result error
1176532025-03-10
3:22		2025-03-10
5:36		MySQL Server: OptimizerVerified
(447 days)		S28.0, 8.0.41, 8.4.4, 9.2.0Ubuntux86Invisible index affects output of query result
1176512025-03-09
15:43		2025-03-10
6:50		MySQL Server: OptimizerVerified
(447 days)		S29.2.0, 9.1.0, 8.0.41, 8.4.4Ubuntu (22.04)AnySTRAIGHT_JOIN produces inconsistent results when comparing text values
1176482025-03-09
14:15		2025-03-10
7:19		MySQL Server: OptimizerVerified
(447 days)		S29.2.0, 9.1.0, 8.0.41, 8.4.4,Ubuntu (22.04)AnyEquivalent straight-join queries with different join orders return different results.
1176342025-03-06
14:00		2025-03-07
12:59		MySQL Server: OptimizerVerified
(450 days)		S18.4.4, 8.0.41AnyAnyIncorrect query results
1176192025-03-05
0:14		2025-03-05
5:53		MySQL Server: OptimizerVerified
(452 days)		S28.*, 8.0.41, 8.0.44AnyAnyMySQL indexes in MyISAM tables not behave as expected.
1176062025-02-28
16:01		2025-02-28
16:27		MySQL Server: OptimizerVerified
(457 days)		S18.4.4, 8.0.41AnyAnyIncorrect query result
1175982025-02-28
3:28		2025-09-22
15:11		MySQL Server: OptimizerVerified
(457 days)		S28.0.35, 8.0.41, 8.4.4AnyAnyWrong sort order for queries with ORDER BY DESC when using range comparison with LIMIT
1175732025-02-26
4:47		2025-03-21
7:12		MySQL Server: OptimizerVerified
(436 days)		S29.2.0, 8.0.41, 8.4.4Ubuntu (22.04)x86Equivalent inner-join queries return different results
1175722025-02-26
2:37		2025-02-26
6:36		MySQL Server: OptimizerVerified
(459 days)		S28.0.41Ubuntu (22.04)x86The same query yields different results across different versions
1175622025-02-25
3:09		2025-02-25
5:53		MySQL Server: Data TypesVerified
(460 days)		S38.4.4AnyAnyTypo in sql/field.cc:301
1175492025-02-24
2:24		2025-02-24
4:52		MySQL Server: OptimizerVerified
(461 days)		S18.0, 8.0.41, 8.4.4AnyAnyWrong result when use "in (select * from (set operation) d)"
1175342025-02-20
14:39		2025-02-21
11:36		MySQL Server: OptimizerVerified
(464 days)		S38.0AnyAnyCreate index can lead to incorrect results
1175002025-02-18
11:40		2025-03-11
8:56		MySQL Server: OptimizerVerified
(467 days)		S29.2.0, 8.0.41, 8.4.4AnyAnyresult error when row compared with scalar subquery using '<=>'
1174862025-02-17
8:04		2025-02-17
22:40		MySQL Server: OptimizerVerified
(468 days)		S29.1.0, 8.0.41Ubuntu (22.04)x86Incorrect Semi-join Execution
1174852025-02-17
7:04		2025-02-17
7:53		MySQL Server: OptimizerVerified
(468 days)		S29.1.0, 8.0.41, 8.4.4Ubuntu (22.04)x86Incorrect Semi-join Execution
1174762025-02-15
13:10		2025-02-20
13:36		MySQL Server: OptimizerVerified
(467 days)		S3 9.1.0-clusterUbuntu (18.04)x86Inconsistent result after using optimizer_switch
1174572025-02-13
2:37		2025-02-13
7:02		MySQL Server: DMLVerified
(472 days)		S38.4.1 9.1.0 , 8.0.41Windows (windows 11)x86 (x86_64)Unexpected results with complex WHERE conditions
1174562025-02-13
2:24		2025-02-13
6:37		MySQL Server: DMLVerified
(472 days)		S38.4.1 9.1.0, 8.0.41Windows (windows 11)x86 (x86_64)Unexpected results when using JSON_OBJECT function in WHERE clause
1174542025-02-13
2:08		2025-02-13
5:48		MySQL Server: JSONVerified
(472 days)		S28.4.1 9.1.0 , 8.0.41Windows (windows 11)x86 (x86_64)Unexpected results with JSON_VALID function in WHERE clause.
1174532025-02-13
1:51		2025-02-13
5:20		MySQL Server: DMLVerified
(472 days)		S28.4.1 9.1.0, 8.0.41Windows (windows 11)x86 (x86_64)Unexpected results with ACOS function in WHERE clause.
1174522025-02-13
1:38		2025-02-13
4:43		MySQL Server: DMLVerified
(472 days)		S38.4.1 9.1.0 , 8.0.41Windows (windows 11)x86 (x86_64)Unexpected results with IS_IPV4_MAPPED in WHERE clause.
1174512025-02-13
1:33		2025-12-30
7:41		MySQL Server: OptimizerVerified
(472 days)		S28.4.1 9.1.0, 8.0.41Windows (windows 11)x86 (x86_64)Comparing a BIGINT column with the result of an IF function using "=" yields unexpected results.
1174462025-02-12
7:56		2025-02-12
16:11		MySQL Server: OptimizerVerified
(473 days)		S39.2AnyAnyUnexpected lock wait timeout when executing select for update
1174432025-02-11
19:40		2025-08-07
17:53		MySQL Server: CompilingVerified
(473 days)		S39.2.0AnyAnycmake doesn't detect missing quadmath library
1174392025-02-11
14:27		2025-02-20
13:12		MySQL Server: OptimizerVerified
(473 days)		S28.0, 8.0.41, 8.4.4, 9.2.0Ubuntux86Suspicious behaviour around creation of multi-column indexes
1174092025-02-07
5:48		2025-02-07
6:45		MySQL Server: OptimizerVerified
(478 days)		S58.0.35, 8.0.41AnyAnyjoin with crosse table sort is not optimized away by index
1174082025-02-07
4:26		2025-02-07
8:42		MySQL Server: OptimizerVerified
(478 days)		S58.0.41AnyAnyTight index scan not used when group by does not begin with first part of key, but where condition is list of constants
1173872025-02-05
12:39		2025-02-05
15:42		MySQL Server: OptimizerVerified
(480 days)		S28.4.4, 8.0.41AnyAnyQuery returns wrong results when using offset limit subquery in view
1173862025-02-05
10:13		2025-02-05
13:51		MySQL Server: OptimizerVerified
(480 days)		S28.0, 8.0.41, 8.4.4Ubuntux86Ambiguous functional index not based on any column under-fetches rows
1173482025-01-31
10:06		2025-01-31
13:56		MySQL Server: OptimizerVerified
(485 days)		S28.4, 8.0.41, 8.4.4, 9.2.0Debianx86Query with DISTINCT in combination with big_tables returns wrong sortorder
1173462025-01-30
19:17		2025-02-06
13:55		MySQL Server: CompilingVerified
(485 days)		S39.2.0AnyAnyContribution: Added documentation for unused bytes at the end of Protocol:: ...
1172992025-01-27
11:48		2025-10-17
10:25		MySQL Server: CompilingVerified
(226 days)		S38.4.5, 9.2.0MacOS (15.2)ARMddl0bulk.h:236:15: error: parameter 'prebuilt' not found in the function declaration [-Werror,-Wdocumentation]
1172812025-01-23
10:27		2025-01-23
17:01		MySQL Server: CompilingVerified
(493 days)		S28.0AnyAnysql/table_cache.cc init does not cleanup on failure
1172732025-01-23
4:13		2025-01-24
5:18		MySQL Server: OptimizerVerified
(492 days)		S58.0.35AnyAnysome sort is not optimized away by index, if index have part of primary key
1172612025-01-22
8:37		2025-01-24
7:46		MySQL Server: OptimizerVerified
(494 days)		S38.0, 8.0.40, 8.4.3Ubuntux86Creation of multicolumn indexes might lead to rows not being fetched during GROUP BY
1172422025-01-20
9:13		2025-01-20
9:50		MySQL Server: OptimizerVerified
(496 days)		S28.0, 8.0.40, 8.4.3Ubuntux86DISTINCT does not fetch all distinct rows when used with GROUP BY
1172352025-01-18
7:00		2025-01-20
6:07		MySQL Server: JSONVerified
(496 days)		S38.4.1,9.1.0, 8.0.40, 8.4.3Windowsx86Unexpected results when using JSON_ARRAY comparison as a predicate.
1172342025-01-18
6:35		2025-01-20
5:58		MySQL Server: JSONVerified
(496 days)		S28.4.1,9.1.0, 8.0.40, 8.4.3Windowsx86Unexpected results when using JSON_ARRAY(NULL) in query predicates.
1172332025-01-18
6:00		2025-01-20
5:54		MySQL Server: DMLVerified
(496 days)		S28.4.1,9.1.0, 8.0.40, 8.4.3Windowsx86The same query involving TIME type returns different results with and without using an index.
1172322025-01-18
5:48		2025-01-20
5:29		MySQL Server: Data TypesVerified
(496 days)		S28.4.1,9.1.0, 8.4.0, 8.4.3Windows (windows 11)x86Unexpected results with YEAR data type comparisons in query predicates.
1172232025-01-17
7:33		2025-01-17
9:16		MySQL Server: Data TypesVerified
(499 days)		S28.4.1 9.1.0, 8.0.40Windowsx86Query results are unexpected with BIT data type and IN operator.
1172222025-01-17
7:26		2025-01-17
9:15		MySQL Server: Data TypesVerified
(499 days)		S38.4.1 9.1.0, 8.0.40Windowsx86Query results are unexpected with BIT data type comparisons.
1172132025-01-16
5:22		2025-01-16
15:51		MySQL Server: DMLVerified
(500 days)		S38.0AnyAnyWrong execution result when remove all parentheses
1171992025-01-13
14:07		2025-01-13
14:42		MySQL Server: OptimizerVerified
(503 days)		S38.0AnyAnyInconsistent Results with JSON_UNQUOTE Between Table and View
1171982025-01-13
13:26		2025-01-13
14:40		MySQL Server: Data TypesVerified
(503 days)		S38.0AnyAnyInconsistent Results with CASE and Spatial Data Between Table and View
1171862025-01-13
3:01		2025-01-15
6:36		MySQL Server: DMLVerified
(503 days)		S28.0.40, 8.4.3AnyAnyresult is incorrect
1171642025-01-09
6:17		2025-01-09
7:08		MySQL Server: OptimizerVerified
(507 days)		S38.0.36, 8.0.40AnyAnyRange estimation (index dives) overestimates the rows count on large ranges. It almost doubles the actual number of rows
1171552025-01-09
2:29		2025-01-09
4:48		MySQL Server: OptimizerVerified
(507 days)		S38.0.32, 8.0.40AnyAnydrived_merge optimization error
1171342025-01-08
10:25		2025-01-08
10:47		MySQL Server: GISVerified
(508 days)		S18.0.40AnyAnyST_Buffer gives unexpected result with LinearRing
1171312025-01-08
7:52		2025-01-09
9:20		MySQL Server: DMLVerified
(507 days)		S38.4.1, 8.0.40Windows (windows 11)x86 (x86_64)Query results don't match expectations with FIELD function in predicate.
1171302025-01-08
7:03		2025-01-08
7:50		MySQL Server: ParserVerified
(508 days)		S39.1.0AnyAnyerror occurs when using cast collate binary
1171292025-01-08
6:33		2025-01-08
7:15		MySQL Server: GISVerified
(508 days)		S38.0.40AnyAnyPotential bug in ST_Crosses
1171282025-01-08
5:42		2025-01-13
9:23		MySQL Server: DMLVerified
(508 days)		S38.4.1, 8.0.40Windows (windows 11)x86Query results do not meet expectations when the predicate involves CAST AS FLOAT and >> operator
1171272025-01-08
5:38		2025-01-08
7:38		MySQL Server: DMLVerified
(508 days)		S38.4.1, 8.0.40Windows (windows 11)x86 (x86_64)Query results do not meet expectations when the predicate involves CASE WHEN and LIKE
1171202025-01-07
12:40		2025-01-07
12:46		MySQL Server: GISVerified
(509 days)		S39.0, 8.0.40AnyAnyInconsistent Results with ST_Collect in WHERE Clause
1171052025-01-04
10:02		2025-01-06
9:43		MySQL Server: OptimizerVerified
(512 days)		S28.0.39, 8.0.40AnyAnyDependent subqueries incorrect results
1170962025-01-02
8:43		2025-01-02
11:59		MySQL Server: DMLVerified
(514 days)		S38.4.1, 8.0.40Windows (windows 11)x86 (x86_64)The result of using CAST AS DOUBLE in the query does not meet expectations.
1170952025-01-02
7:00		2025-01-02
7:24		MySQL Server: DMLVerified
(514 days)		S38.4.1, 8.0.40Windows (windows 11)x86 (x86_64)The GREATEST function in the predicate behaves unexpectedly.
1170942025-01-02
6:31		2025-01-02
7:35		MySQL Server: DMLVerified
(514 days)		S38.4.1, 8.0.40Windows (windows 11)Any (x86_64)Using TRUE and * in SELECT returns different row counts.
1170912025-01-01
15:26		2025-01-02
7:37		MySQL Server: DMLVerified
(514 days)		S38.4.3, 8.0.40Windows (windows 11)x86 (x86_64)Using two mutually exclusive predicates as WHERE conditions returned the same result.
1170892025-01-01
8:37		2025-01-01
9:29		MySQL Server: DMLVerified
(515 days)		S38.4.1, 8.0.40Windows (windows 11)x86 (x86_64)Inconsistent results using equivalent predicates in two queries.
1170762024-12-30
13:38		2024-12-30
13:49		MySQL Server: GISVerified
(517 days)		S28.0.40AnyAnyST_Intersection returns a non-empty result for two geometries that are disjoint.
1170722024-12-30
9:24		2024-12-30
10:06		MySQL Server: OptimizerVerified
(517 days)		S28.4.3, 9.1.0, 8.0.40Any (Ubuntu 22.04)Any (x86)MAX() as a Window Function Returns NULL for the First Row Even With Non-empty Window Frame Under Specific Conditions
1170632024-12-28
13:40		2024-12-30
13:44		MySQL Server: GISVerified
(517 days)		S18.0.40AnyAnySpatial index causes the disjoint predicate gives wrong result with WHERE,INNER JOIN and CROSS JOIN,
1170602024-12-27
13:28		2024-12-27
13:39		MySQL Server: DMLVerified
(520 days)		S38.4.3, 8.0.40AnyAnychanging a constant TRUE to a condition involving TO_DAYS leads to a different result set
1170592024-12-27
13:14		2024-12-27
13:17		MySQL Server: DMLVerified
(520 days)		S38.4.3, 8.0.40AnyAnyInconsistent Query Results Between Materialized Table and View with Division
1170582024-12-27
13:01		2024-12-27
13:16		MySQL Server: DMLVerified
(520 days)		S38.4.3, 8.0.40AnyAnyInconsistent Results When Using COALESCE
1170572024-12-27
12:35		2024-12-27
13:16		MySQL Server: DMLVerified
(520 days)		S38.4.3, 8.0.40AnyAnyInconsistent Results Between Materialized Table and View with GREATEST
1170552024-12-27
10:11		2024-12-27
12:49		MySQL Server: OptimizerVerified
(520 days)		S38.0.40, 8.4.3AnyAnyQuery result may be incorrect if unique index contains NULL
1170482024-12-26
9:06		2024-12-30
13:44		MySQL Server: GISVerified
(517 days)		S28.0.40AnyAnyST_Buffer gives unexpected reuslt using end_flat strategy with closed Linestring
1170472024-12-26
8:27		2024-12-30
13:44		MySQL Server: GISVerified
(517 days)		S18.0.40AnyAnyST_Touches always return null with Point and GeometryCollection with Points
1170462024-12-25
12:44		2024-12-30
13:44		MySQL Server: GISVerified
(517 days)		S28.0.40AnyAnyNegative buffer of a polygon gives an result that not small enough.
1170422024-12-25
6:56		2024-12-30
13:43		MySQL Server: GISVerified
(517 days)		S28.0.40WindowsAnyST_Within gives unexpected result with Linestring and Polygon in WGS84.
1170402024-12-24
13:04		2024-12-24
13:14		MySQL Server: DMLVerified
(523 days)		S38.4.3, 8.0.40Windows (windows 11)x86 (x86_64)Inconsistent behavior for the same query on a DATETIME column with and without a PRIMARY KEY constraint.
1170362024-12-23
7:28		2024-12-31
5:43		MySQL Server: GISVerified
(524 days)		S28.0, 8.0.40AnyAnySpatial Index causes CHECK TABLE to fail
1170172024-12-18
19:11		2025-01-09
17:17		MySQL Server: OptimizerVerified
(528 days)		S38.0AnyAnyIncorrect Operator Precedence of IN and Comparators in MySQL 8.4.3 and 9.1.0
1169642024-12-13
8:06		2024-12-13
9:31		MySQL Server: OptimizerVerified
(534 days)		S28.0.38, 8.0.40LinuxAnyResult mismatch caused by derived condition push down.
1169372024-12-11
8:25		2024-12-11
15:33		MySQL Server: OptimizerVerified
(536 days)		S38.0, 8.0.40AnyAnyestimation of REF is modified by index diving of INDEX MERGE
1169002024-12-07
8:28		2024-12-09
8:10		MySQL Server: OptimizerVerified
(538 days)		S58.0.40AnyAnyReuseRangeEstimateForRef does not work properly when there are non-prefixed multi keypart ref
1168952024-12-06
11:45		2024-12-25
3:09		MySQL Server: OptimizerVerified
(541 days)		S29.0,8.0, 8.0.40, 8.4.3AnyAnyView using IN(SELECT LIMIT) has wrong result
1168932024-12-06
9:22		2024-12-06
9:43		MySQL Server: DMLVerified
(541 days)		S39.0, 8.0.40AnyAnyInconsistent Results Between Materialized Table and View with GREATEST
1168922024-12-06
8:39		2024-12-06
9:43		MySQL Server: DMLVerified
(541 days)		S39.0, 8.0.40AnyAnyInconsistent Query Results Between Materialized Table and View with FROM_UNIXTIME
1168902024-12-06
7:31		2024-12-06
11:41		MySQL Server: Data TypesVerified
(541 days)		S38.0AnyAnyInconsistent Query Results Between Materialized Table and View with CHAR Function
1168732024-12-04
14:29		2024-12-04
15:12		MySQL Server: Data TypesVerified
(543 days)		S38.0AnyAnyWhen comparing SMALLINT and FLOAT, the type conversion logic is incorrect.
1168622024-12-04
5:11		2024-12-04
6:51		MySQL Server: DMLVerified
(543 days)		S28.4.1, 8.0.40, 8.4.3, 9.1.0Red Hat (Linux 3.10.0-1160.102.1.el7.x86_64)x86 (x86_64)After deleting the index, the same query produces inconsistent results compared to before.
1168522024-12-03
3:33		2024-12-03
6:17		MySQL Server: JSONVerified
(544 days)		S38.0.34, 8.0.40AnyAnyDifference between JSONPath "$" vs "$[*]"
1168462024-12-02
14:42		2024-12-04
15:06		MySQL Server: Data TypesVerified
(543 days)		S38.0AnyAnyThe logical error of the NULLIF function in the WHERE condition.
1168032024-11-27
11:29		2025-03-22
0:37		MySQL Server: OptimizerVerified
(538 days)		S58.0.40AnyAnyMySQL 8.0.33 is slower than MySQL 8.0.28 with queries using JOINS
1167772024-11-25
19:50		2024-11-27
12:52		MySQL Server: OptimizerVerified
(550 days)		S5596f0d23 (9.0.0), 8.0.40AnyAnyPerformance of TPC-DS Query 47
1167762024-11-25
18:45		2024-11-28
7:53		MySQL Server: OptimizerVerified
(549 days)		S5596f0d23 (9.0.0), 8.0.40AnyAnyPerformance of TPC-DS Query 19
1167752024-11-25
18:34		2024-11-28
8:00		MySQL Server: OptimizerVerified
(549 days)		S5596f0d23 (9.0.0), 8.0.40AnyAnyPerformance of TPC-DS Query 16
1167742024-11-25
18:00		2024-11-28
8:02		MySQL Server: OptimizerVerified
(549 days)		S5596f0d23 (9.0.0), 8.0.40AnyAnyPerformance of TPC-DS Query 15
1167732024-11-25
17:40		2024-11-28
8:02		MySQL Server: OptimizerVerified
(549 days)		S5596f0d23 (9.0.0), 8.0.40AnyAnyPerformance of TPC-DS Query 7
1167652024-11-25
2:18		2024-11-25
13:34		MySQL Server: OptimizerVerified
(552 days)		S38.0Any (22.04)AnyIncorrect Operator Precedence of BETWEEN and Comparators in MySQL 8.4
1167272024-11-20
8:27		2024-11-20
8:50		MySQL Server: OptimizerVerified
(557 days)		S18.4.2, 8.0.40AnyAnyIssues with independent subqueries.
1167262024-11-20
8:22		2024-11-20
8:50		MySQL Server: OptimizerVerified
(557 days)		S18.4.2, 8.0.40AnyAnyIssues with the combination of CAST and DATE.
1167252024-11-20
7:44		2024-11-20
8:54		MySQL Server: OptimizerVerified
(557 days)		S18.4.2, 8.0.40AnyAny Issues with CASE statements.
1167242024-11-20
7:44		2024-11-20
8:49		MySQL Server: OptimizerVerified
(557 days)		S18.4.2, 8.0.40AnyAny Issues with CASE statements
1167232024-11-20
7:35		2024-11-20
8:45		MySQL Server: OptimizerVerified
(557 days)		S28.4.2, 8.0.40AnyAnyIssues with explicit type casting using CAST.
1167222024-11-20
7:11		2024-11-20
7:37		MySQL Server: OptimizerVerified
(557 days)		S18.4.2, 8.0.40AnyAny Issues with the COALESCE function.
1167212024-11-20
7:01		2024-11-20
7:37		MySQL Server: OptimizerVerified
(557 days)		S18.4.2, 8.0.40AnyAnyIssues with combining COALESCE and DATE functions.
1167202024-11-20
6:48		2024-11-20
7:37		MySQL Server: OptimizerVerified
(557 days)		S18.4.2, 8.0.40AnyAnyIssues with the combination of CASE and DATE.
1167102024-11-19
12:47		2024-11-20
11:02		MySQL Server: OptimizerVerified
(557 days)		S38.0AnyAnyexplain shows wrong cost value
1167032024-11-19
6:06		2024-11-19
6:28		MySQL Server: JSONVerified
(558 days)		S38.0.33, 8.0.40, 8.4.3, 9.1.0AnyAny`JSON_VALID` has inconsistent behavior for `NULL`
1166882024-11-18
3:23		2024-11-18
6:46		MySQL Server: JSONVerified
(559 days)		S28.0.36, 8.0.40, 8.4.3, 9.1.0AnyAnyUnexpected Behavior in `CASE` Statement with JSON Null Values
1166362024-11-13
5:25		2024-11-15
15:26		MySQL Server: OptimizerVerified
(562 days)		S28.4.3, 8.0.40, 9.1.0AnyAnyOptimizer incorrectly ignores all indexes with NO_INDEX() in some cases
1166242024-11-12
6:58		2024-11-27
8:24		MySQL Server: CompilingVerified
(550 days)		S3latest commitWindows (Windows 11)x86[MSVC] Race condition occurs during msbuild with VS2022
1166162024-11-11
15:37		2024-11-12
14:27		MySQL Server: CompilingVerified
(566 days)		S39.0AnyAnyDocumentation around AUTHENTICATION_CLIENT_PLUGINS in MySQL 9.0 is misleading
1166122024-11-11
11:46		2025-05-07
7:17		MySQL Server: OptimizerVerified
(566 days)		S58.0.40, 8.0.41, 8.4.4AnyAnyPerformance degradation of distinct operator from 5.7 to 8.0
1166062024-11-10
6:44		2024-11-11
7:16		MySQL Server: JSONVerified
(566 days)		S29.0, 8.0.40, 8.4.3, 9.1.0AnyAnyIncorrect Grouping in JSON_OBJECTAGG Aggregation for Case-Sensitive Column
1165942024-11-08
6:13		2024-11-26
7:51		MySQL Server: CompilingVerified
(551 days)		S28.4, 8.0Windowsx86[MSVC] MySQL failed to build with msvc on Windows when add ASAN option
1165842024-11-07
11:58		2024-11-10
6:46		MySQL Server: CharsetsVerified
(570 days)		S28.0.36, 8.0.40Any (Redhat 7.4)Any (Intel)Query produces different resultset with force index
1165722024-11-06
19:58		2024-11-11
10:05		MySQL Server: DMLVerified
(569 days)		S38.0AnyAnyInconsistent MATCH() Relevance Scores in BOOLEAN MODE When Grouping Results
1165472024-11-05
6:06		2024-11-05
8:08		MySQL Server: DMLVerified
(572 days)		S39AnyAnyInconsistent WHERE Condition Handling for ELT Function
1165342024-11-03
10:40		2024-11-06
12:58		MySQL Server: OptimizerVerified
(571 days)		S5596f0d23 (9.0.0)AnyAnyAnother Performance of TPC-H Query 16
1164922024-10-28
11:47		2024-11-06
13:48		MySQL Server: CharsetsVerified
(571 days)		S58.0, 8.0.40AnyAnyThe utf8mb4 character set has worse performance
1164842024-10-26
20:54		2024-10-31
15:06		MySQL Server: OptimizerVerified
(577 days)		S5596f0d23 (9.0.0), 9.1.0AnyAnyUnexpected Performance Dropdown for Query 11 in TPC-H
1164562024-10-23
6:43		2024-11-06
13:57		MySQL Server: OptimizerVerified
(577 days)		S5596f0d23 (9.0.0), 9.1.0AnyAnyPerformance of TPC-H Query 8
1164532024-10-22
21:49		2024-10-23
17:27		MySQL Server: OptimizerVerified
(585 days)		S19.0.0, 9.1.0AnyAnyquery_rewrite.flush_rewrite_rules() does not honor binlog_row_metadata=FULL
1164382024-10-21
19:06		2024-10-23
10:12		MySQL Server: Data TypesVerified
(585 days)		S38.0AnyAnyTimestamp literals have deceptive behavior in operations
1164142024-10-19
6:27		2024-10-19
15:07		MySQL Server: DMLVerified
(589 days)		S18.4.2, 8.0.40UbuntuAnyBOLB type or operation
1164002024-10-18
4:06		2024-10-18
5:56		MySQL Server: OptimizerVerified
(590 days)		S2trunk (9.1.0), 8.0.30, 8.4.3, 8.4.0AnyAnyContribution by Tencent: crash on explain format=tree for conn with subquery
1163982024-10-17
14:34		2024-10-25
9:40		MySQL Server: OptimizerVerified
(583 days)		S28.0AnyAnyIncorrect result with LEFT JOIN and small join_buffer_size
1163522024-10-14
2:57		2025-01-06
5:30		MySQL Server: GISVerified
(594 days)		S38.0.31, 8.0.39, 8.4.2AnyAnyspatial index cause check table wrong
1163382024-10-10
18:59		2024-10-11
7:55		MySQL Server: DMLVerified
(597 days)		S38.0.39AnyAnyINSERT fails on virtual date column referring to datetime column
1163352024-10-10
16:53		2025-09-10
1:54		MySQL Server: OptimizerVerified
(597 days)		S58.0.39AnyAnyMulti-valued index isn't used with some range scans on composite indexes
1163222024-10-09
10:48		2024-10-09
11:59		MySQL Server: DMLVerified
(599 days)		S3 9.0.1, 8.0.39AnyAnywhen log in mysql and do not select database, delete stmt returns error
1163092024-10-07
10:39		2024-10-22
11:32		MySQL Server: OptimizerVerified
(586 days)		S5596f0d23 (9.0.0), 9.1.0UbuntuAnyPerformance of TPC-H Query
1163002024-10-04
13:44		2024-10-04
14:34		MySQL Server: JSONVerified
(604 days)		S29.0AnyAnyTINYBLOB and BLOB with same value, stored as JSON, become different
1162412024-09-26
10:05		2024-10-25
11:03		MySQL Server: OptimizerVerified
(583 days)		S5596f0d23 (9.0.0), 9.1.0AnyAnyPotential Performance Improvement on TPC-H
1162272024-09-25
13:03		2024-10-09
11:58		MySQL Server: DMLVerified
(612 days)		S3 9.0.1AnyAnySome incorrect time should be detected
1162112024-09-24
8:14		2024-09-26
11:19		MySQL Server: DMLVerified
(614 days)		S3 9.0.1, 8.4.2, 8.0.39AnyAnyzero value of year does not display as 4 characters in union clause
1161822024-09-20
13:39		2025-05-13
7:38		MySQL Server: DMLVerified
(618 days)		S39.0.1, 8.4.2, 8.0.39, 8.4.3AnyAnyrecursive CTE handling of decimal is unexpected
1161732024-09-20
7:16		2024-09-23
14:25		MySQL Server: CompilingVerified
(618 days)		S38.0.39Red Hat (9)AnyCan't build Mysql 8.0.39 in Copr for EPEL9
1161632024-09-19
14:08		2024-09-24
12:36		MySQL Server: OptimizerVerified
(614 days)		S29.0AnyAnyCOALESCE(BIT), IF(BIT) return a wrong result
1161602024-09-19
10:28		2024-09-20
8:58		MySQL Server: JSONVerified
(618 days)		S38.0AnyAnyPrecision loss of double value in JSON
1160502024-09-10
6:14		2026-01-28
2:13		MySQL Server: OptimizerVerified
(123 days)		S28.0.39, 8.4.2Linux (centos7)x86The query results are incorrect when using CTE, CONCAT, and IN.
1160432024-09-09
15:38		2024-09-12
1:22		MySQL Server: CompilingVerified
(627 days)		S38.0.39LinuxAnyCMakeLists.txt Incorrectly Sets LINUX Flag
1160342024-09-08
16:54		2024-09-09
7:05		MySQL Server: OptimizerVerified
(629 days)		S38.4.2, 8.0.39, 9.0.1AnyAny Unexpected behavior when subquery returns an empty set
1160142024-09-05
15:43		2024-11-07
14:51		MySQL Server: OptimizerVerified
(613 days)		S58.0.27+AnyAnyPerformance Degradation in Query Execution Plans
1159692024-08-30
13:59		2024-09-02
10:36		MySQL Server: OptimizerVerified
(636 days)		S58.0.39AnyAnyMySQL need not sort with ORDER BY primary_key on InnoDB on partial index match
1158932024-08-22
10:11		2024-08-22
12:55		MySQL Server: Data TypesVerified
(647 days)		S38.0AnyAnyInconsistent Results When Using COALESCE
1158562024-08-18
12:56		2024-08-19
7:26		MySQL Server: JSONVerified
(650 days)		S38.0, 8.4, 9.0AnyAnyComposite multi-valued index fails to be used for sorting
1158432024-08-15
8:26		2024-08-21
8:04		MySQL Server: OptimizerVerified
(648 days)		S28.0.32, 8.0.39AnyAnyThe incorrect calculation of 'select_limit' led to an incorrect index selection
1158422024-08-15
8:21		2024-08-20
7:37		MySQL Server: DMLVerified
(654 days)		S28.0.39, 8.4.2, 9.0.1AnyAnyThe count distinct aggregation funciton of UUID returned an error value
1158402024-08-15
2:30		2024-08-26
7:58		MySQL Server: OptimizerVerified
(654 days)		S28.0.39, 8.4.2, 9.0.1AnyAnyContribute by Tencent:Incorrect Cost Display for Join with Materialized Subquery
1158302024-08-14
2:24		2024-08-14
6:06		MySQL Server: DMLVerified
(655 days)		S38.0.39, 8.4.2, 9.0.1AnyAny`Replace into` may be invalid when functional key is unique
1158242024-08-13
7:36		2025-07-23
8:06		MySQL Server: CharsetsVerified
(650 days)		S38.0AnyAnyThe same LOAD DATA 5.7 and 8.0 result in different
1158152024-08-12
2:56		2024-08-12
8:03		MySQL Server: OptimizerVerified
(657 days)		S28.4.2AnyAnyContribute by tencent: EXPLAIN FORMAT=TREE Incorrectly Shows Cost of Statement
1158042024-08-09
5:10		2024-08-15
11:02		MySQL Server: OptimizerVerified
(660 days)		S38.0, 8.0.39AnyAnyKey not found error when executing query
1157962024-08-08
10:18		2024-08-08
10:23		MySQL Server: OptimizerVerified
(661 days)		S38.0.30,8.4.0AnyAnyderived_merge affect exists-subselect condition pushdown
1157942024-08-08
1:54		2024-08-08
6:38		MySQL Server: OptimizerVerified
(661 days)		S38.0.30,8.4.0AnyAnywrong plan may occur when EXISTS-subselect displays its correlated cache item
1157822024-08-06
11:24		2024-08-06
11:55		MySQL Server: OptimizerVerified
(663 days)		S38.0.30,8.4.0AnyAnyunfair comparison between materialization and EXISTS
1157782024-08-06
6:24		2024-08-07
7:17		MySQL Server: DMLVerified
(662 days)		S38.4.0, 8.0AnyAnyCast DATE_ADD/SUB result as double get wrong result.
1157232024-07-30
5:02		2025-01-22
2:51		MySQL Server: DMLVerified
(494 days)		S39.0.1, 8.0.39AnyAnyFor into exists strategy of subquery, table condition may be ignored
1156792024-07-24
9:04		2024-07-24
9:46		MySQL Server: OptimizerVerified
(676 days)		S58.0.37AnyAnyBlock Nested-Loops Join can sometimes slow down the query
1156762024-07-24
4:34		2024-07-24
9:46		MySQL Server: OptimizerVerified
(676 days)		S58.0.37, 8.0.39AnyAnyThe optimizer has chosen a poor execution plan.
1156712024-07-23
9:47		2024-07-23
13:49		MySQL Server: OptimizerVerified
(677 days)		S58.0.37, 8.0.39AnyAnyThe optimizer has chosen a poor execution plan.
1156612024-07-22
5:48		2024-08-15
14:22		MySQL Server: OptimizerVerified
(678 days)		S2mysql 8.4.1, 8.0.38, 9.0.0LinuxAnyQuery results are incorrect after semijoin is turned on
1156542024-07-20
14:01		2025-07-30
11:58		MySQL Server: OptimizerVerified
(678 days)		S29.0.0, 8.0.38, 8.4.1, 9.3Ubuntu (Ubuntu 20.04.6 LTS)x86 (5.15.0-113-generic)Changing “internal_tmp_mem_storage_engine” returns incorrect results
1155652024-07-11
9:37		2024-07-11
13:11		MySQL Server: OptimizerVerified
(689 days)		S38.0AnyAnyPartition tables:compare the field with null and return an incorrect result
1155602024-07-10
15:43		2024-07-12
8:14		MySQL Server: OptimizerVerified
(688 days)		S38.0.38LinuxAnyJSON functional index not being considered for NULL check
1155592024-07-10
13:59		2024-07-11
13:10		MySQL Server: OptimizerVerified
(689 days)		S38.0AnyAnyRow constructor comparison with nested join fails to match rows
1155552024-07-10
10:31		2024-09-16
9:49		MySQL Server: OptimizerVerified
(636 days)		S58.4, 8.0.39AnyAnySevere performance regression in filesort
1155512024-07-10
1:09		2024-07-27
0:12		MySQL Server: CompilingVerified
(673 days)		S38.0AnyAnycomp_err hits AddressSanitizer: stack-buffer-overflow
1155192024-07-05
4:24		2024-07-16
13:34		MySQL Server: OptimizerVerified
(684 days)		S28.2, 8.4.1AnyAnyINTERSECT within correlated subquery results in incorrect result
1155182024-07-05
3:26		2024-08-15
7:00		MySQL Server: DMLVerified
(695 days)		S38.0.38,5.7.44,8.4,9.0AnyAnyLost a record while scanning in reverse order on cursor
1155072024-07-04
7:22		2025-07-11
5:10		MySQL Server: OptimizerVerified
(696 days)		S38.4.0, 8.4.1, 8.0.38AnyAnyif set subquery_to_derived=on, unqualified_count could not be genereated
1154712024-07-01
5:04		2024-07-04
8:23		MySQL Server: CompilingVerified
(696 days)		S38.0.37, 8.4.0MacOS (14.5)ARMLinker errors with enabled LTO
1154102024-06-23
16:02		2024-06-26
14:33		MySQL Server: Data TypesVerified
(705 days)		S38.0AnyAnyMySQL bit field index affects query results unexpectedly.
1154002024-06-21
4:14		2024-07-02
14:58		MySQL Server: OptimizerVerified
(709 days)		S38.4.0 LTSAnyAnyThe hint /+ NO_BNL(t0)/ does not always work as expected
1153982024-06-20
23:58		2024-06-21
5:51		MySQL Server: CharsetsVerified
(709 days)		S38.4.0AnyAnyContribution: Add \"Traditional Chinese\" collation for utf8mb4
1153802024-06-19
8:21		2024-06-19
8:53		MySQL Server: OptimizerVerified
(711 days)		S38.0.32, 8.0.37AnyAnyUpdate Multiple table failed when table is partitioned and using MRR path
1153532024-06-17
7:22		2024-10-14
15:29		MySQL Server: OptimizerVerified
(713 days)		S28.0.37, 8.4.0 LTSAnyAnySetting index_merge_union leads to incorrect results.
1153272024-06-13
22:01		2024-06-19
12:26		MySQL Server: OptimizerVerified
(711 days)		S58.0.37, 8.4.0AnyAnyHigher memory requirements for range optimizer in v. 8.0 vs 5.7
1152832024-06-11
12:00		2024-10-31
10:16		MySQL Server: OptimizerVerified
(719 days)		S28.0.37AnyAnyresult not correct when using ‘<=>’ operator compare null value
1152792024-06-11
7:10		2024-06-11
11:52		MySQL Server: CompilingVerified
(719 days)		S38.0.37AnyAnyWarning about YYSTYPE in mysql-8.0.37
1152782024-06-11
6:54		2024-06-11
8:59		MySQL Server: DMLVerified
(719 days)		S28.0.36, 8.0.37Any (Tested on Windows and AWS RDS))Any (Tested on x64 and AWS Graviton (Arm))Missing records in result when nullablle field with a unique index<=>NULL
1152692024-06-10
12:53		2024-06-11
10:29		MySQL Server: DMLVerified
(720 days)		S38.0AnyAny"INSERT SET column=column" inserts zero date
1152272024-06-05
10:45		2024-08-09
9:32		MySQL Server: OptimizerVerified
(725 days)		S58.0AnyAnyprepared statement encounter performance degradation compared with normal select
1152082024-06-04
8:51		2024-06-04
9:08		MySQL Server: OptimizerVerified
(726 days)		S38.0.33AnyAnyLast_query_cost could be negative number due to unmatched cost values in JOIN
1151912024-06-01
4:29		2024-06-01
9:04		MySQL Server: CompilingVerified
(729 days)		S58.0.37AnyAnyoptimize for net_write_buff
1151902024-05-31
22:12		2024-06-01
9:46		MySQL Server: OptimizerVerified
(729 days)		S58.0.36Ubuntu (jammy)AnyFailure to use index with subquery and tuples
1151612024-05-29
11:28		2024-05-29
12:18		MySQL Server: OptimizerVerified
(732 days)		S28.4.0AnyAnyhint for join order doesn't work
1151562024-05-29
6:48		2024-05-29
7:49		MySQL Server: CompilingVerified
(732 days)		S3mysql-trunk, 8.0AnyAnyPotential Nullptr Derefence in file `strings\ctype-ucs2.cc`
1151542024-05-29
5:40		2024-05-31
13:44		MySQL Server: CharsetsVerified
(730 days)		S28.0.37AnyAnyDynamic Changes to the character_set_% are not honored duing the handshake
1151462024-05-28
2:38		2024-05-29
12:55		MySQL Server: OptimizerVerified
(733 days)		S38.0AnyAnyInconsistent Results in SQL Query
1151272024-05-26
5:51		2024-05-27
12:35		MySQL Server: DMLVerified
(734 days)		S38.0AnyAnyinvalid result set with window function and generated rand value
1151232024-05-25
13:41		2024-05-25
15:49		MySQL Server: DMLVerified
(736 days)		S28.0AnyAnyInconsistent Results with DATE_ADD and BETWEEN Clause
1151222024-05-25
11:17		2024-06-16
9:10		MySQL Server: OptimizerVerified
(714 days)		S58.4 (Latest), 8.0.37Ubuntu (22.04 LTS)ARMUnneeded full table scan, although there is an index and condition
1151112024-05-24
7:33		2024-06-07
11:56		MySQL Server: DMLVerified
(737 days)		S38.4.0, 8.0.37AnyAnylast_insert_id evaluated twice if used nested
1150852024-05-22
20:39		2024-06-27
8:11		MySQL Server: DMLVerified
(738 days)		S28.0.34, 8.4.0Any (Docker Image)x86INDEX using CAST (json_column) AS ARRAY drops rows containing empty array
1150752024-05-22
3:49		2024-05-22
7:00		MySQL Server: OptimizerVerified
(739 days)		S38.0AnyAnyUnexpected subquery execution times
1150402024-05-16
12:09		2024-10-29
10:09		MySQL Server: OptimizerVerified
(745 days)		S38.0AnyAnyIncorrect result from lateral join with group by month/monthname function inside
1150172024-05-15
14:44		2024-07-01
11:21		MySQL Server: OptimizerVerified
(746 days)		S28.0AnyAnyWrong row estimate for range scan
1149702024-05-13
3:42		2024-05-13
6:04		MySQL Server: OptimizerVerified
(748 days)		S18.0.33AnyAnyprev_record_reads() use stale cardinality to calculate after plan enumeration
1149472024-05-09
23:54		2024-06-27
10:05		MySQL Server: DMLVerified
(751 days)		S38.0.37AnyAnyRight and Left functions do not work as documented within WHERE clauses
1149222024-05-08
9:25		2024-05-08
9:58		MySQL Server: OptimizerVerified
(753 days)		S18.0.36AnyAnyIncorrect query results caused by different data conversion
1149172024-05-08
2:52		2024-05-23
12:10		MySQL Server: OptimizerVerified
(748 days)		S38.0.35, 8.0.37, 8.4AnyAnyIncorrect query result
1148872024-05-05
9:20		2024-05-06
6:33		MySQL Server: OptimizerVerified
(755 days)		S18.2.0, 8.0.37AnyAnyIncorrect Muti-table join with group by execution
1148862024-05-05
9:16		2024-05-06
6:30		MySQL Server: OptimizerVerified
(755 days)		S18.2.0, 8.0.37AnyAnyIncorrect semi-join with group by execution
1148842024-05-05
9:03		2024-05-06
6:22		MySQL Server: OptimizerVerified
(755 days)		S28.2.0, 8.0.37AnyAnyIncorrect inner join with group by execution
1148122024-04-29
9:55		2024-04-29
10:19		MySQL Server: OptimizerVerified
(762 days)		S58.0.36,5.7.44AnyAnyin list values exceed eq_range_index_dive_limit cause index not used
1148072024-04-29
6:28		2024-04-30
3:06		MySQL Server: DMLVerified
(762 days)		S38.0.33AnyAnySubquery returns more than 1 row
1147952024-04-26
10:05		2024-04-29
9:56		MySQL Server: OptimizerVerified
(765 days)		S38.0AnyAnyArithmetic overflow when calculating the length of used fields involving blob
1147942024-04-26
9:36		2024-04-26
12:23		MySQL Server: OptimizerVerified
(765 days)		S38.0AnyAnyIncorrect query result
1147832024-04-25
11:32		2024-04-29
5:40		MySQL Server: OptimizerVerified
(762 days)		S2mysql-8.0.35, 8.0.36LinuxAnyBackward scan partition table with multi-valued Indexes may lost some result.
1147752024-04-25
6:35		2024-04-25
12:38		MySQL Server: DMLVerified
(766 days)		S38.0.35, 8.0.36Ubuntu (AWS RDS)x86Outer join condition filtering bug when using scalar subquery
1147622024-04-24
10:05		2024-04-25
14:23		MySQL Server: OptimizerVerified
(767 days)		S38.0AnyAnyinvalid result set with join lateral and group by on a generated field
1147512024-04-24
2:53		2024-04-24
7:24		MySQL Server: OptimizerVerified
(767 days)		S18.0.36AnyAnyIncorrect query result
1147412024-04-23
9:43		2024-04-23
13:36		MySQL Server: OptimizerVerified
(768 days)		S38.0AnyAnyInconsistent query results caused by different execution of subqueries
1147192024-04-21
14:31		2024-04-22
7:46		MySQL Server: OptimizerVerified
(769 days)		S18.0.36AnyAnyIncorrect results caused by different access types for an index
1147182024-04-21
12:09		2024-04-22
7:45		MySQL Server: DMLVerified
(769 days)		S18.0.36AnyAnyIncorrect query results
1147142024-04-20
3:54		2025-05-09
12:41		MySQL Server: OptimizerVerified
(769 days)		S38.0.33AnyAnyDuplicate subquery explain plan output when explain format is tree
1146822024-04-18
11:57		2024-04-18
13:49		MySQL Server: OptimizerVerified
(773 days)		S38.0AnyAnyDuplicate key error when executing query
1145992024-04-09
16:13		2024-12-04
10:41		MySQL Server: CompilingVerified
(543 days)		S38.0AnyAnyContribution: Fix: month\'s name Indonesia
1145812024-04-08
11:24		2024-04-08
12:37		MySQL Server: OptimizerVerified
(783 days)		S28.0.36AnyAny Constant-Folding optimization negative constant truncate gives wrong operator
1145682024-04-07
13:43		2024-04-08
7:28		MySQL Server: OptimizerVerified
(783 days)		S18.0.36AnyAnyDifferent join orders cause inconsistent results
1145592024-04-05
12:12		2024-04-08
9:26		MySQL Server: OptimizerVerified
(786 days)		S38.0AnyAnyUnexpected Results by the hint SUBQUERY(MATERIALIZATION)
1145392024-04-03
7:36		2024-04-03
8:14		MySQL Server: OptimizerVerified
(788 days)		S18.0.36AnyAnyUnexpected Results by the hint NO_INDEX
1145342024-04-03
4:22		2024-04-03
8:22		MySQL Server: DMLVerified
(788 days)		S38.0.36AnyAnyInconsistent result with index and symbol '̏
1145242024-04-01
12:36		2025-06-16
11:58		MySQL Server: OptimizerVerified
(789 days)		S38.3.0AnyAnyINSERT with JSON column error
1145122024-03-29
9:35		2024-06-17
9:54		MySQL Server: OptimizerVerified
(713 days)		S58.3.0, 8.0.36AnyAnyMySQL 8: Order by with hash join incredibly slow
1145102024-03-29
6:42		2024-03-29
7:29		MySQL Server: OptimizerVerified
(793 days)		S28.0.36Linuxx86Inconsistent results after dropping index on join column
1144622024-03-23
10:30		2024-04-04
9:20		MySQL Server: DMLVerified
(797 days)		S38.3.0, 8.0.36Ubuntu (Ubuntu 22.04)x86 (x86_64)Strange SQL_BUFFER_RESULT error
1144562024-03-22
14:54		2025-03-17
14:46		MySQL Server: CompilingVerified
(443 days)		S3AnyAnyContribution: Fix OpenSSL linking when only static libs are available
1144182024-03-19
23:20		2024-03-20
7:25		MySQL Server: DMLVerified
(802 days)		S28.0.36AnyAnyFlaw in SOUNDEX implementation causing incorrect results
1143842024-03-17
14:33		2024-03-18
6:57		MySQL Server: DMLVerified
(804 days)		S38.0.15,8.0.35, 8.0.36AnyAnyIncorrect query result may caused by LOG
1143832024-03-17
14:11		2024-03-20
11:19		MySQL Server: DMLVerified
(804 days)		S28.0.23,8.0.35AnyAnyIncorrect query result may caused by DATE and window function
1143822024-03-17
13:58		2024-03-20
11:20		MySQL Server: DMLVerified
(804 days)		S28.0.11, 8.0.35, 8.0.36AnyAnyIncorrect query result may caused by LOW_PRIORITY
1143812024-03-17
13:47		2024-03-20
11:21		MySQL Server: DMLVerified
(804 days)		S38.0.19,8.0.35AnyAnyIncorrect query result may caused by EXISTS and TIMEDIFF
1143802024-03-17
13:19		2024-03-20
11:21		MySQL Server: DMLVerified
(804 days)		S38.0.13, 8.0.35, 8.0.36AnyAnyIncorrect query result may caused by TIMESTAMP
1143792024-03-17
13:01		2024-03-20
11:22		MySQL Server: DMLVerified
(804 days)		S38.0.27, 8.0.35, 8.0.21AnyAnyIncorrect query result caused by index and optimizer
1143782024-03-17
12:44		2024-04-23
16:37		MySQL Server: DMLVerified
(804 days)		S38.0, 8.0.35AnyAnyIncorrect query result caused by CONVERT_TZ
1143732024-03-15
16:32		2024-03-20
11:03		MySQL Server: Data TypesVerified
(802 days)		S38.0AnyAnyIncorrect result after transformation from "IN (SELECT)" to "materialization"
1143382024-03-13
16:41		2024-03-19
11:10		MySQL Server: Prepared statementsVerified
(808 days)		S38.0AnyAnyClient might receive incorrect data in ps-protocol
1143332024-03-13
10:50		2024-03-13
16:33		MySQL Server: DMLVerified
(809 days)		S38.0AnyAnyLead/lag window functions returning BLOB instead of VARCHAR
1143122024-03-12
6:30		2024-03-19
2:26		MySQL Server: DMLVerified
(803 days)		S38.0AnyAnyItem_ref::used_tables wrong when ref to a rollup constant
1143012024-03-11
16:40		2024-03-12
16:23		MySQL Server: OptimizerVerified
(810 days)		S38.0AnyAnyIncorrect result with IS NULL predicate in join condition
1142912024-03-10
7:20		2024-06-27
10:05		MySQL Server: GISVerified
(812 days)		S38.2.0, 8.0.36AnyAnyST_Overlap gives an incorrect answer.
1142822024-03-08
13:10		2024-03-08
13:13		MySQL Server: DMLVerified
(814 days)		S28.35, 8.0.36AnyAnyInconsistent result may caused by group by NULL
1142702024-03-07
23:23		2024-03-08
4:11		MySQL Server: CompilingVerified
(814 days)		S38.0AnyAnyContribution: Fix operator name keywords causing obscure errors on -fno-ope ...
1142372024-03-06
6:57		2024-03-06
8:30		MySQL Server: OptimizerVerified
(816 days)		S58.2.0, 8.3.0AnyAnyUnexpected Cardinality by Index
1142182024-03-05
4:50		2024-03-05
7:01		MySQL Server: DMLVerified
(817 days)		S28.2.0, 8.3.0, 8.0.36AnyAnyUnexpected Results by MEMORY ENGINE
1142172024-03-05
4:48		2024-03-05
7:01		MySQL Server: DMLVerified
(817 days)		S28.2.0, 8.3.0, 8.0.36AnyAnyUnexpected Results by Minus Sign
1142042024-03-04
8:43		2024-03-04
8:58		MySQL Server: DMLVerified
(818 days)		S28.2.0, 8.3.0AnyAnyUnexpected Results by COALESCE
1141952024-03-02
15:24		2024-03-04
6:56		MySQL Server: CharsetsVerified
(818 days)		S38.0.36AnyAnymysql doesn't show what collation was used sometimes
1141492024-02-28
3:20		2024-02-28
5:54		MySQL Server: DMLVerified
(823 days)		S38.0+LinuxAnyIncorrect query result caused by where optimization
1140922024-02-22
23:40		2024-02-26
14:58		MySQL Server: OptimizerVerified
(827 days)		S5Ver 8.0.36-0Ubuntu (ubuntu 22.04.1)x86 (Linux on x86_64 ((Ubuntu)))WHERE statement on an indexed decimal column hangs
1140862024-02-21
19:41		2025-01-29
11:22		MySQL Server: CharsetsVerified
(825 days)		S38.0AnyAnyItem_singlerow_subselect::store may lead to memory corruption
1140272024-02-17
19:34		2024-02-19
6:29		MySQL Server: OptimizerVerified
(832 days)		S38.0.36 & 8.3.0Windows (10 & 11)ARM (x64)Plans for inner hash join show that wrong table is hashed
1139922024-02-14
14:11		2025-02-01
11:59		MySQL Server: CompilingVerified
(837 days)		S38.0AnyAnyContribution: Improved the way my_plugin_log_message() handles plugin_ptr a ...
1139492024-02-09
19:55		2024-02-12
9:16		MySQL Server: ParserVerified
(839 days)		S38.3.0, 8.0.36AnyAnyBackslash escaping inconsistency in LIKE operator
1138922024-02-05
10:39		2024-02-05
14:13		MySQL Server: OptimizerVerified
(846 days)		S38.0AnyAnyFORCE INDEX reports wrong number of rows
1138882024-02-04
3:38		2025-02-01
11:58		MySQL Server: GISVerified
(847 days)		S28.0Linuxx86st_contains function result is obviously wrong
1138432024-02-01
2:49		2024-02-01
8:09		MySQL Server: Prepared statementsVerified
(850 days)		S38.0.32, 8.0.36AnyAnyprepared json query can not use index
1138002024-01-30
5:30		2024-01-31
8:28		MySQL Server: DMLVerified
(851 days)		S58.0.22, 8.0.36, 8.0.11Linuxx86Performance degradation of Blob operations comparing with MySQL 5.7
1137682024-01-26
2:40		2024-01-26
8:53		MySQL Server: DMLVerified
(856 days)		S38.0.35LinuxAnyreturn error with cast
1137622024-01-25
17:05		2024-01-26
7:05		MySQL Server: DMLVerified
(856 days)		S38.0.36AnyAnyUnexpected results when using ASIN function with NULLIF
1137182024-01-23
4:42		2024-01-23
7:22		MySQL Server: OptimizerVerified
(859 days)		S28.0.35, 8.0.36, 8.3.0AnyAnyleft join + semijoin + materialization finds false matches
1136492024-01-16
10:17		2024-01-16
11:03		MySQL Server: DMLVerified
(866 days)		S38.0.31, 8.0.35AnyAnythe result of format function truncated when using cursor
1136412024-01-15
5:42		2024-01-15
5:50		MySQL Server: JSONVerified
(867 days)		S28.0.28AnyAnyMulti-valued index can lead to incorrect result with implicit conversion
1135872024-01-09
3:31		2024-02-27
12:25		MySQL Server: OptimizerVerified
(867 days)		S28.0AnyAnySELECT DISTINCT makes ORDER BY ... DESC sort data to ascending
1135862024-01-09
3:13		2024-01-09
12:27		MySQL Server: OptimizerVerified
(873 days)		S38.0AnyAnyIFNULL Incorrect query result
1135782024-01-08
13:06		2024-05-21
10:11		MySQL Server: DMLVerified
(872 days)		S35.7.44, 8.0.35AnyAnyAVG calculation bug
1135572024-01-04
15:29		2024-01-04
15:40		MySQL Server: JSONVerified
(878 days)		S28.0.35AnyAnyWrong query result on composite multi-valued index + empty array value
1135512024-01-04
10:04		2024-01-10
11:21		MySQL Server: OptimizerVerified
(872 days)		S38.2.0Linux (mysql docker image 8.2.0)AnyDiscrepancy in MySQL 8.2.0 Documentation Regarding Subquery Scoping Rules
1135412024-01-03
9:17		2024-01-03
10:07		MySQL Server: DMLVerified
(879 days)		S38.2.0AnyAnyRegexp validation failure on empty table
1135372024-01-02
16:00		2024-01-04
10:44		MySQL Server: CharsetsVerified
(878 days)		S38.0.32AnyAnyFalse match of multibyte chars when checking existence of a control character
1135342024-01-02
8:27		2024-01-05
2:27		MySQL Server: OptimizerVerified
(877 days)		S18.0.35AnyAnytable join return Unexpected result when drived table using include join index
1135132023-12-26
12:12		2023-12-27
5:20		MySQL Server: OptimizerVerified
(886 days)		S38.0.33AnyAnyJoin reordering regression and inconsistent behavior for SQL involving LEFT JOIN
1134622023-12-19
16:05		2023-12-20
15:06		MySQL Server: OptimizerVerified
(893 days)		S38.0AnyAnyIncorrect result
1134462023-12-18
2:32		2024-10-22
4:28		MySQL Server: DMLVerified
(895 days)		S38.0.33AnyAnyQuery with DISTINCT and ORDER BY on BIT data type returns wrong result
1134442023-12-16
16:23		2023-12-17
13:28		MySQL Server: CompilingVerified
(896 days)		S38.2.0CentOSx86Contribution by Tencent:-DBISON_EXECUTABLE may cause compile error
1134292023-12-14
21:13		2023-12-18
13:33		MySQL Server: DMLVerified
(895 days)		S58.0AnyAnyFunction call duplicated in CTE
1134262023-12-14
17:21		2023-12-15
7:35		MySQL Server: CompilingVerified
(898 days)		S3mysql-trunkOracle Linuxx86using -DWITH_INNODB_EXTRA_DEBUG results in compilation error
1134152023-12-14
6:27		2023-12-14
8:51		MySQL Server: DMLVerified
(899 days)		S38.0, 8.0.35AnyAnyUnknown column, but can get query result in CTE.
1133842023-12-09
8:05		2023-12-11
11:42		MySQL Server: Data TypesVerified
(902 days)		S38.0AnyAnyQueried with partitions,returned result is error
1133662023-12-08
1:39		2023-12-08
8:06		MySQL Server: DMLVerified
(905 days)		S38.0.35AnyAnyIncorrect query results involving the date type.
1133582023-12-07
7:09		2023-12-07
8:42		MySQL Server: OptimizerVerified
(906 days)		S38.0, 8.0.35AnyAnyWrong functional dependency in ONLY_FULL_GROUP_BY mode
1133202023-12-04
9:00		2023-12-04
11:30		MySQL Server: OptimizerVerified
(909 days)		S28.0AnyAny (DarwinMatt.local 22.5.0 Darwin Kernel Version 22.5.0: root:xnu-8796.121.2~5/RELEASE_ARM64_T6020 arm6)SELECT DISTINCT .. ORDER BY query yields wrong sort order
1133172023-12-04
5:29		2024-10-14
15:31		MySQL Server: DMLVerified
(909 days)		S18.0.35, 8.1.0, 8.2.0AnyAnyUnexpected Result by IF
1133162023-12-04
3:32		2023-12-04
7:21		MySQL Server: OptimizerVerified
(909 days)		S38.0.35, 8.1.0, 8.2.0AnyAnyWhen the bit type has an index, the query result is incorrect.
1133032023-12-01
7:29		2023-12-05
4:54		MySQL Server: OptimizerVerified
(912 days)		S58.0.35AnyAnyExplain plan takes forever when there are more joins
1133022023-12-01
7:29		2023-12-01
7:41		MySQL Server: DMLVerified
(912 days)		S18.2.0, 8.0.35AnyAnyUnexpected Result for an Index
1132982023-12-01
4:41		2023-12-01
4:55		MySQL Server: OptimizerVerified
(912 days)		S38.0.33, 8.1.0, 8.0.35AnyAnyUnexpected Results when Using IN for Floating-Point
1132882023-11-30
6:58		2023-12-01
11:37		MySQL Server: OptimizerVerified
(913 days)		S58.0.33AnyAnyExplain plan shows dynamic range, but bug causes no chance to use for LEFT JOIN
1132702023-11-29
0:18		2023-11-29
10:34		MySQL Server: CompilingVerified
(914 days)		S38.0.35AnyAnyUnable to compile 8.0.35 with DISABLE_PSI_THREAD
1132112023-11-24
12:14		2023-11-24
12:34		MySQL Server: OptimizerVerified
(919 days)		S28.0.35, 8.1.0, 8.2.0AnyAnyThe latest version 8.0 returns abnormal results for complex queries
1132052023-11-24
3:06		2023-11-24
6:01		MySQL Server: GISVerified
(919 days)		S38.2.0, 8.0.35AnyAnyAfter swapping the X and Y coordinates, ST_Crosses gives the incorrect answer.
1131802023-11-22
10:12		2023-11-23
8:46		MySQL Server: DMLVerified
(921 days)		S38.0.33, 8.1.0, 8.0.35AnyAnyUnexpected Results when Using Math Function SIN
1131672023-11-21
14:17		2023-11-22
7:24		MySQL Server: GISVerified
(921 days)		S28.2.0, 8.0.35AnyAnyAfter creating the spatial index, ST_Disjoint gives the incorrect answer
1131542023-11-20
21:57		2023-11-21
6:25		MySQL Server: DMLVerified
(922 days)		S28.2.0, 8.1.0, 8.0.35LinuxAnyJoin using ROW_NUMBER() returns incorrect records
1131352023-11-20
3:03		2023-11-20
15:34		MySQL Server: DMLVerified
(923 days)		S38.0AnyAnyDISTINCT JOIN ORDER BY statements ignore ORDER BY when tmp_table_size is small
1131132023-11-16
20:26		2025-10-28
10:13		MySQL Server: CompilingVerified
(215 days)		S38.0.41MacOSAnyBuild failure with Homebrew LLVM 14-19 on macOS
1130602023-11-13
10:23		2025-03-16
20:45		MySQL Server: DMLVerified
(930 days)		S38.0AnyAnyThe result of avg(distinct xx）is different between from primary and secondary
1130592023-11-13
8:29		2023-11-13
9:51		MySQL Server: OptimizerVerified
(930 days)		S28.2.0AnyAnyInconsistent results when using DUPSWEEDOUT
1130492023-11-10
15:28		2024-01-17
16:27		MySQL Server: JSONVerified
(865 days)		S28.0.35, 8.2.0AnyAnyMTR test json.array_index fails with a result difference
1130452023-11-10
14:54		2024-05-24
10:12		MySQL Server: CompilingVerified
(737 days)		S38.0LinuxAny (x86_64，arm64)Build failure with Protobuf 24.2 in Linux
1130152023-11-09
3:25		2023-11-14
7:35		MySQL Server: DMLVerified
(934 days)		S38.0.35AnyAnyREGEXP curly brackets without escape character works on 5.7 but not in 8.0
1129852023-11-07
8:33		2023-11-08
10:54		MySQL Server: OptimizerVerified
(936 days)		S38.0, 8.1, 8.2AnyAnyInconsistent results when switching hash join optimization
1129142023-11-01
9:43		2023-11-01
15:02		MySQL Server: OptimizerVerified
(942 days)		S38.0AnyAnydifferent result related to zerofill and greatest()
1129122023-11-01
8:45		2023-11-01
14:47		MySQL Server: OptimizerVerified
(942 days)		S38.0AnyAnyParsing a string To BIT type got a wrong result
1129112023-11-01
8:21		2023-11-01
8:56		MySQL Server: OptimizerVerified
(942 days)		S28.1.0, 8.0.35AnyAnyInconsistent results when using PRIMARY and DUPSWEEDOUT
1129102023-11-01
7:20		2023-11-01
7:31		MySQL Server: OptimizerVerified
(942 days)		S28.1.0, 8.0.35AnyAnyIncorrect results when add an uncorrelated row
1129022023-10-31
14:39		2024-06-10
11:08		MySQL Server: OptimizerVerified
(825 days)		S58.0.31, 8.0.35Linux (n.a.)x86 (x86_64)Optimizer in MySQL 8 is significantly slower on dependent subqueries than 5.7
1128532023-10-27
8:32		2023-12-18
2:17		MySQL Server: DMLVerified
(895 days)		S38.0AnyAnyWrong functional dependency in ONLY_FULL_GROUP_BY mode
1128522023-10-27
7:42		2023-11-06
11:25		MySQL Server: DMLVerified
(937 days)		S38.0Linuxx86insert and insert onduplicate are executed concurrently, data update error
1128482023-10-27
2:28		2023-10-27
11:37		MySQL Server: Data TypesVerified
(947 days)		S38.0AnyAnyItem_func_set_user_var::get_string_value may have potion risk of memory access
1128262023-10-25
7:47		2023-10-25
8:27		MySQL Server: DMLVerified
(949 days)		S38.1.0, 8.0.34Ubuntu (22.04)x86 (x86_64)Decimal query with wrong result
1128162023-10-24
16:15		2023-12-13
12:00		MySQL Server: OptimizerVerified
(940 days)		S28.0, 8.1AnyAnyInconsistent results when JOINed in different order
1128022023-10-23
8:23		2023-10-27
9:46		MySQL Server: OptimizerVerified
(951 days)		S38.1.0, 8.0.34AnyAnyInconsistent results when using INDEX
1127292023-10-15
11:20		2023-10-16
6:13		MySQL Server: ParserVerified
(958 days)		S38.1.0AnyAnyTwo single quotes escaping inconsistency in index expression
1127282023-10-15
9:51		2023-10-18
15:43		MySQL Server: OptimizerVerified
(956 days)		S38.0AnyAnyMySQL optimizer generated an incorrect execution plan
1127042023-10-12
12:19		2026-04-28
7:32		MySQL Server: OptimizerVerified
(178 days)		S28.0, 8.4.7AnyAnyCTE query got internal table doesn't exist error with small tmp_table_size
1127032023-10-12
12:13		2025-08-25
7:23		MySQL Server: Prepared statementsVerified
(962 days)		S3AnyAnyprepare statment has no warning comping to not prepare statment.
1126472023-10-06
9:28		2023-10-09
6:56		MySQL Server: CompilingVerified
(965 days)		S38.0.34,8.1.0AnyAnyclang-format 17 errors out on .clang-format
1126422023-10-05
18:40		2023-10-09
10:17		MySQL Server: OptimizerVerified
(967 days)		S38.0AnyAnyWrong results when MRR is activated
1125972023-10-03
12:14		2023-10-05
14:13		MySQL Server: OptimizerVerified
(969 days)		S58.0AnyAnySlow performance
1125792023-09-30
8:37		2023-10-02
9:16		MySQL Server: DMLVerified
(972 days)		S28.0.14 - 8.0.34AnyAnyInconsistent results of SELECT with <=> and NULLIF
1125722023-09-29
9:44		2023-09-29
12:27		MySQL Server: OptimizerVerified
(975 days)		S38.0AnyAnyInconsistent results of SELECT statement with HEX, REVERSE, and RPAD functions
1125432023-09-27
19:23		2023-10-03
12:05		MySQL Server: OptimizerVerified
(971 days)		S38.0AnyAnyQuery rewrite plugin can't be used to parse and change reserved words
1125272023-09-26
14:46		2023-09-27
7:25		MySQL Server: DMLVerified
(977 days)		S28.0.11, 8.0.34, 8.1.0AnyAnyInconsistent results caused by REPEAT function
1125242023-09-26
13:32		2023-09-27
7:52		MySQL Server: DMLVerified
(977 days)		S25.7, 8.0.0, 8.0.34AnyAnyInconsistent results of UNIX_TIMESTAMP with NULLIF and COALESCE
1124512023-09-25
6:35		2023-09-25
7:37		MySQL Server: OptimizerVerified
(979 days)		S38.0,8.1AnyAnyIncorrect result if there are non-deterministic expressions in in-subquery
1124502023-09-25
6:25		2023-09-25
7:45		MySQL Server: OptimizerVerified
(979 days)		S38.0.28AnyAnyIncorrect result
1124222023-09-22
1:54		2023-09-25
11:49		MySQL Server: OptimizerVerified
(979 days)		S38.0AnyAnyThe outer select group_concat(NULL) return an empty string
1123942023-09-20
13:13		2023-09-21
12:16		MySQL Server: OptimizerVerified
(983 days)		S38.0AnyAnyInconsistent results caused by subqueries in FROM and EXISTS
1123772023-09-18
23:01		2023-09-19
12:24		MySQL Server: OptimizerVerified
(985 days)		S38.0AnyAnyAssert in AccessPath::index_merge()
1123462023-09-14
8:21		2023-10-11
7:24		MySQL Server: JSONVerified
(963 days)		S58.0.34AnyAnyMEMBER_OF with multi-valued index on JSON not used in 99% of situations.
1123452023-09-14
7:53		2025-05-13
3:07		MySQL Server: OptimizerVerified
(383 days)		S28.0.34AnyAnyContribute by tencent: Repeated subquery plans were printed in format=tree.
1122932023-09-07
14:04		2023-09-08
6:54		MySQL Server: DMLVerified
(996 days)		S38.0, 8.0.34, 5.7.43AnyAnyWrong result if non-breaking space is contained in varchar
1122802023-09-06
20:38		2023-09-07
4:27		MySQL Server: OptimizerVerified
(997 days)		S38.0.34AnyAnyIncorrect costing of group by loose index scans
1122692023-09-06
2:51		2023-09-06
4:52		MySQL Server: OptimizerVerified
(998 days)		S28.1.0, 8.0.34AnyAnyUnexpected Results by the hint JOIN_ORDER
1122642023-09-05
11:47		2023-09-05
12:15		MySQL Server: OptimizerVerified
(999 days)		S28.1.0AnyAnyUnexpected Result by block_nested_loop
1122592023-09-05
9:44		2023-09-05
10:21		MySQL Server: CompilingVerified
(999 days)		S38.0.33AnyAnyAssert when debug_sync_timeout is 0
1122432023-09-04
4:54		2023-09-21
7:13		MySQL Server: OptimizerVerified
(1000 days)		S38.0.34AnyAnyUnexpected Result by subquery_to_derived
1122422023-09-04
4:40		2023-09-04
8:34		MySQL Server: OptimizerVerified
(1000 days)		S28.1.0, 8.0.34AnyAnyUnexpected Results by use_invisible_indexes
1122382023-09-01
16:08		2023-09-11
11:28		MySQL Server: DMLVerified
(1000 days)		S25.5, 5.6, 5.7.43, 8.0.34AnyAnyInconsistent results caused by FIELD()
1122122023-08-29
16:01		2023-08-30
7:42		MySQL Server: OptimizerVerified
(1005 days)		S38.0.34AnyAnySubquery to derived result mismatch(HASH JOIN/BNL JOIN result mismatch)
1121982023-08-28
8:21		2024-03-05
6:06		MySQL Server: OptimizerVerified
(1007 days)		S18.0, 8.0.34AnyAnyIncorrect multiple equality optimization causes performance degradation
1121942023-08-28
5:31		2023-09-06
9:03		MySQL Server: DMLVerified
(998 days)		S38.0.34Red HatAnyIncorrect result when using INNER JOIN with SELECT FROM VIEW together with OR co
1121922023-08-28
2:55		2023-08-30
11:05		MySQL Server: OptimizerVerified
(1005 days)		S58.0.28AnyAnyIn MySQL 8.0, one queries need 1000 times more data than MySQL 5.7
1121912023-08-28
2:52		2023-08-29
9:45		MySQL Server: CompilingVerified
(1006 days)		S38.0.31AnyAnyWhen we compile MySQL 8.0 with DEBUG, we have some warning of memory leak
1121752023-08-24
13:32		2025-07-24
7:07		MySQL Server: CompilingVerified
(311 days)		S38.0AnyAnyContribution: [performance optimization]
1121692023-08-23
15:41		2023-08-24
13:51		MySQL Server: OptimizerVerified
(1011 days)		S35.7AnyAnyUsing LOWER in HAVING clause falsifies result of GROUP_CONCAT
1121492023-08-23
4:09		2023-08-23
8:15		MySQL Server: DMLVerified
(1012 days)		S28.0.34, 5.7.43, 5.6, 5.5AnyAnyInconsistent results caused by SPACE() function and ''||'' operations
1121472023-08-23
2:58		2023-08-24
7:31		MySQL Server: JSONVerified
(1012 days)		S38.0.34AnyAnyUse/Ignore Mutil-value index for MEMBER OF function has differnet result
1121242023-08-21
15:10		2023-08-22
13:00		MySQL Server: DMLVerified
(1013 days)		S38.0AnyAnySometimes , ROW_COUNT() return wrong answer, which cause by index.
1121052023-08-18
2:51		2023-08-18
9:21		MySQL Server: Prepared statementsVerified
(1017 days)		S38.1.0, 8.0.34Ubuntu (22.04)x86 (x86_64)Create table from prepared statement issues
1120532023-08-12
19:55		2023-08-21
12:36		MySQL Server: JSONVerified
(1019 days)		S38.0AnyAnyCOALESCE a null value with a JSON object returns hex string
1120372023-08-11
3:45		2023-08-25
6:44		MySQL Server: OptimizerVerified
(1024 days)		S38.0.32, 8.0.34AnyAnyContribute by tencent: explain analyze show never executed for materialize
1120222023-08-10
1:56		2023-08-10
7:38		MySQL Server: CompilingVerified
(1025 days)		S38.0.34CentOS (CentOS Linux 7)x86Compiling with -DWITH_DEBUG=1 and using C++17 resulted in a failure.
1120112023-08-09
12:06		2023-08-17
12:21		MySQL Server: Prepared statementsVerified
(1025 days)		S38.0AnyAnyRESOURCE GROUP hint fails when used within a prepared statement
1120082023-08-09
10:41		2023-08-09
11:53		MySQL Server: CompilingVerified
(1026 days)		S38.0.34, 8.1.0AnyAnyUnused macro DBUG_EVALUATE
1119912023-08-08
3:25		2023-08-10
5:53		MySQL Server: OptimizerVerified
(1025 days)		S28.0.32,8.1.0AnyAnyindex merge sometimes return incorrect result
1119522023-08-02
19:50		2026-03-02
20:31		MySQL Server: OptimizerVerified
(90 days)		S28.0, 8.0.34, 8.0.45, 5.7.43, 8.1.0, 8.4, 8.4.8AnyAnyRow constructor inequality comparison on Primary Key results in full table scan.
1119212023-07-31
7:57		2023-08-11
12:14		MySQL Server: Prepared statementsVerified
(1034 days)		S38.0AnyAnyReusing prepared statement for different data types, different outcomes are obse
1119182023-07-30
6:12		2023-07-31
6:33		MySQL Server: OptimizerVerified
(1035 days)		S38.1.0, 8.0.34, 5.7.43Ubuntu (22.04)x86 (x86_64)Auto increment column query wrong result
1119172023-07-30
5:35		2023-07-31
6:31		MySQL Server: OptimizerVerified
(1035 days)		S38.1.0, 8.0.34Ubuntu (22.04)x86 (x86_64)derived condition pushdown query with wrong result
1118922023-07-26
6:52		2023-11-13
10:14		MySQL Server: ParserVerified
(1039 days)		S38.1AnyAnyTwo single quotes escaping inconsistency
1118522023-07-23
12:46		2023-07-27
1:15		MySQL Server: OptimizerVerified
(1042 days)		S38.0.30, 8.0.34AnyAnyAn incorrect number of records is returned
1118512023-07-22
22:59		2023-07-26
6:55		MySQL Server: GISVerified
(1040 days)		S28.0.32, 8.0.34, 5.7.43Any (Linux & Mac)Any (x86 & ARM)Spatial index not used for join when field is used in MBRIntersects call
1118502023-07-21
23:40		2023-07-24
8:19		MySQL Server: CompilingVerified
(1044 days)		S38.0AnyAnyContribution: Architecture-agnostic fix for crashes caused by cache coheren ...
1118382023-07-21
10:51		2023-07-21
11:31		MySQL Server: JSONVerified
(1045 days)		S38.10AnyAnyEvaluate JSON column default on table/column creation
1117392023-07-13
4:50		2023-07-13
9:32		MySQL Server: DMLVerified
(1053 days)		S38.0.33AnyAnyThe query results are inconsistent.
1117282023-07-12
8:08		2023-07-12
8:42		MySQL Server: OptimizerVerified
(1054 days)		S28.0.28, 8.0.33AnyAnyIncorrect result
1117062023-07-10
8:24		2025-03-17
9:33		MySQL Server: OptimizerVerified
(1056 days)		S38.0.28, 8.0.33AnyAnyIncorrect result
1117002023-07-09
7:31		2023-07-12
5:55		MySQL Server: OptimizerVerified
(1054 days)		S38.0.32, 8.0.33AnyAnyLIMIT values are not adequately handled in EXPLAIN.
1116992023-07-09
3:46		2023-07-10
5:51		MySQL Server: OptimizerVerified
(1056 days)		S38.0.28, 8.0.33AnyAnyIncorrect results
1116812023-07-06
13:47		2023-10-23
10:29		MySQL Server: OptimizerVerified
(1054 days)		S38.0LinuxAnyEXISTS query results in duplicate rows
1116692023-07-06
0:47		2023-07-12
13:04		MySQL Server: OptimizerVerified
(1054 days)		S58.0.33AnyAnySimple Query Times Out
1116592023-07-04
15:46		2023-07-05
13:28		MySQL Server: OptimizerVerified
(1061 days)		S28.0AnyAnyEmpty result of SELECT only when bigger LIMIT
1116072023-06-28
14:26		2023-07-12
9:03		MySQL Server: CompilingVerified
(1056 days)		S38.0AnyAnyContribution: Fix linkage of \'gen_keyword_list\' executable
1115602023-06-26
9:33		2023-06-26
13:53		MySQL Server: Prepared statementsVerified
(1070 days)		S38.0AnyAnyA Prepare statement with cursor on will hang when executed after cursor closed
1115592023-06-26
9:10		2026-03-20
12:36		MySQL Server: OptimizerVerified
(1070 days)		S38.0.33Ubuntu (22.04)x86 (x86_64)View with CTE syntax error
1115112023-06-21
8:38		2024-04-12
15:00		MySQL Server: OptimizerVerified
(1075 days)		S38.0.33Ubuntu (22.04)x86 (x86_64)CTE missing scope in set queries
1115082023-06-21
7:06		2023-06-21
8:24		MySQL Server: OptimizerVerified
(1075 days)		S38.0.33AnyAnyThe query results are inconsistent when different optimizer options are used.
1114932023-06-20
8:25		2023-06-20
13:01		MySQL Server: OptimizerVerified
(1076 days)		S38.0AnyAnysql return wrong results
1114852023-06-19
11:16		2023-06-19
11:40		MySQL Server: OptimizerVerified
(1077 days)		S3mysql-8.0.33Linuxx86When subquery_to_derived is on, IN-subq to derived table transformed wrongly
1114842023-06-19
8:49		2023-06-19
9:10		MySQL Server: OptimizerVerified
(1077 days)		S3mysql-8.0.33Linuxx86wrong result when rewriting scalar subquery in json function parameters
1114792023-06-19
4:24		2023-06-19
11:42		MySQL Server: OptimizerVerified
(1077 days)		S35.7.42AnyAnyOptimizer estimated rows is always equal to 1 when using spatial index.
1114712023-06-17
14:28		2023-06-18
13:26		MySQL Server: OptimizerVerified
(1078 days)		S28.0.33Ubuntux86Unexpected Error: Memory capacity exceeded
1114662023-06-16
19:18		2025-05-09
12:30		MySQL Server: OptimizerVerified
(1079 days)		S35.7AnyAnyContribution: Disable index hints on spatial indices
1114542023-06-16
2:24		2023-06-19
8:37		MySQL Server: OptimizerVerified
(1077 days)		S38.0.33AnyAnyselect query with json and time column has different results
1114532023-06-16
0:54		2023-06-19
10:09		MySQL Server: OptimizerVerified
(1077 days)		S28.0.33AnyAnysql query with "where time_col not between val1 and null' has diffrent results
1114322023-06-15
8:56		2023-06-16
13:42		MySQL Server: CompilingVerified
(1080 days)		S3mysql-8.0.33 Ubuntu (22.04.2)x86c++ Undefined Behavior with clang-16
1114312023-06-15
8:47		2023-06-26
14:48		MySQL Server: OptimizerVerified
(1081 days)		S38.0.33Ubuntu (22.04)Other (x86_64)condition_fanout_filter optimizer wrong result?
1114292023-06-15
6:44		2023-06-21
14:02		MySQL Server: OptimizerVerified
(1081 days)		S38.0.22, 8.0.33AnyAnyIncorrect result when timestamp col apply <=> to the result of subquery
1114182023-06-14
11:43		2023-06-15
14:04		MySQL Server: OptimizerVerified
(1081 days)		S38.0AnyAnySubquery with ROLLUP gives wrong result
1114152023-06-14
9:39		2023-06-19
14:12		MySQL Server: OptimizerVerified
(1077 days)		S38.0AnyAnyCorrelated group query wrong result
1113972023-06-13
13:32		2023-06-14
8:30		MySQL Server: OptimizerVerified
(1083 days)		S38.0AnyAny表达式进行<=>比较并将结果进行与操作，执行结果错误
1113672023-06-12
15:36		2026-03-02
20:23		MySQL Server: OptimizerVerified
(90 days)		S58.0, 8.0.45, 8.4, 8.4.8AnyAnyOFFSET 99 LIMIT 1 on a compound PK takes ages to execute.
1113582023-06-12
8:41		2023-06-14
11:35		MySQL Server: DMLVerified
(1083 days)		S38.0AnyAnydelete handl error
1113182023-06-07
14:36		2023-06-07
14:55		MySQL Server: OptimizerVerified
(1089 days)		S38.0AnyAnyblock_nested_loop optimizer wrong result?
1113102023-06-07
6:51		2023-06-08
8:30		MySQL Server: Prepared statementsVerified
(1088 days)		S38.0.33Ubuntu (22.04)x86 (x86_64)Prepared statement with CTE memory leak
1113042023-06-06
21:15		2023-06-08
4:00		MySQL Server: OptimizerVerified
(1088 days)		S28.0.33, 5.7.42AnyAnyThe Query Rewrite Plugin mixes-up LIMIT and OFFSET.
1112722023-06-05
8:47		2023-06-05
8:51		MySQL Server: OptimizerVerified
(1091 days)		S28.0.32, 8.0.33AnyAnyInconsistent behaviors on string comparison with/without index
1112682023-06-04
17:21		2023-06-06
11:00		MySQL Server: CharsetsVerified
(1091 days)		S38.0.25, 8.0.33AnyAnyDifferent character_set_connection returns inconsistent results
1112412023-06-01
11:39		2023-06-01
13:57		MySQL Server: DMLVerified
(1095 days)		S3Last commit version in github https://giAnyAnyWrong result of `IN` clause
1112152023-05-31
9:58		2023-06-02
11:53		MySQL Server: DMLVerified
(1094 days)		S38.0AnyAnyQuery in transaction may return rows with same unique key column value
1112122023-05-31
8:30		2023-06-16
12:52		MySQL Server: CompilingVerified
(1080 days)		S28.0.30, 8.0.33Debian (10)Any (x86 and arm)compile failed with gcc-10 when lto is enable
1111952023-05-30
7:34		2024-04-10
6:59		MySQL Server: OptimizerVerified
(1097 days)		S38.0AnyAnyThere is a logical error in source code
1111832023-05-29
9:46		2023-05-29
13:21		MySQL Server: DMLVerified
(1098 days)		S35.7AnyAnyWhen use ON DUPLICATE UPDATE syntax, TIMESTAMP in primary key, get wrong answer
1111592023-05-26
6:02		2023-11-06
11:17		MySQL Server: CompilingVerified
(939 days)		S38.0CentOSAnyIncomplete documentation on MySQL rpm rebuilds makes rebuilding packages hard
1110972023-05-22
6:40		2024-04-10
9:51		MySQL Server: OptimizerVerified
(1105 days)		S18031, 5.7.42, 8.0.33, 8.0.36Linuxx86Query statement results with subqueries are unstable
1110942023-05-21
2:25		2024-04-10
9:55		MySQL Server: OptimizerVerified
(1105 days)		S38.0.33, 8.0.36Ubuntu (8.0.33-0ubuntu0.20.04.2)x86Results ordered incorrectly
1110722023-05-18
10:12		2024-04-10
10:04		MySQL Server: JSONVerified
(1108 days)		S38.0.33, 5.7.42, 8.0.36AnyAnyThe subquery involves JSON, and the execution result is incorrect.
1110672023-05-18
8:05		2023-05-19
12:55		MySQL Server: OptimizerVerified
(1109 days)		S28.0.25, 8.0.33AnyAnyQuery result error
1110372023-05-15
21:34		2023-05-16
12:57		MySQL Server: OptimizerVerified
(1111 days)		S58.0AnyAnyMySQL not selecting or not using the index optimally for query
1110252023-05-13
18:22		2023-05-15
10:24		MySQL Server: OptimizerVerified
(1112 days)		S38.0.33AnyAnyDifferent cost with index hint for same plan
1110112023-05-12
3:16		2023-05-15
10:27		MySQL Server: CompilingVerified
(1112 days)		S38.0.33AnyAny`mysql_config --libs` returns broken zlib reference
1110072023-05-11
20:30		2023-05-12
13:09		MySQL Server: OptimizerVerified
(1115 days)		S38.0AnyAnyIncorrect rows estimate
1109982023-05-11
15:33		2023-12-01
6:49		MySQL Server: OptimizerVerified
(1110 days)		S58.0.20+, 8.0.33LinuxAnyPerformance regression with SELECT query when sorting on limited fields
1109882023-05-11
8:06		2023-07-10
13:11		MySQL Server: OptimizerVerified
(1056 days)		S38.0.33Ubuntu (22.04)x86 (x86_64)VIEW call error
1109712023-05-10
3:21		2023-05-10
8:00		MySQL Server: OptimizerVerified
(1117 days)		S58.0.33AnyAnyOptimizer: reverse index scan doesn't affect the cost
1109692023-05-09
23:33		2023-05-10
8:01		MySQL Server: OptimizerVerified
(1117 days)		S38.0.33AnyAnyFunctional indexes aren't covering
1109312023-05-05
11:22		2023-05-05
12:16		MySQL Server: OptimizerVerified
(1122 days)		S38.0.33MacOSAnyOptimizer Trace contradicts to EXPLAIN contradicts to SHOW STATUS
1109152023-05-04
16:28		2023-05-18
13:10		MySQL Server: OptimizerVerified
(1122 days)		S38.0.33AnyAnyHaving clause missing scope
1108482023-04-27
15:04		2023-05-03
9:59		MySQL Server: OptimizerVerified
(1124 days)		S58.0.28, 8.0.33AnyAnymissing considering on order by and limit clause in cost calculation
1108252023-04-26
23:58		2023-04-27
8:29		MySQL Server: CharsetsVerified
(1130 days)		S38.0.32AnyAnyExplicit COLLATE clause output in SHOW CREATE TABLE incorrectly
1108192023-04-26
15:11		2023-05-08
22:48		MySQL Server: OptimizerVerified
(1130 days)		S28.0.16+, 8.0.33AnyAnyEXISTS with dependent subquery can return incorrect results
1107792023-04-24
11:32		2023-05-12
5:49		MySQL Server: OptimizerVerified
(1115 days)		S58.0.33, 5.7.42AnyAnyIN clause cause pick bad performan index
1106562023-04-11
16:02		2024-01-26
9:27		MySQL Server: OptimizerVerified
(856 days)		S38.0.32Ubuntu (22.04)x86 (x86_64)Join query with wrong result
1106142023-04-05
8:32		2023-04-05
13:48		MySQL Server: OptimizerVerified
(1152 days)		S38.0AnyAnyLeft join query with wrong result
1105972023-04-04
4:20		2023-04-12
14:05		MySQL Server: OptimizerVerified
(1153 days)		S28.0.32MacOS (12.4)AnyDifferent results from equivalent queries
1105872023-04-03
7:51		2023-04-03
9:37		MySQL Server: OptimizerVerified
(1154 days)		S18.0.27, 8.0.32, 5.7.41AnyAnyBit with index range query may produce different results
1105792023-03-31
15:10		2023-04-05
12:34		MySQL Server: OptimizerVerified
(1157 days)		S38.0.32, 5.7.41Ubuntu (22.04)x86 (x86_64)Right join query with BETWEEN wrong result
1105632023-03-30
8:21		2023-03-30
8:48		MySQL Server: OptimizerVerified
(1158 days)		S38.0.32Ubuntu (22.04)x86 (x86_64)NULL safe equality operator query with wrong result
1105622023-03-30
8:05		2023-04-18
21:01		MySQL Server: ParserVerified
(1143 days)		S28.0.32Windows (11)x86 (64bit)values statement
1105562023-03-30
2:46		2026-03-25
20:22		MySQL Server: JSONVerified
(1158 days)		S28.0.28, 8.0.32LinuxAnyWhen we use json to build an index, we will get wrong results
1104882023-03-24
7:52		2023-03-24
9:17		MySQL Server: ParserVerified
(1164 days)		S3all, 8.0CentOS (7.x)x86 (64bit)pound sign can not included in qb_name hint
1104872023-03-24
6:09		2023-03-24
9:20		MySQL Server: JSONVerified
(1164 days)		S35.7,8.0.32AnyAnyjson array field ignored in multi sort.
1104742023-03-22
23:09		2023-03-27
7:02		MySQL Server: OptimizerVerified
(1161 days)		S58.0, 8.0.32AnyAnyFunctional Index is not work like generated column and index
1104592023-03-22
8:09		2023-06-07
8:51		MySQL Server: OptimizerVerified
(1089 days)		S38.0.32Ubuntu (22.04)x86 (x86_64)Derive_merge optimizer missing error
1104452023-03-21
3:11		2023-03-21
6:32		MySQL Server: OptimizerVerified
(1167 days)		S58.0LinuxARM (aarch64)Optimize my_convert for Arm64
1104062023-03-17
4:58		2023-03-20
14:08		MySQL Server: OptimizerVerified
(1168 days)		S38.0AnyAnyStoring rows with null in join key in hash table for outer join is useless
1103562023-03-14
8:39		2023-03-14
9:37		MySQL Server: OptimizerVerified
(1174 days)		S35.7, 8.0AnyAnythe presence of case when cause inconsistant columns mapping in order by
1103552023-03-14
7:40		2023-03-14
9:21		MySQL Server: CompilingVerified
(1174 days)		S3Ver 8.0AnyAnycompiling source code error when cmake with -DWITH_JEMALLOC=true
1103542023-03-14
7:37		2023-03-14
9:51		MySQL Server: OptimizerVerified
(1174 days)		S28.0.32, 5.7.41CentOSAnySELECT Query choose different index return different results
1103322023-03-10
7:16		2023-03-10
8:38		MySQL Server: OptimizerVerified
(1178 days)		S28.0.32, 5.7.41AnyAnyDifferent result when using a user variable
1103222023-03-09
11:41		2023-03-09
12:31		MySQL Server: OptimizerVerified
(1179 days)		S38.0.32Ubuntu (22.04)x86 (x86_64)Binary column primary key query with wrong result
1103102023-03-09
8:41		2023-04-29
15:24		MySQL Server: OptimizerVerified
(1179 days)		S38.0.32Ubuntu (22.04)x86 (x86_64)BETWEEN query with wrong result
1103062023-03-08
22:08		2023-03-09
6:47		MySQL Server: OptimizerVerified
(1179 days)		S38.0.32AnyAnyIncorrect costing in test_if_cheaper_ordering
1103012023-03-08
11:13		2023-03-09
12:30		MySQL Server: OptimizerVerified
(1179 days)		S38.0.32Ubuntu (22.04)x86 (x86_64)Change column wrong result
1102912023-03-07
10:57		2023-03-07
13:17		MySQL Server: CharsetsVerified
(1181 days)		S38.0, 5.7AnyAnySHOW CREATE TABLE breaks DEFAULT for 4 byte Unicode characters
1102502023-03-01
11:59		2023-03-24
11:16		MySQL Server: OptimizerVerified
(1181 days)		S38.0.32Ubuntu (22.04)x86 (x86_64)Right join query with wrong result
1102442023-03-01
3:46		2023-03-01
6:30		MySQL Server: OptimizerVerified
(1187 days)		S28.0.32AnyAnyNesting queries in a projection results in different output
1102262023-02-27
18:39		2023-02-28
6:46		MySQL Server: CompilingVerified
(1188 days)		S38.0.31AnyAnyBuild fails when CMAKE_CXX_FLAGS_RELEASE is set because -DNDEBUG isn't set
1102172023-02-27
6:16		2023-02-28
17:01		MySQL Server: CompilingVerified
(1188 days)		S38.0.32DebianAnyfailed to compile in mysql_release mode
1102092023-02-24
16:01		2023-02-28
15:17		MySQL Server: DMLVerified
(1188 days)		S38.0AnyAnyPRIMARY KEY should not change the query result.
1101742023-02-23
3:13		2023-06-07
15:17		MySQL Server: CompilingVerified
(1193 days)		S35.7,8.0AnyAnyRe-run cmake may occur even though nothing is modified.
1101632023-02-22
7:22		2023-02-22
8:03		MySQL Server: CompilingVerified
(1194 days)		S58.0LinuxAnyIPTOS_THROUGHPUT enabling code is bypassed on Linux
1101562023-02-21
14:24		2023-02-22
15:18		MySQL Server: OptimizerVerified
(1195 days)		S38.0AnyAnyIncorrect query results caused by subqueries and JOIN
1101252023-02-19
8:48		2023-02-20
5:04		MySQL Server: OptimizerVerified
(1196 days)		S18.0.32, 5.7UbuntuAnyUnexpected query result fetched from an indexed column
1101112023-02-17
12:53		2023-02-20
12:35		MySQL Server: OptimizerVerified
(1196 days)		S58.0.31AnyAnyOptimizer chooses worst plan when index condition pushdown opportunity
1100172023-02-10
6:27		2023-02-16
4:47		MySQL Server: OptimizerVerified
(1206 days)		S35.7.41UbuntuAnySELECT returns incorrect value when ORDER BY a CASE WHEN value in left-joined su
1100152023-02-10
3:06		2023-11-20
11:24		MySQL Server: OptimizerVerified
(1203 days)		S58.0.32Windows (11)x86Multi-valued index on JSON array is not used when used in a join
1100032023-02-09
10:37		2023-02-13
12:29		MySQL Server: DMLVerified
(1207 days)		S38.0.32, 5.7, 5.6AnyAnyDELETE query does ot work for BIT columns
1099752023-02-08
1:19		2023-02-08
8:32		MySQL Server: DMLVerified
(1208 days)		S35.7, 8.0AnyAnyunique key cause wrong result
1098972023-02-02
10:08		2023-02-02
11:32		MySQL Server: OptimizerVerified
(1214 days)		S38.0.31AnyAnyField_double::val_str causes string truncation
1098932023-02-02
9:15		2023-02-02
10:11		MySQL Server: JSONVerified
(1214 days)		S38.0.31, 8.0.32AnyAnyjson_contains always return 1 if candidate array is empty array
1098912023-02-02
9:10		2023-02-03
7:55		MySQL Server: DMLVerified
(1213 days)		S38.0.30,8.0.31, 8.0.32, 5.7AnyAnyContribution by Tencent: insert on duplicate key update would be abnormal
1098422023-01-30
13:51		2023-01-31
6:54		MySQL Server: DMLVerified
(1216 days)		S38.0.31, 8.0.32, 5.7.41MacOSx86Problems when mod , division function and extremum function are used together
1098382023-01-30
12:27		2023-01-31
6:53		MySQL Server: DMLVerified
(1216 days)		S38.0.19, 5.7.41, 8.0.31AnyAnyDecimal division lose result precision in some specific scenarios
1098372023-01-30
12:24		2023-01-30
13:24		MySQL Server: DMLVerified
(1217 days)		S38.0.31, 8.0.32, 5.7.41MacOSx86The representation of 0 in division function in computing string
1098242023-01-27
15:43		2023-01-28
8:04		MySQL Server: OptimizerVerified
(1219 days)		S38.0.32Ubuntu (22.04)x86 (x86_64)Bit query with wrong result
1098202023-01-27
8:54		2023-01-28
12:55		MySQL Server: OptimizerVerified
(1220 days)		S38.0.29, 8.0.32Any (rhel-7.4)Any (x86-64)optimizer hints in definition of views seem to be ignored
1097362023-01-23
10:41		2023-01-25
7:41		MySQL Server: OptimizerVerified
(1222 days)		S28.0.32Ubuntu (22.04)x86 (x86_64)ANY query with wrong result
1097282023-01-21
19:27		2023-09-05
8:45		MySQL Server: OptimizerVerified
(1195 days)		S18.0.30AnyAnySELECT statement: Result is not proper with GROUP BY with LIMIT OFFSET
1097262023-01-20
21:35		2023-05-29
12:01		MySQL Server: OptimizerVerified
(1224 days)		S28.0.31Ubuntux86Incorrect results with aggregated functions on correlated lateral joins
1096082023-01-12
15:11		2023-01-24
11:39		MySQL Server: OptimizerVerified
(1223 days)		S38.0.31Ubuntu (22.04)x86 (x86_64)Exists query with wrong result
1096012023-01-12
9:00		2023-01-12
9:38		MySQL Server: OptimizerVerified
(1235 days)		S38.0AnyAnyApply partition pruning if all insert rows have non-null values on autoinc field
1095852023-01-11
12:06		2023-01-11
12:28		MySQL Server: OptimizerVerified
(1236 days)		S28.0.31Any (Docker image)x86Sub query not returning the right result
1095602023-01-09
20:12		2023-01-10
6:51		MySQL Server: CompilingVerified
(1237 days)		S38.0.30AnyAny"Reduce size of RelWithDebInfo" makes coredump useless for official binaries
1095072023-01-01
11:48		2025-07-31
13:10		MySQL Server: CharsetsVerified
(1245 days)		S38.0.31, 8.0.41MacOSAnyIllegal mix of collations when selecting from a view with a calculated column
1094492022-12-21
9:48		2023-01-03
8:04		MySQL Server: OptimizerVerified
(1257 days)		S38.0.26, 8.0.31AnyAnyfunctional index could produce wrong result
1094292022-12-19
15:59		2022-12-20
14:23		MySQL Server: CompilingVerified
(1259 days)		S38.0LinuxARMUpdate the directories malloc-lib supports because ARM
1094072022-12-16
12:31		2022-12-16
12:38		MySQL Server: OptimizerVerified
(1262 days)		S25.7.5, 8.0.31AnyAnyExtra line caused by NOT comparsion + ALL
1094062022-12-16
12:31		2022-12-16
12:38		MySQL Server: OptimizerVerified
(1262 days)		S35.7.11, 8.0.31AnyAnyValue change after relaxing WHERE condition
1093962022-12-15
15:20		2022-12-16
5:48		MySQL Server: CompilingVerified
(1262 days)		S38.0AnyAnyContribution: cmake: fail fatally when sql/sql_yacc.h is missing and bison ...
1093672022-12-13
16:11		2022-12-14
5:58		MySQL Server: OptimizerVerified
(1264 days)		S35.7.22, 8.0.31AnyAnyvalue changed caused by DISTINCT and JOIN
1093632022-12-13
13:08		2022-12-16
14:50		MySQL Server: OptimizerVerified
(1262 days)		S38.0.4, 8.0.31AnyAny0 changed to -0 caused by DISTINCT and UNION ALL
1093622022-12-13
12:55		2022-12-13
13:20		MySQL Server: OptimizerVerified
(1265 days)		S28.0.13, 8.0.31AnyAnyExtra line caused by DISTINCT and key
1093562022-12-13
7:01		2022-12-13
7:56		MySQL Server: OptimizerVerified
(1265 days)		S28.0.16, 8.0.31AnyAnyExtra line caused by DISTINCT and IS TRUE
1093542022-12-13
5:43		2022-12-13
7:15		MySQL Server: OptimizerVerified
(1265 days)		S38.0.21, 8.0.30, 8.0.31AnyAnyNumeric format change caused by DISTINCT, UNION and NULL
1093532022-12-13
5:24		2022-12-13
7:12		MySQL Server: OptimizerVerified
(1265 days)		S28.0.22, 8.0.31AnyAnyExtra line caused by DISTINCT and a certain number of '0'
1093522022-12-13
5:00		2022-12-13
6:43		MySQL Server: OptimizerVerified
(1265 days)		S38.0.23, 8.0.31AnyAnyNumeric format change caused by DISTINCT and UCASE
1093332022-12-11
13:13		2022-12-13
12:46		MySQL Server: OptimizerVerified
(1265 days)		S38.0.31AnyAnyquery with/without index get different result
1093112022-12-08
3:40		2022-12-09
3:36		MySQL Server: OptimizerVerified
(1269 days)		S18.0.22 8.0.30, 8.0.31AnyAnyWrong result
1092512022-11-30
16:06		2023-01-18
23:58		MySQL Server: CompilingVerified
(1229 days)		S35.7.39, 5.7.40Ubuntux86Cannot compile 5.7.39 on Ubuntu 22.04 because ssl is not found
1092122022-11-27
8:34		2022-11-27
9:20		MySQL Server: OptimizerVerified
(1281 days)		S18.0.30, 8.0.31AnyAnyIncorrect Hash Semijoin Execution
1091792022-11-23
9:47		2022-11-25
6:49		MySQL Server: DMLVerified
(1285 days)		S28.0.31, 5.7.40LinuxAnyunique key with null value acts abnormally in select statements
1091732022-11-23
7:51		2022-11-24
12:16		MySQL Server: OptimizerVerified
(1284 days)		S5.31, 8.0.31AnyAnyContribution: Offset pushdown to InnoDB and removal of redundant conditions
1091552022-11-22
5:43		2023-12-13
11:44		MySQL Server: OptimizerVerified
(1286 days)		S58.0.18, 8.0.31, 8.0.35AnyAnyInvalid scan on left join tables of which columns not in distinct output fields
1091492022-11-20
5:01		2023-12-05
4:04		MySQL Server: DMLVerified
(908 days)		S38.0.31, 5.7Ubuntux86The representation of 0 in MOD function in computing string
1091072022-11-16
8:19		2022-11-22
14:06		MySQL Server: DMLVerified
(1292 days)		S58.0.31AnyAnyNon optimal query plan chosen for DELETE
1090762022-11-14
11:35		2023-04-06
13:15		MySQL Server: CompilingVerified
(1293 days)		S35.7.40Linuxx86COMPILATION FAILURE IN 5.7 SERVER WITH GCC 7.5.0
1090142022-11-07
2:56		2022-11-07
8:18		MySQL Server: OptimizerVerified
(1301 days)		S35.7.40AnyAnyis null acts abnormally in select statements
1090032022-11-04
8:01		2024-04-29
7:46		MySQL Server: OptimizerVerified
(1304 days)		S28.0.21, 8.0.31Windows (10 Pro)x86 (64-bit)Index intersection returns less results than expected
1090022022-11-04
6:23		2022-11-04
14:13		MySQL Server: DMLVerified
(1304 days)		S38.0AnyAnyfilename_to_tablename() handles temp table's name "p0#tmp" incorrectly
1089962022-11-03
17:07		2022-11-07
16:51		MySQL Server: CompilingVerified
(1301 days)		S38.0.31Windows (10.0.18363)x86MySQL Client compilation errors on Windows when OpenSSL path contains spaces
1089812022-11-03
10:35		2025-11-14
5:59		MySQL Server: OptimizerVerified
(1305 days)		S38.0Any (rhel-7.4)Any (x86-64)function NULLIF(ASCII()) acts abnormally in select statements
1089462022-11-01
3:35		2022-12-13
4:12		MySQL Server: OptimizerVerified
(1265 days)		S38.0.30AnyAny0 changed to 0.0 caused by DISTINCT and UNION ALL
1089382022-10-31
13:59		2022-12-13
4:08		MySQL Server: OptimizerVerified
(1265 days)		S38.0.30AnyAnyDate value change caused by ON
1089372022-10-31
13:30		2022-12-13
4:03		MySQL Server: OptimizerVerified
(1265 days)		S38.0.30AnyAnyDate value change caused by HAVING
1089362022-10-31
12:58		2022-12-13
3:56		MySQL Server: OptimizerVerified
(1265 days)		S28.0.30AnyAnyValue change caused by DISTINCT
1089342022-10-31
9:32		2022-10-31
12:00		MySQL Server: OptimizerVerified
(1308 days)		S2mysql-8.0.18/5.7.25AnyAnyMySQL-8.0 select query about rand() in Subquery result is wrong
1088632022-10-24
16:40		2024-03-15
8:49		MySQL Server: OptimizerVerifiedS58.0.31AnyAnydifferent index picked when row is not found, marginally slower
1088522022-10-22
2:45		2022-10-22
5:43		MySQL Server: OptimizerVerified
(1317 days)		S58.0.31Ubuntu (20.04)x86Suspicious Estimated Rows by DISTINCTROW
1088512022-10-22
1:55		2022-10-22
5:42		MySQL Server: OptimizerVerified
(1317 days)		S58.0.31Ubuntu (20.04)x86Suspicious Estimated Rows by JOIN
1088332022-10-20
10:11		2022-10-20
12:35		MySQL Server: OptimizerVerified
(1319 days)		S58.0.31Ubuntu (20.04)x86Suspicious Estimated Rows
1088282022-10-19
13:39		2024-10-31
7:17		MySQL Server: DMLVerified
(577 days)		S28.0.28, 8.0.31AnyAnyerror DB_UNDO_RECORD_TOO_BIG when update json column
1087902022-10-15
16:46		2022-10-17
6:55		MySQL Server: DMLVerified
(1322 days)		S28.0.30AnyAnyInvisible column's default values is invalid if not specify other columns
1087882022-10-15
7:34		2022-10-17
7:00		MySQL Server: OptimizerVerified
(1322 days)		S35.7.40LinuxAnyThe temporary alias is incorrect when the SQL statement is executed.
1087872022-10-14
18:51		2022-10-17
6:51		MySQL Server: DMLVerified
(1322 days)		S38.0AnyAnyUNIX_TIMESTAMP(NOW()) is lossy
1087652022-10-13
13:52		2022-12-19
12:48		MySQL Server: Data TypesVerified
(1322 days)		S28.0.31UbuntuAnycomparison of INT column with DECIMAL value changes if index is used or not
1086592022-09-30
7:18		2022-09-30
9:54		MySQL Server: OptimizerVerified
(1339 days)		S38.0.30AnyAnymulti-valued index get wrong result
1086302022-09-28
10:46		2022-09-28
11:33		MySQL Server: JSONVerified
(1341 days)		S35.7Linux (centos 7.5)x86json query bug
1085482022-09-20
6:37		2022-09-20
7:35		MySQL Server: OptimizerVerified
(1349 days)		S25.7, 5.7.39AnyAnyGROUP_CONCAT NOT SET USED_TABLES WHEN DERIVED_MERGE.
1085282022-09-18
10:28		2022-09-20
5:25		MySQL Server: OptimizerVerified
(1349 days)		S28.0.30Ubuntu (20.04)x86Inconsistent read and write, which use the same predicate (WHRE clause)
1085202022-09-16
7:54		2022-09-16
8:05		MySQL Server: OptimizerVerified
(1353 days)		S28.0, 8.0.30, 5.7.39LinuxAnyReturn different result due to different optimizer switch
1085182022-09-16
1:56		2022-09-16
6:06		MySQL Server: CompilingVerified
(1353 days)		S38.0.21AnyAnyReturn value of flush_io_cache() not get checked
1085162022-09-16
1:50		2022-09-19
13:24		MySQL Server: OptimizerVerified
(1353 days)		S28.0.21AnyAnyReturn value of my_b_flush_io_cache(IO_CACHE*, int) not get checked
  Showing 1-1000 of 2284 (Edit, Save, CSV, Feed) Show Next 1000 Entries »