MySQL Bugs: Search

Showing all 273 (Edit, Save, CSV, Feed)

ID#	Date	Updated	Type	Status	Sev	Version	OS	CPU	Summary
121327	2026-09-20 20:19	2026-09-20 20:19	MySQL Server: Optimizer	Open	S2	26.10.0 (trunk, fcf22d3) , 9.7.2, 8.4.11	Any	Any	TIME(N) compared with a non-constant string is compared as text, not as a time
121326	2026-09-20 20:03	2026-09-20 20:03	MySQL Server: Data Types	Open	S2	26.10.0 (trunk, fcf22d3), 9.4.0	Any	Any	YEAR column compared to a non-integral constant returns and drops wrong rows
121325	2026-09-20 20:01	2026-09-20 20:01	MySQL Server: Optimizer	Open	S2	26.10.0 (trunk, fcf22d3), 9.4.0	Any	Any	MIN()/MAX() with BETWEEN and a non-integral bound returns NULL while rows match
121324	2026-09-20 18:49	2026-09-20 18:49	MySQL Server: Optimizer	Open	S2	26.10.0 (trunk, commit fcf22d3), 9.4.0	Any	Any	Index equality on DATETIME(N) returns a row that fails its own WHERE predicate
121317	2026-09-18 13:49	2026-09-18 13:49	MySQL Server: Optimizer	Open	S1	8.4.11,9.7.1	Linux (Fedora 42, kernel 6.17.12)	ARM (aarch64, 8 cores, 31 GiB RAM)	Multi-valued index in an index_merge (sort_union) plan crashes mysqld in check_unique_fields()
121315	2026-09-18 11:42	2026-09-18 11:42	MySQL Server: Optimizer	Open	S3	8.4.11, 9.7.1	Any	Any	Redundant outer DISTINCT over UNION causes a second temporary-table deduplication
121314	2026-09-18 10:03	2026-09-18 10:03	MySQL Server: Replication	Open	S2	8.0.40/5.7.44	Any	Any	MTS recovery silently skips transactions, leaving holes in gtid_executed
121313	2026-09-18 5:38	2026-09-18 7:59	MySQL Server: Optimizer	Verified (2 days)	S3	9.7.2	Any	Any	REPLACE() Produces Different Results Depending on Whether GROUP BY Is Applied
121312	2026-09-18 2:56	2026-09-18 8:00	MySQL Server: Optimizer	Verified (2 days)	S3	9.7.2	Any	Any	`DISTINCTROW` causes `REPEAT()` with a scalar subquery to return an incorrectly duplicated value.
121311	2026-09-18 2:48	2026-09-18 7:50	MySQL Server: Data Types	Verified (2 days)	S3	26.7.0	MacOS (15.6.1)	ARM (Apple Silicon)	Inconsistent handling of FLOAT ZEROFILL in UPPER() and CHARACTER_LENGTH()
121307	2026-09-17 11:06	2026-09-17 11:06	MySQL Server: DDL	Open	S3	8.4.11, 9.7.2, 26.7.0	Any	Any	CTAS through temp table VIEW resets TIMESTAMP DEFAULT
121304	2026-09-17 7:51	2026-09-17 8:53	MySQL Server: Optimizer	Verified (3 days)	S2	8.4.10	Any (Docker container)	Any (x86_64)	Incorrect empty result for RIGHT JOIN with always-false EXISTS condition
121303	2026-09-17 7:37	2026-09-17 7:44	MySQL Server: Optimizer	Verified (3 days)	S3	9.7	Any	Any	IN() returns 1 instead of NULL when no list element matches the left-hand expression and the list contains NULL
121302	2026-09-17 6:34	2026-09-20 2:31	MySQL Server: Information schema	Open	S1	8.4.11;8.0.46;8.0.44;8.0.36	Any	x86	Server hangs: INSTALL PLUGIN (I_S plugin) re-locks LOCK_plugin via DD attachable transaction
121301	2026-09-17 6:12	2026-09-17 7:33	MySQL Server: Optimizer	Verified (3 days)	S3	8.4	MacOS (15.6.1)	ARM (Apple Silicon)	NULLIF() returns different results for a NULL literal and a NULL-valued BIGINT
121300	2026-09-17 2:25	2026-09-17 7:14	MySQL Server: Optimizer	Verified (3 days)	S2	9.7.2	Any	Any	`IN` predicate returns `TRUE` even though every corresponding equality comparison returns `FALSE`
121298	2026-09-16 16:02	2026-09-18 7:18	MySQL Server: FULLTEXT search	Verified (3 days)	S2	9.6.0	Any	Any	MATCH() AGAINST() returns incorrect (near-random) relevance scores when wrapped in a CASE expression combined with DISTI
121292	2026-09-16 8:29	2026-09-16 10:39	MySQL Server: Optimizer	Verified (4 days)	S2	8.4.11 (LTS), 9.7.2, 26.7.0 (current) —	Any (observed on Linux x86_64, Ubuntu 22.04.2 LTS, kernel 5.15.0-187-generic;)	Any (Any (observed on x86))	INTERSECT ALL / EXCEPT ALL lose duplicate counts when the hash set operation spills to disk
121290	2026-09-16 7:08	2026-09-16 11:23	MySQL Server: DDL	Verified (4 days)	S3	8.4.11, 9.7.2, 26.7.0	Any	Any	CTAS with a JSON expression results in literal NULL default, broken SHOW CREATE TABLE
121284	2026-09-15 6:13	2026-09-15 6:48	MySQL Server: Partitions	Open	S2	MySQL 9.7.2 and 26.7.0	Any (Linux on x86_64)	Any	EXCHANGE PARTITION accepts mismatched functional indexes and causes wrong results
121281	2026-09-14 14:08	2026-09-16 15:06	MySQL Server: Optimizer	Verified (4 days)	S3	8.4.11 - 9.4	Any	Any	Wrong results in multi-join queries due to derived merge
121272	2026-09-12 14:16	2026-09-14 11:39	MySQL Server: Optimizer	Verified (6 days)	S3	8.0.45	MacOS (MacOS 26.5.2, using Homebrew)	ARM	Incorrect ORDER BY when using GROUP BY, GROUP_CONCAT() and COUNT(id) OVER()
121271	2026-09-12 2:30	2026-09-12 2:31	MySQL Server: Optimizer	Open	S5	9.7.1	Ubuntu (22.04.4 LTS)	x86 (Intel(R) Xeon(R) Gold 5220 CPU @ 2.20GHz)	Equivalent range-predicate rewrite exposes ORDER BY cost-ranking inversion: 2.9x higher-cost plan runs 2.85x faster
121270	2026-09-12 0:47	2026-09-14 11:22	MySQL Server: Optimizer	Verified (6 days)	S3	8.0.45	Any	Any	COUNT(DISTINCT ...) incorrectly counts a NULL result from AES_ENCRYPT() when its argument is a scalar subquery
121269	2026-09-12 0:19	2026-09-14 10:55	MySQL Server: Optimizer	Verified (6 days)	S2	9.7	Any	Any	Incorrect result from IN comparison involving CONCAT() and a scalar subquery
121267	2026-09-11 13:16	2026-09-15 7:25	MySQL Server: DDL	Open (5 days)	S3	8.4.11, 9.7.2, 26.7.0	Any	Any	CREATE TABLE AS SELECT FROM view drops column default expression in SHOW CREATE TABLE
121266	2026-09-11 3:29	2026-09-11 3:52	MySQL Server: Optimizer	Open (9 days)	S5	9.7.1	Ubuntu (22.04.4 LTS)	x86 (Intel(R) Xeon(R) Gold 5220 CPU @ 2.20GHz)	Optimizer misses cheaper join order when range predicate is only available through join equality
121259	2026-09-10 4:05	2026-09-10 4:05	MySQL Server: InnoDB storage engine	Open	S2	8.0.45	Any	Any	Use-after-free in InnoDB virtual column template during FK cascade DELETE
121253	2026-09-10 2:26	2026-09-10 8:03	MySQL Server: Optimizer	Duplicate (10 days)	S2		Any	Any	SELECT DISTINCT changes the result of AES_ENCRYPT() when its plaintext argument contains a correlated scalar subquery.
121251	2026-09-09 19:32	2026-09-09 19:32	MySQL Server: General	Open	S3		Any	Any	Contribution: Add feature_contribution.yaml ISSUE_TEMPLATE
121250	2026-09-09 15:52	2026-09-09 15:54	MySQL Server: InnoDB storage engine	Open	S3	8.0.49, 8.4.12, 9.7.3	Any	Any	Fil_shard::do_io() skips complete_io() on DB_PAGE_IS_STALE after prepare_file_for_io()
121249	2026-09-09 14:28	2026-09-17 9:03	MySQL Server: Optimizer	Verified (10 days)	S2	8.0.46, 8.4.11, 9.7.2	Linux	x86	With sql_buffer_result=ON, IN / quantified (ANY/ALL/SOME) subquery predicates in the SELECT list evaluate to NULL
121248	2026-09-09 6:44	2026-09-17 8:16	MySQL Server: Data Types	Not a Bug (3 days)	S3	26.7.0	MacOS (15.6.1)	ARM (Apple Silicon)	RIGHT() returns different results for semantically equivalent scalar-subquery arguments
121241	2026-09-07 3:28	2026-09-07 3:28	MySQL Server: Documentation	Open	S3	8.4.11、8.4.0	Any	Any	LEAST/GREATEST documentation: overlapping numeric and mixed-string comparison rules
121240	2026-09-07 3:00	2026-09-07 9:15	MySQL Server: Data Types	Verified (13 days)	S3	8.4.11	Linux (Oracle Linux Server 9.8; mysql:8.4.11 Docker image via Docker Desktop on Windows/WSL2)	x86 (x86_64 / amd64)	Scientific-notation strings: integer casts differ from arithmetic conversion
121239	2026-09-07 1:17	2026-09-07 7:30	MySQL Server: Optimizer	Verified (13 days)	S2	8.0.46	Any	Any	Wrong result: the same CTE returns inconsistent cardinality across consumers with UNION/EXCEPT
121231	2026-09-04 14:57	2026-09-10 7:51	MySQL Server: Prepared statements	Open (10 days)	S2	9.7.0; 9.7.2	Any	Any	Prepared statement uses stale div_precision_increment value after SESSION variable change
121230	2026-09-04 8:25	2026-09-04 8:25	MySQL Server: Documentation	Open	S3	26.7, 8.4	Any	Any	Storage engine help is broken/useless
121229	2026-09-04 8:21	2026-09-04 8:21	MySQL Server: General	Open	S3	26.7	Any	Any	Outdated help contents
121228	2026-09-03 13:25	2026-09-04 9:08	MySQL Server: FULLTEXT search	Open (16 days)	S2	8,8.4,9	Any	Any	Boolean FTS: "phrase" word* misses rows in FTS cache until OPTIMIZE TABLE
121226	2026-09-03 7:52	2026-09-03 13:01	MySQL Server: Optimizer	Verified (17 days)	S3	9.7.2	Any	Any	WHERE int_col = CAST(decimal AS DOUBLE) index access stores the rounded key and returns wrong rows (literal path correct
121225	2026-09-03 7:49	2026-09-03 12:57	MySQL Server: DML	Not a Bug (17 days)	S3	9.7.2	Any	Any	INTERVAL() with string arguments uses numeric order — opposite of the equivalent piecewise CASE
121224	2026-09-03 7:47	2026-09-03 12:45	MySQL Server: DML	Not a Bug (17 days)	S3	9.7.2	Any	Any	GREATEST(varchar, int) uses string order while the standalone comparator uses numeric order
121223	2026-09-03 7:45	2026-09-03 12:39	MySQL Server: DML	Not a Bug (17 days)	S3	9.7.2	Any	Any	GREATEST/LEAST(TIME column, big int): ordering flips between rows; SELECT display contradicts WHERE
121222	2026-09-03 7:43	2026-09-03 12:31	MySQL Server: Optimizer	Verified (17 days)	S3	9.7.2	Any	Any	GREATEST/LEAST mixed-type aggregation produces illegal packed dates (16383-15-31 and 7 more)
121221	2026-09-03 7:42	2026-09-03 12:27	MySQL Server: Optimizer	Verified (17 days)	S3	9.7.2	Any	Any	BIT column vs BIT literal: comparator path split (column numeric, literal byte-string)
121220	2026-09-03 7:41	2026-09-03 12:22	MySQL Server: Optimizer	Verified (17 days)	S3	9.7.2	Any	Any	One DATE constant in an IN list silently disables all other elements ('abc' IN ('abc', DATE'...') cannot find 'abc')
121219	2026-09-03 7:40	2026-09-03 12:15	MySQL Server: Optimizer	Verified (17 days)	S3	9.7.2	Any	Any	TIME column BETWEEN contradicts its decomposition: both single-sided =1, AND =1, yet BETWEEN =0
121218	2026-09-03 7:36	2026-09-03 12:04	MySQL Server: Optimizer	Verified (17 days)	S3	9.7.2	Any	Any	TIME column vs TIMESTAMP/DATETIME constant: the constant's date part is silently discarded
121217	2026-09-03 7:30	2026-09-03 11:55	MySQL Server: DML	Not a Bug (17 days)	S3	9.7.2	Any	Any	YEAR column is temporalized while YEAR numeric constants are not: opposite answers per context
121216	2026-09-03 7:28	2026-09-03 10:13	MySQL Server: Optimizer	Verified (17 days)	S3	8.4	Any	Any	VARCHAR column vs DATE constant: failed conversion silently acts as a "smallest sentinel"
121215	2026-09-03 7:26	2026-09-03 9:25	MySQL Server: DML	Not a Bug (17 days)	S3	9.7.2	Any	Any	CAST(number AS TIME): overflow handling splits by digit count; 11–12 digits silently return 00:00:00
121214	2026-09-03 7:23	2026-09-03 9:16	MySQL Server: Optimizer	Verified (17 days)	S3	9.7.2	Any	Any	TIME column compared with a >= 10^10 integer constant returns inverted results (column vs literal context semantic split
121213	2026-09-02 15:24	2026-09-04 5:11	MySQL Server: Optimizer	Verified (16 days)	S2	8.0.46, 8.4.11, 9.7.2	Linux	Any	UNIQUE const-table plan evaluates `GROUPING()=1` before ROLLUP and drops the super-aggregate row
121212	2026-09-02 14:57	2026-09-03 9:30	MySQL Server: Optimizer	Can't repeat (17 days)	S2	9.7.2	Linux	Any	SELECT-list `IN` / `<op> ANY` (subquery with NULL) rewrites UNKNOWN as TRUE via `EXISTS (pred OR inner IS NULL)`
121208	2026-09-02 9:04	2026-09-04 8:53	MySQL Server: Optimizer	Verified (16 days)	S3	8.0.46, 8.4.11, 9.7.2	Any	Any	Materializing a shared `UNION` CTE changes a scalar `ORDER BY ... LIMIT` result
121207	2026-09-02 9:03	2026-09-04 8:43	MySQL Server: Optimizer	Verified (16 days)	S2	8.0.46, 8.4.11, 9.7.2	Any	Any	Materializing an `EXISTS` input changes a `RIGHT JOIN` result
121206	2026-09-02 9:01	2026-09-04 7:49	MySQL Server: Optimizer	Verified (16 days)	S2	8.0.46, 8.4.11, 9.7.2	Any	Any	Materializing a computed derived column changes a false `HAVING` result
121198	2026-09-01 22:42	2026-09-01 22:42	MySQL Server: Information schema	Open	S3	8.0.42	Any	Any	SHOW TABLE STATUS repeats the error of an unreadable table in the Comment of all the following tables
121193	2026-08-31 11:03	2026-09-02 13:30	MySQL Server: InnoDB storage engine	Open	S2	8.0, 8.4, 26.7.0	Any	Any	Crash during BLOB UPDATE: recovery rollback frees the old, still-referenced LOB
121188	2026-08-29 13:30	2026-09-01 4:50	MySQL Server: Optimizer	Verified (19 days)	S2	8.0.46, 8.4.11, 9.7.2	Any	Any	Materializing an `IN` subquery changes a `UNION`/`RIGHT JOIN` result
121187	2026-08-29 13:28	2026-09-01 4:53	MySQL Server: Optimizer	Verified (19 days)	S2	8.0.46, 8.4.11, 9.7.2	Any	Any	Materializing a `TIME` expression changes comparison with `DATETIME` literals
121184	2026-08-28 8:45	2026-09-01 4:59	MySQL Server: Optimizer	Verified (19 days)	S3	8.0.46, 8.4.11, 9.7.2	Any	Any	Adding an unrelated element to a mixed-type temporal IN list flips the match result of other elements
121183	2026-08-28 8:06	2026-08-31 5:50	MySQL Server: Optimizer	Verified (20 days)	S3	8.0.46, 8.4.11, 9.7.2	Any	Any	Single-element IN (rewritten to =) errors on non-convertible string, multi-element IN silently returns FALSE — behavior
121182	2026-08-28 8:05	2026-08-29 19:29	MySQL Server: DML	Not a Bug (22 days)	S3	9.7.2	Any	Any	Temporal BETWEEN conversion-failure error message blames the valid constant instead of the failing operand
121181	2026-08-28 8:03	2026-08-31 5:41	MySQL Server: Optimizer	Verified (20 days)	S2	8.0.46, 8.4.11, 9.7.2	Any	Any	Temporal BETWEEN returns FALSE instead of NULL when LHS->temporal conversion fails (uninitialized Time_val/Date_val comp
121179	2026-08-27 18:23	2026-08-28 5:01	MySQL Server: Optimizer	Verified (23 days)	S2	8.0.46, 8.4.11, 9.7.2	Any	Any	Framed window functions return wrong results when windowing steps are skipped (const plan, implicit grouping)
121177	2026-08-27 7:59	2026-09-01 12:11	MySQL Server: InnoDB storage engine	Open (19 days)	S2	8.0.45, 8.4.8, 9.6.0	Any	Any	different innodb_ddl_buffer_size for master and slave masy cause duplicated key error
121171	2026-08-26 2:42	2026-08-26 5:54	MySQL Server: Optimizer	Verified (25 days)	S2	9.7.2, 26.07	Any	Any	Hypergraph optimizer loses the LATERAL dependency of a materialized derived table under ref/index access
121167	2026-08-25 9:06	2026-08-26 5:17	MySQL Server: DML	Need Feedback (25 days)	S1	8,4	Any	Any	Bug in update statement execution
121166	2026-08-25 1:41	2026-08-25 1:43	MySQL Server: InnoDB storage engine	Open	S2	8.0.30	Any	Any	concurrent updates make FK ON UPDATE CASCADE miss child rows
121163	2026-08-23 8:00	2026-08-23 8:58	MySQL Server: Command-line Clients	Open (28 days)	S1	9.7.1	Any	Any	mysqldump discards time_zone and sql_mode, silently changing generated column data
121162	2026-08-23 7:59	2026-08-23 7:59	MySQL Server: Partitions	Open	S1	9.7.1	Any	Any	EXCHANGE PARTITION definition check ignores expressions and CHECK constraints
121158	2026-08-23 6:41	2026-08-26 3:09	MySQL Server: InnoDB storage engine	Open (25 days)	S1	9.7.1	Any	Any	ALTER COLLATE skips validation of UNIQUE functional index, leaving duplicate keys
121157	2026-08-23 6:37	2026-08-25 9:36	MySQL Server: Optimizer	Verified (26 days)	S1	8.0.46, 8.4.11, 9.7.2	Any	Any	Timezone-dependent generated column breaks UNIQUE and makes table unrestorable
121155	2026-08-22 15:02	2026-08-26 4:39	MySQL Server: Optimizer	Not a Bug (25 days)	S2	9.7.1	Any	Any	MySQL loses LEFT JOIN preserved rows when an empty temporary table is used with DISTINCT and a window function
121154	2026-08-22 10:17	2026-08-25 7:12	MySQL Server: Optimizer	Duplicate (26 days)	S2	9.7.1	Any	Any	CTE derived merge incorrectly preserves a NULL-complemented LEFT JOIN row rejected by the WHERE predicate
121153	2026-08-22 6:36	2026-08-22 10:52	MySQL Server: Data Types	Not a Bug (29 days)	S2	9.7.1	Any	Any	Materializing a UNION prefix in a CTE changes TIME values in the final UNION result
121152	2026-08-22 6:09	2026-08-25 6:46	MySQL Server: Optimizer	Verified (26 days)	S3	9.2	Any	Any	CTE merge incorrectly loses the first alias when a BIT column is projected twice with different aliases
121151	2026-08-22 2:15	2026-08-24 4:36	MySQL Server: Documentation	Open (27 days)	S3	8.4.5	Any	Any	InnoDB Locking docs don't qualify the unique-index equality gap-lock guarantee for IN (...) lists
121149	2026-08-21 13:17	2026-08-21 20:37	MySQL Server: Optimizer	Verified (30 days)	S2	9.7.1	Any	Any	MySQL temporal implicit conversion changes `TIMEDIFF` predicate results after materialization
121147	2026-08-21 4:11	2026-08-21 20:40	MySQL Server: Optimizer	Verified (30 days)	S3	9.7.1	Ubuntu (22.04)	Any	QUOTE() incorrectly treated as null-rejecting in outer joins
121145	2026-08-20 11:33	2026-08-21 6:44	MySQL Server: Optimizer	Verified (30 days)	S3	8.0	Ubuntu (22.04)	Any	COUNT(DISTINCT UUID()) / RAND() returns 1 under implicit grouping
121144	2026-08-20 11:08	2026-08-20 11:20	MySQL Server: Performance Schema	Open (31 days)	S2	8.4.4 (Any)	Any	Any	Performance Schema reports ROWS_EXAMINED inside stored programs wrongly as a running total
121142	2026-08-20 1:50	2026-08-20 5:21	MySQL Server: Optimizer	Duplicate (31 days)	S1	8.0.41, 8.4.11, 9.4.0, 9.7.1	Any	Any	group skip scan for deduplication collapses each group to one row before a semijoin/antijoin condition on a later index
121141	2026-08-20 1:50	2026-08-20 5:26	MySQL Server: Optimizer	Verified (31 days)	S1	8.0.46, 8.4.11, 9.7.2	Any	Any	group skip scan for deduplication collapses each group to one row before a semijoin/antijoin condition on a later index
121124	2026-08-19 8:10	2026-08-19 8:10	MySQL Server: DDL	Open	S3	8.0.46	Any	Any	Unrelated CHECK on DATETIME prevents INSTANT/INPLACE ENUM extension
121122	2026-08-19 5:49	2026-08-19 5:55	MySQL Server: Performance Schema	Open	S3	26.7.0	Any	Any	Race in Performance Schema shared memory-stat capacity accounting can underflow size_t and corrupt high/low watermarks
121120	2026-08-19 4:50	2026-08-19 4:51	MySQL Server: DDL	Open (32 days)	S3	9.7.2	Any	Any	INPLACE utf8mb3-to-utf8mb4 conversion corrupts unindexed CHAR in REDUNDANT tables
121116	2026-08-18 11:25	2026-08-18 11:25	MySQL Server: Partitions	Open	S2	9.7.1	MacOS	ARM	index scan on a subpartitioned table silently omits rows when a secondary index contains a VIRTUAL generated column
121115	2026-08-18 11:00	2026-08-18 11:08	MySQL Server: DDL	Open	S3	9.7.2	Any	Any	Online rebuild can corrupt REDUNDANT CHAR records after utf8mb3-to-utf8mb4 conversion
121113	2026-08-18 9:22	2026-08-19 14:23	MySQL Server: Optimizer	Verified (32 days)	S3	8.0.46, 8.4.11, 9.7.2	Any	Any	`JSON_QUOTE()` metadata overflow truncates valid output
121112	2026-08-18 9:20	2026-08-19 14:17	MySQL Server: Optimizer	Verified (32 days)	S3	8.0.46, 8.4.11, 9.7.2	Any	Any	Character-set conversion metadata overflow causes silent data loss
121111	2026-08-18 9:15	2026-08-19 8:24	MySQL Server: Optimizer	Verified (32 days)	S3	8.0.46, 8.4.11, 9.7.2	Any	Any	Hex Result Metadata Uint32 Wrap
121102	2026-08-17 1:29	2026-09-08 5:20	MySQL Server: InnoDB storage engine	Patch pending (30 days)	S2	8.0.46,8.4.11,9.7.2, 26.10.0	Any	Any	INPLACE rebuild may corrupt long-prefix secondary indexes
121100	2026-08-16 22:04	2026-08-19 5:22	MySQL Server: Optimizer	Verified (32 days)	S3	8.0.46, 8.4.11, 9.7.2	Linux	ARM	Merged `CAST(col AS CHAR) COLLATE utf8mb4_0900_bin` makes col = UPPER(col) return wrong result
121099	2026-08-16 22:01	2026-08-19 4:53	MySQL Server: Optimizer	Verified (32 days)	S3	8.0.46, 8.4.11, 9.7.2	Linux	ARM	Merged CASE/CAST view + aliased HAVING MIN(col) >= IFNULL(col, col) returns wrong result
121093	2026-08-14 3:29	2026-08-14 7:37	MySQL Server: Documentation	Closed (37 days)	S3	9.7.2	Any	Any	[MySQL 9.7.2] Missing release note entry for BUG#37875484
121091	2026-08-13 14:00	2026-08-14 11:08	MySQL Server: Optimizer	Verified (37 days)	S2	8.0.46, 8.4.11, 9.7.2	Any	Any	Wrapping a SET column in VIEW/CTE changes `HAVING MAX(set_col) > numeric_literal` semantics
121085	2026-08-12 21:49	2026-08-13 7:14	MySQL Server: Optimizer	Verified (38 days)	S3	8.0.46,8.4.11, 9.7.2	Linux	ARM	A VIEW whose column is an expression drops a group in query
121084	2026-08-12 20:45	2026-08-13 7:13	MySQL Server: Optimizer	Verified (38 days)	S3	8.0.46,8.4.11, 9.7.2	Linux	ARM	VAR_SAMP() result depends on the query plan
121083	2026-08-12 20:39	2026-08-13 6:28	MySQL Server: Optimizer	Verified (38 days)	S3	8.0.46,8.4.11, 9.7,2	Linux	ARM	SELECT DISTINCT ... GROUP BY <same list> drops rows
121082	2026-08-12 20:31	2026-08-13 6:31	MySQL Server: Optimizer	Verified (38 days)	S3	8.0.46, 8.4.11, 9.7.2	Linux	ARM	`x NOT IN (<set-operation subquery>)` drops rows
121079	2026-08-12 12:49	2026-08-12 17:31	MySQL Server: Optimizer	Verified (39 days)	S2	8.4.9	Linux	Any	Wrong result: quantified comparison subquery (>= ALL etc.) evaluates FALSE under double negation
121071	2026-08-11 3:56	2026-08-11 5:58	MySQL Server: Command-line Clients	Open (40 days)	S3	9.7.1	Linux (AlmaLinux 9.2)	x86 (x86_64)	mysql_tzinfo_to_sql drops TZif future DST rules after 2037
121070	2026-08-11 0:30	2026-08-13 7:11	MySQL Server: Optimizer	Verified (38 days)	S3	8.0.46, 8.4.11, 9.7.2	Linux	ARM	VAR_SAMP (and VAR_POP / STDDEV_SAMP) over BIGINT UNSIGNED values near 2^64 is insertion-order dependent
121068	2026-08-07 22:26	2026-08-10 5:21	MySQL Server: Optimizer	Verified (41 days)	S3	8.0.46, 8.4.11, 9.7.2	Ubuntu	ARM	NO_BACKSLASH_ESCAPES + UNION + escaped apostrophe raises error
121066	2026-08-07 12:41	2026-08-10 5:48	MySQL Server: Command-line Clients	Open	S3	8.4.4 (Any)	Any	Any	comment entry is not working with DELIMITER in mysql client via cli command
121065	2026-08-07 9:16	2026-08-11 12:42	MySQL Server: InnoDB storage engine	Open	S1	8.4.10, 8.0.45, 5.7.39	Linux	x86	mysqld crashes with signal 11 while OPTIMIZE and concurrent DML on the same table
121062	2026-08-06 14:41	2026-08-06 14:50	MySQL Server: Prepared statements	Open (45 days)	S3	8.0.33	Any	Any	Prepared statement with USING variables returns empty result against DATE + TIME columns
121061	2026-08-06 8:37	2026-08-13 2:36	MySQL Server: InnoDB storage engine	Open (38 days)	S2	9.7, 8.4, 26.7, 8.0.46	Any	Any	InnoDB wrong result for a full-column secondary index on an externally stored field during MVCC lookup
121058	2026-08-05 12:33	2026-08-05 13:11	MySQL Server: InnoDB storage engine	Open (46 days)	S3	9.7.2	Any	Any	KILL QUERY during an in-place ALTER TABLE leaves a bulk-load page buffer fixed
121056	2026-08-04 22:19	2026-08-04 22:26	MySQL Server: Replication	Open (47 days)	S2	8.0, 8.4, 9.7 and 26.7.0	Any	Any	The recovery recommendations in Last_IO_Error "fatal error 1236" are wrong (since 8.0.17).
121055	2026-08-04 22:14	2026-08-04 22:26	MySQL Server: Documentation	Open (47 days)	S2	8.0, 8.4, 9.7 and 26.7.0 (and 5.7)	Any	Any	The documentation of gtid_purged (and more) is incomplete since 8.0.17.
121052	2026-08-04 6:29	2026-08-05 8:27	MySQL Server: Documentation	Closed (46 days)	S3	26.7.0	Any	Any	Incorrect dnf config-manager commands
121050	2026-08-03 22:09	2026-08-04 22:20	MySQL Server: Replication	Open (47 days)	S3	8.0, 8.4, 9.7 and 26.7	Any	Any	Confusing Last_IO_Error "fatal error 1236" since 8.0 (also affecting 8.4, 9.7 and 26.7) and more.
121046	2026-08-01 0:46	2026-08-04 7:45	MySQL Server: Optimizer	Verified (47 days)	S3	8.0.46, 8.4.10, 9.7.1	Any	Any	HAVING applied after SELECT DISTINCT deduplication → order-dependent wrong (empty) result
121045	2026-07-31 23:14	2026-07-31 23:14	MySQL Server: Performance Schema	Open	S3	9.7.2, 8.4 (present since 8.2.0)	Any	Any	Server telemetry metrics (mysql.stats, mysql.stats.handler) always report 0
121044	2026-07-31 10:50	2026-07-31 11:01	MySQL Server: InnoDB storage engine	Open (51 days)	S1	8.0.44, 8.0.45, 8.4.7, 8.4.8	Linux (Official mysql Docker image (Oracle Linux 9); also Azure Database for MySQL Flexible Server)	ARM (aarch64 (local repro); production/test instances affected are x86_64)	mysqld crashes (signal 11) building multi-valued index via ALTER TABLE on JSON column holding both empty and non-empty a
121041	2026-07-30 9:21	2026-08-06 4:29	MySQL Server: Optimizer	Verified (45 days)	S5	8.0.46, 8.4.11, 9.7.2	Linux	x86	JOIN a table with a condition that does not belong to it
121040	2026-07-30 9:06	2026-08-03 8:00	MySQL Server: Optimizer	Verified (48 days)	S2	8.0.46, 8.4.10, 9.7.1	MacOS	ARM	derived condition pushdown across a set operation ignores collation equality, breaking predicate monotonicity (default)
121038	2026-07-30 8:59	2026-09-17 17:03	MySQL Server: Optimizer	Closed (3 days)	S1	9.7.1	MacOS	ARM	hypergraph_optimizer=on silently updates/deletes the wrong rows for single-table UPDATE/DELETE with ORDER BY when the WH
121036	2026-07-30 8:55	2026-08-03 8:13	MySQL Server: Optimizer	Verified (48 days)	S3	8.0.46, 8.4.10, 9.7.1	MacOS	ARM	Creating a secondary index on an ENUM column changes the result of MIN()/MAX()
121035	2026-07-30 8:50	2026-07-30 8:54	MySQL Server: Replication	Open (52 days)	S5	8.0.46+, 8.4.10+	Linux	x86	Extra Table_map events are included in the binary log
121033	2026-07-30 0:39	2026-08-03 8:51	MySQL Server: Optimizer	Verified (48 days)	S3	8.0.46, 8.4.10, 9.7.1, 26.7.0	Ubuntu	ARM	Semijoin returns wrong row count over a LATERAL-derived-table view vs the base table
121032	2026-07-30 0:14	2026-07-31 10:39	MySQL Server: Optimizer	Verified (51 days)	S3	8.0.46, 8.4.10, 9.7.1, 26.7	Ubuntu	ARM	`REGEXP` backslash character-class in a WHERE over a UNION ALL derived table drops all matching rows
121028	2026-07-29 6:09	2026-07-31 11:49	MySQL Server: Optimizer	Verified (51 days)	S2	9.7.1	MacOS	ARM	Cardinality Check Granularity Error in subquery_to_derived
121026	2026-07-29 3:26	2026-07-31 11:37	MySQL Server: Optimizer	Verified (51 days)	S2	8.0.42, 8.0.46, 8.4.9, 9.7.2	Any (official mysql Docker images, linux/arm64 and linux/amd64)	Any	Semijoin duplicate-weedout missing from plan: EXISTS + NOT EXISTS returns duplicate rows
121024	2026-07-28 15:49	2026-07-31 11:14	MySQL Server: Optimizer	Duplicate (51 days)	S3	8.0.46, 8.4.10, 9.7.1	Ubuntu (22.04)	Any	Wrong result for IS NULL / IS NOT NULL on column from nested LEFT JOIN over empty derived table
121023	2026-07-28 13:23	2026-07-28 13:23	MySQL Server: Documentation	Open	S3	8.4,9.7	Any	Any	Request to improve detail level in AI-generated release notes (restore 1–2 sentence bug descriptions)
121020	2026-07-28 6:11	2026-07-29 9:47	MySQL Server: Optimizer	Verified (53 days)	S2	9.7.1	MacOS	ARM	subquery_to_derived transforms LIMIT 1 into MIN aggregate when subquery is inside derived table (= fast-path context fai
121019	2026-07-28 6:04	2026-08-10 5:53	MySQL Server: Optimizer	Verified (41 days)	S2	8.0.46, 8.4.10, 9.7.1	MacOS	ARM	subquery_to_derived + semijoin=off produces wrong WHERE-clause EXISTS results with LIMIT (dual boundary interaction, sil
121018	2026-07-28 5:43	2026-07-29 6:07	MySQL Server: Optimizer	Verified (53 days)	S2	9.7.1	MacOS	ARM	subquery_to_derived produces wrong EXISTS/NOT EXISTS results with LIMIT (silent corruption)
121017	2026-07-28 5:06	2026-07-29 4:26	MySQL Server: Optimizer	Verified (53 days)	S3	9.7.1	MacOS	ARM	subquery_to_derived drops LIMIT 1 from non-equality scalar subqueries
121014	2026-07-27 9:59	2026-07-29 6:00	MySQL Server: Optimizer	Duplicate (53 days)	S3	8.4.10	MacOS	ARM	semijoin=off causes missing ROLLUP row with IN subquery + HAVING
121013	2026-07-27 9:57	2026-07-27 14:00	MySQL Server: Optimizer	Verified (55 days)	S3	9.7.1	MacOS	ARM	subquery_to_derived causes row count mismatch with window function + LEFT JOIN
121012	2026-07-27 9:55	2026-07-27 14:15	MySQL Server: Optimizer	Verified (55 days)	S3	8.0.46, 8.4.10, 9.7.1	MacOS	ARM	subquery_to_derived bypasses only_full_group_by check
121011	2026-07-27 9:52	2026-07-27 14:18	MySQL Server: Optimizer	Verified (55 days)	S3	8.0.46, 8.4.10, 9.7.1	MacOS	ARM	subquery_to_derived causes wrong result with GROUP BY ... WITH ROLLUP
121010	2026-07-27 7:15	2026-07-27 7:15	MySQL Server: User-defined functions ( UDF )	Open	S2	8.4.7-7	Any	Any	Contribution by ByteDance RDS MySQL team: mysqld crashes on keyring_key_store UDF return-type mismatch
121006	2026-07-24 8:32	2026-07-28 13:19	MySQL Server: Optimizer	Duplicate (54 days)	S2	8.0.46, 8.4.10, 9.7.1	Any	Any	Empty INTERSECT branch does not prevent scanning the other input
121001	2026-07-23 16:12	2026-07-28 13:13	MySQL Server: Optimizer	Verified (54 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	Incorrect evaluation of NOT (A AND NOT A AND (A IS NOT NULL)) drops NULL rows due to invalid ternary logic simplificatio
121000	2026-07-23 15:43	2026-07-28 13:55	MySQL Server: Optimizer	Duplicate (54 days)	S2	9.6.0,9.7.0	Ubuntu	Any	Incorrect index lookup range pushdown for (decimal constant NOT IN (indexed_int_column)) negation causes duplicate rows
120999	2026-07-23 15:41	2026-07-28 14:03	MySQL Server: Optimizer	Duplicate (54 days)	S2	9.6.0,9.7.0	Ubuntu	Any	Incorrect index lookup range pushdown for NOT IN / IN (decimal) on TINYINT column violates TLP partitioning
120998	2026-07-23 15:39	2026-08-03 10:55	MySQL Server: Optimizer	Verified (48 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	Inconsistent evaluation of NOT ((CASE WHEN ... LIKE a) OR a) on SMALLINT ZEROFILL UNIQUE column causes duplicate rows
120997	2026-07-23 15:31	2026-08-25 7:29	MySQL Server: Optimizer	Verified (45 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	Incorrect index lookup range pushdown/coercion for IN (COALESCE(decimal, string)) on integer indexed column violates TLP
120996	2026-07-23 15:28	2026-08-03 8:17	MySQL Server: Optimizer	Duplicate (48 days)	S3	9.6.0	Ubuntu	Any	Incorrect evaluation of NOT (LEAST(c,c) AND predicate) causes duplicate rows in TLP query partitioning
120995	2026-07-23 14:15	2026-08-03 10:48	MySQL Server: Optimizer	Not a Bug (48 days)	S2	9.6.0,9.7.0	Ubuntu	Any	Inconsistent result for IN predicate with IF(FLOAT, FLOAT, VARCHAR) expression on FLOAT column with UNIQUE index
120994	2026-07-23 14:09	2026-08-03 8:57	MySQL Server: Optimizer	Verified (48 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	Inconsistent JOIN result when comparing TEXT and DECIMAL columns with and without UNIQUE index
120993	2026-07-23 13:58	2026-08-03 7:19	MySQL Server: Optimizer	Duplicate (48 days)	S2	9.6.0	Ubuntu	Any	Incorrect query result when evaluating IN predicate with BIT_COUNT(NULL)/LEAST(NULL) on table without UNIQUE index
120992	2026-07-23 13:06	2026-08-03 6:53	MySQL Server: Optimizer	Verified (48 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	Inconsistent comparison behavior between CHARSET() string expression vs CTAS materialized column against hex literal (0x
120991	2026-07-23 12:59	2026-08-03 6:50	MySQL Server: Optimizer	Verified (48 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	Inconsistent comparison behavior between integer and ADDDATE(DATETIME, 0) expression vs CTAS materialized column
120990	2026-07-23 12:50	2026-08-03 6:49	MySQL Server: Optimizer	Verified (48 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	Inconsistent boolean evaluation between MAX(ENUM) aggregate expression and CTAS materialized ENUM column
120989	2026-07-23 12:44	2026-07-23 12:44	MySQL Server: Documentation	Open	S3	9.4.0, 8.3.0(behavior); manual: multiple	Any	Any	Documentation: FLOAT(p) boundary on floating-point-types page contradicts numeric-type-syntax page and actual server beh
120988	2026-07-23 12:31	2026-08-03 6:40	MySQL Server: Optimizer	Verified (48 days)	S2	8.0.46, 8.4.10, 9.7.1	Any	Any	Redundant DISTINCT in UNION, INTERSECT and EXCEPT branches is not eliminated
120987	2026-07-23 12:16	2026-08-06 7:44	MySQL Server: Optimizer	Verified (45 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	Inconsistent boolean evaluation of LEAST(TIME, VARCHAR) between dynamic calculation and CTAS materialized column
120986	2026-07-23 12:12	2026-08-21 7:53	MySQL Server: Optimizer	Not a Bug (30 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	Inconsistent comparison result between JSON scalar and dynamic comparison expression vs CTAS materialized boolean/intege
120985	2026-07-23 10:39	2026-08-06 12:46	MySQL Server: Optimizer	Verified (45 days)	S2	9.6.0,9.7.0	Ubuntu	Any	ENUM comparison with a CHAR() binary-string expression changes after CREATE TABLE AS SELECT materialization
120984	2026-07-23 10:19	2026-07-30 6:55	MySQL Server: Optimizer	Verified (52 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	Inconsistent type metadata and display for COALESCE() on a BIT column before and after CREATE TABLE AS SELECT
120983	2026-07-23 10:07	2026-07-29 10:20	MySQL Server: Optimizer	Verified (53 days)	S2	9.7.1	Ubuntu	Any	Wrong result for NOT IN subquery on a BIT column while an equivalent materialized query returns the expected row
120981	2026-07-23 9:11	2026-07-29 11:57	MySQL Server: Optimizer	Duplicate (53 days)	S1	9.7.1	Any	Any	IFNULL(NULL, column) Returns NULL in STRAIGHT_JOIN Covering Index Scan, Filtering All Rows
120980	2026-07-23 2:09	2026-08-03 8:23	MySQL Server: DML	Verified (48 days)	S3	8.0.46	Any	Any	DATE column vs INTEGER column comparison returns different results with column reference vs literal value
120976	2026-07-22 4:45	2026-07-22 9:34	MySQL Server: Optimizer	Verified (60 days)	S1	9.3	Any	Any	LATERAL Derived Table Causes IFNULL to Ignore Inner Table Column, Returning NULL for All Rows
120975	2026-07-22 4:42	2026-07-22 9:05	MySQL Server: Optimizer	Verified (60 days)	S1	8.0.46, 8.4.10, 9.7.1	Any	Any	Mixed-Type IFNULL Constant Causes Wrong Integer Conversion in Index Lookup
120974	2026-07-21 18:54	2026-07-22 8:43	MySQL Server: Information schema	Open (60 days)	S2	8.0.34-26	Any	Any	Client connection kill command doesn't kill process
120973	2026-07-21 13:44	2026-07-22 12:10	MySQL Server: Optimizer	Duplicate (60 days)	S2	9.7.1	Any	Any	Redundant outer DISTINCT creates a second temporary-table deduplication above INTERSECT in MySQL
120972	2026-07-21 13:42	2026-07-22 12:09	MySQL Server: Optimizer	Verified (60 days)	S2	8.0.46, 8.4.10, 9.7.1	Any	Any	Redundant outer DISTINCT creates a second temporary-table deduplication above EXCEPT in MySQL
120971	2026-07-21 9:01	2026-08-20 5:52	MySQL Server: Optimizer	Verified (60 days)	S2	8.0.46, 8.4.10, 9.7.1	Any	Any	Redundant IS NOT NULL on SHA2() expression causes extra evaluation and slower execution
120970	2026-07-21 6:38	2026-07-21 17:36	MySQL Server: Optimizer	Duplicate (61 days)	S1	9.7.1	Any	Any	TempTable Engine Incorrectly Treats XOR Result Value 1 as NULL in GROUP BY, Merging Groups
120969	2026-07-21 6:27	2026-07-21 17:38	MySQL Server: Optimizer	Duplicate (61 days)	S1	MySQL 9.7.1	Any	Any	Covering Index Scan Incorrectly Interprets DECIMAL Values as NULL, Causing Wrong Filtering
120968	2026-07-21 6:13	2026-07-21 17:21	MySQL Server: Optimizer	Duplicate (61 days)	S1	MySQL 9.7.1	Any	Any	RIGHT JOIN to LEFT JOIN Rewrite Causes IFNULL Field Mapping to Wrong Table, Returning NULL
120967	2026-07-21 6:04	2026-07-21 17:28	MySQL Server: Optimizer	Duplicate (61 days)	S1	MySQL 9.7.1	Any	Any	DECIMAL DESC Index with Index Condition Pushdown Mis‑evaluates CASE Expression, Incorrectly Keeping Rows
120966	2026-07-21 5:58	2026-07-22 8:41	MySQL Server: Optimizer	Verified (60 days)	S1	8.0.46, 8.4.10, 9.7.1	Any	Any	LEAST Expression Incorrectly Evaluated as Integer for Index Lookup in IN Condition
120956	2026-07-19 12:30	2026-07-22 14:02	MySQL Server: Optimizer	Verified (60 days)	S2	8.0.46, 8.4.10, 9.7.1	Ubuntu	Any	MySQL does not normalize duplicated OR predicates, causing a ~158x execution-time difference for equivalent WHERE clause
120953	2026-07-18 16:47	2026-07-20 7:09	MySQL Server: InnoDB storage engine	Verified (62 days)	S3	9.7	Windows (Windows 11)	Any	Cannot create table - row size too large
120950	2026-07-17 11:52	2026-07-17 11:52	MySQL Server: Documentation	Open	S3		Any	Any	Employee database installation instructions need update for 9.x
120943	2026-07-16 5:53	2026-07-21 16:53	MySQL Server: Optimizer	Duplicate (61 days)	S2	8.0.42, 8.0.44, 8.0.46, 8.4.10	Any (Official mysql Docker images (Linux/aarch64))	Any	Semijoin duplicate-weedout discards valid rows when fed by a rowid filesort
120941	2026-07-16 2:34	2026-07-16 3:21	MySQL Server: InnoDB storage engine	Open (66 days)	S3	8.4.7-7	Any	Any	Contribution by ByteDance RDS MySQL team: InnoDB may permanently skip an undo record during shutdown
120935	2026-07-15 10:45	2026-07-22 14:06	MySQL Server: Optimizer	Verified (60 days)	S2	8.0.46, 8.4.10, 9.7.1	Any	Any	Duplicate equivalent EXISTS predicate is not eliminated and causes a much slower execution plan
120929	2026-07-14 16:35	2026-07-21 8:24	MySQL Server: Documentation	Verified (61 days)	S3	9.7.1	Any	Any	LATEST FOREIGN KEY ERROR is not printed in SHOW ENGINE INNODB STATUS
120926	2026-07-14 14:07	2026-07-21 18:21	MySQL Server: Optimizer	Verified (61 days)	S3	8.4.10	Any	Any	Wrong result with CTE, AVG(DECIMAL), GROUP BY, comparison, and UNION
120925	2026-07-14 14:04	2026-07-21 18:19	MySQL Server: Optimizer	Verified (61 days)	S3	8.4.10	Any	Any	Wrong result with VIEW, GROUP_CONCAT, JSON_QUOTE, UPPER, and UNION
120924	2026-07-14 13:59	2026-07-21 18:14	MySQL Server: Optimizer	Verified (61 days)	S3	8.4.10	Any	Any	Wrong result with VIEW, GROUP_CONCAT, JSON_QUOTE, HEX, LOWER, and self JOIN
120923	2026-07-14 13:53	2026-07-21 18:06	MySQL Server: Optimizer	Verified (61 days)	S3	8.4.10	Any	Any	Wrong result with CTE, UNION ALL, GROUP BY, and COUNT()
120921	2026-07-14 13:51	2026-07-21 18:23	MySQL Server: Optimizer	Verified (61 days)	S3	8.0.46, 8.4.10, 9.7.1	Any	Any	Wrong result with VIEW, GROUP BY, STDDEV(DOUBLE), and IN subquery
120920	2026-07-14 13:45	2026-07-15 8:42	MySQL Server: Optimizer	Duplicate (67 days)	S3	8.4.10	Any	Any	Wrong result with VIEW, EXISTS, BINARY comparison, and LEFT JOIN
120918	2026-07-14 10:56	2026-09-18 11:50	MySQL Server: Optimizer	Closed (2 days)	S3	9.5.0	Any	Any	MySQL returns the wrong column alias for an empty result query
120917	2026-07-14 10:34	2026-08-06 14:48	MySQL Server: Optimizer	Patch pending (67 days)	S3	9.5.0	Any	Any	Adding OR FALSE to an IN-subquery predicate changes the query result
120915	2026-07-14 7:17	2026-07-14 10:23	MySQL Server: Optimizer	Not a Bug (68 days)	S2	9.5.0	Any	Any	Adding Redundant OR FALSE Lets Optimizer Detect Impossible WHERE
120912	2026-07-13 15:04	2026-07-14 6:52	MySQL Server: Security: Privileges	Open	S3	8.4.10	Any	Any	REQUIRE SUBJECT/ISSUER authentication fails on OpenSSL 3.x (RHEL 9) due to X509_NAME_oneline() escaping + as \+
120911	2026-07-13 13:28	2026-07-14 7:03	MySQL Server: Optimizer	Verified (68 days)	S2	9.6.0,9.7.0	Ubuntu	Any	Wrong result after predicate pushdown to HAVING for SUM(DOUBLE) in VIEW/CTE
120910	2026-07-13 12:29	2026-07-14 12:31	MySQL Server: Optimizer	Verified (68 days)	S3	8.4.10	Any	Any	Wrong result with VIEW, EXISTS, BINARY comparison, nullable boolean expression, and RIGHT JOIN
120909	2026-07-13 11:05	2026-07-21 15:16	MySQL Server: Optimizer	Verified (68 days)	S1	8.0.46, 8.4.10, 9.7.1	Any	Any	ROLLUP Incorrectly Sets Base Group Row to NULL for Constant Folded Expression
120908	2026-07-13 10:50	2026-07-20 11:16	MySQL Server: Optimizer	Verified (68 days)	S1	9.1	Any	Any	DISTINCTROW with GROUP BY in Derived Table Loses Rows Due to Incomplete Duplicate Removal Key
120907	2026-07-13 10:36	2026-07-21 15:19	MySQL Server: Optimizer	Verified (68 days)	S1	8.0.46, 8.4.10, 9.7.1	Any	Any	Index Lookup Loses Unary Plus Operator During Condition Pushdown, Causing String-to-Integer Truncation and Wrong Match
120906	2026-07-13 10:18	2026-07-14 12:50	MySQL Server: Optimizer	Verified (68 days)	S3	8.4.10	Any	Any	Wrong result with VIEW, UNION, NOT IN, NULL-safe equality, and LENGTH()
120905	2026-07-13 10:06	2026-07-20 11:02	MySQL Server: Optimizer	Verified (68 days)	S1	9.1	Any	Any	CASE Expression with Mixed FLOAT/INT Constant Returns Different Results in Single Table vs. Derived Table Due to Type In
120904	2026-07-13 9:59	2026-07-22 6:01	MySQL Server: Optimizer	Duplicate (60 days)	S3	8.4.10	Any	Any	Wrong/inconsistent result between VIEW and CTE with UNION ALL, EXISTS, and integer division
120903	2026-07-13 9:57	2026-07-21 15:45	MySQL Server: Optimizer	Verified (68 days)	S1	8.0.46, 8.4.10, 9.7.1	Any	Any	WITH ROLLUP in Derived Table Incorrectly Evaluates IFNULL Expression Due to Partial NULL Propagation
120902	2026-07-13 9:13	2026-07-14 13:06	MySQL Server: Optimizer	Verified (68 days)	S5	9.7.1	Linux (Ubuntu (22.04.4 LTS))	x86 (x86_64, Intel(R) Xeon(R) Gold 5220)	Hash join AccessPath double-applies probe-side condition filtering
120901	2026-07-13 8:53	2026-09-09 15:17	MySQL Server: InnoDB storage engine	Verified (68 days)	S3	8.4.9, 8.4.10	Any	Any	SELECT ... LOCK IN SHARE MODE returns different row sets depending on index choice under RC/RU
120900	2026-07-13 8:03	2026-08-06 14:48	MySQL Server: Optimizer	Patch pending (48 days)	S2	8.0.46, 8.4.10, 9.7.1	Any	Any	Redundant OR FALSE Predicate Causes a Much Slower Plan
120899	2026-07-13 7:34	2026-08-03 13:59	MySQL Server: Optimizer	Verified (48 days)	S2	8.0.46, 8.4.10, 9.7.1	Any	Any	An equivalent query becomes much slower after a redundant duplicated IN-subquery predicate is added
120896	2026-07-08 23:11	2026-07-08 23:11	MySQL Server: Logging	Open	S3	8.4.10	Any	Any	General query log inconsistency: SECURITY DEFINER function/trigger bodies logged as definer (host %); SP body not logged
120890	2026-07-08 6:48	2026-07-08 11:14	MySQL Server: Optimizer	Duplicate (74 days)	S3	9.5.0	Any	Any	reply for bug#120821
120887	2026-07-07 10:53	2026-07-07 10:53	MySQL Server: Tests	Open	S3	26.7.0-er	MacOS (26.5.2)	Any	merge_large_tests-t hanging at Bgc_ticket_manager_test.Several_tickets_test
120880	2026-07-06 22:41	2026-07-14 15:27	MySQL Server: Information schema	Closed (68 days)	S3	26.7.0-er	Any	Any	thread_pool plugin reports PLUGIN_LICENSE = PROPRIETARY in Community Server 26.7
120874	2026-07-06 13:30	2026-09-14 13:14	MySQL Server: Optimizer	Verified (75 days)	S3	8.4.x, 9.7.x	Any	Any	MySQL's INET6_NTOA function is not RFC 5952 complaint
120870	2026-07-06 5:20	2026-07-07 6:30	MySQL Server: Optimizer	Verified (75 days)	S5	9.7.1	Ubuntu (22.04.4 LTS)	x86 (x86_64, Intel(R) Xeon(R) Gold 5220)	Hypergraph misses BETWEEN equality, causing 100x slowdown
120869	2026-07-05 10:46	2026-07-06 5:40	MySQL Server: Optimizer	Verified (76 days)	S5	9.7.1	Ubuntu (22.04.4 LTS)	x86 (x86_64, Intel(R) Xeon(R) Gold 5220)	Optimizer chooses 26x slower join order due to fanout misestimation despite histograms
120868	2026-07-05 8:42	2026-07-06 5:30	MySQL Server: Optimizer	Verified (76 days)	S5	9.7.1	Linux (22.04.4 LTS)	x86 (x86_64, Intel(R) Xeon(R) Gold 5220)	Optimizer misses ORDER BY LIMIT optimization when ordering key is equivalent through join equality
120867	2026-07-04 10:14	2026-07-21 15:50	MySQL Server: Optimizer	Verified (76 days)	S1	8.0.46, 8.4.10, 9.7.1	Any	Any	Const Table Optimization Incorrectly Evaluates FLOAT Comparison with Extreme DOUBLE Constant Due to Overflow
120866	2026-07-04 10:08	2026-07-06 5:46	MySQL Server: Optimizer	Duplicate (76 days)	S1	MySQL 9.7.1	Any	Any	Hash Join with CTE Materialization Incorrectly Treats Non‑NULL Columns as NULL, Causing LEAST to Return NULL
120865	2026-07-04 9:50	2026-07-04 13:47	MySQL Server: Optimizer	Duplicate (78 days)	S1	MySQL 9.7.1	Any	Any	MIN(DISTINCT IFNULL(NULL, col)) Returns NULL After JOIN with JSON Subquery Due to Incorrect DISTINCT Temporary Table Han
120864	2026-07-04 9:34	2026-07-04 13:47	MySQL Server: Optimizer	Duplicate (78 days)	S1	MySQL 9.7.1	Any	Any	AGGREGATE_THEN_MERGE Causes Incorrect Column Mapping for GROUP BY Expression, Returning NULL Instead of Actual Value
120863	2026-07-04 9:15	2026-07-04 13:46	MySQL Server: Optimizer	Duplicate (78 days)	S1	MySQL 9.7.1	Any	Any	Scalar Subquery Column Loses Non‑NULL Values in DISTINCT Temporary Table, All Rows Become NULL
120862	2026-07-04 9:09	2026-07-04 13:45	MySQL Server: Optimizer	Duplicate (78 days)	S1	MySQL9.7.1	Any	Any	LEFT JOIN Rewrite with Condition Pushdown Incorrectly Binds Column to Right Table, Causing All Rows to Be Filtered Out
120861	2026-07-03 12:43	2026-07-04 13:48	MySQL Server: Optimizer	Verified (78 days)	S5	9.7.1	Ubuntu (22.04.4 LTS)	x86 (x86_64, Intel(R) Xeon(R) Gold 5220)	SELECT DISTINCT inner join expands duplicate-insensitive fanout instead of using semijoin/existence semantics
120859	2026-07-03 9:14	2026-07-03 9:20	MySQL Server: InnoDB storage engine	Open	S3	8.0.30	Any	Any	mysqld crashes with SIGSEGV in temptable::Block::can_accommodate() due to shared_block_pool use-after-free race conditio
120857	2026-07-03 6:23	2026-07-07 7:25	MySQL Server: Optimizer	Verified (75 days)	S2	9.6.0,9.7.0	Ubuntu	Any	Wrong result with LOWER(REVERSE(ST_AsGeoJSON())) comparison under utf8mb4_bin collation in VIEW/CTE
120856	2026-07-03 6:15	2026-07-08 8:18	MySQL Server: Data Types	Verified (74 days)	S2	9.7.0	Any	Any	COERCIBILITY() differs for expression-derived strings between VIEW/CTE and TEMPORARY TABLE
120855	2026-07-03 6:02	2026-07-07 7:18	MySQL Server: Optimizer	Verified (75 days)	S2	9.6.0,9.7.0	Ubuntu	Any	Wrong result with QUOTE(NULL) in VIEW/CTE WHERE predicate
120854	2026-07-03 5:49	2026-07-06 15:23	MySQL Server: Optimizer	Verified (76 days)	S2	9.6.0,9.7.0	Ubuntu	Any	Wrong result with COALESCE(YEAR, 0), arithmetic and window function in VIEW/CTE
120853	2026-07-03 5:42	2026-07-03 10:12	MySQL Server: Optimizer	Verified (79 days)	S2	9.6.0,9.7.0	Ubuntu	Any	Wrong result with LOWER(JSON), UPPER() comparison and utf8mb4_bin collation in VIEW/CTE
120852	2026-07-03 5:32	2026-07-03 10:09	MySQL Server: Data Types	Verified (79 days)	S2	9.6.0,9.7.0	Ubuntu	Any	Wrong result with YEAR() over DATE after UNION: value displayed as 0000 but satisfies vc > 1970
120851	2026-07-03 5:24	2026-07-03 16:17	MySQL Server: Data Types	Duplicate (79 days)	S2	9.6.0,9.7.0	Ubuntu	Any	Wrong result / inconsistent comparison behavior for TIME() expression between VIEW/CTE and TEMPORARY TABLE
120850	2026-07-03 3:32	2026-07-03 9:57	MySQL Server: Optimizer	Verified (79 days)	S5	9.7.1	Linux (Ubuntu (22.04.4 LTS))	x86 (x86_64, Intel(R) Xeon(R) Gold 5220)	Optimizer misses impossible INNER JOIN condition with IS NULL and normal equality
120849	2026-07-02 17:52	2026-07-03 11:01	MySQL Server: Data Types	Duplicate (79 days)	S2	9.6.0	Ubuntu	Any	Wrong result / inconsistent comparison behavior for SEC_TO_TIME() expression between VIEW/CTE and TEMPORARY TABLE
120848	2026-07-02 17:43	2026-07-03 16:34	MySQL Server: Data Types	Verified (79 days)	S2	9.6.0	Ubuntu	Any	Inconsistent comparison behavior for MAKETIME() expression between VIEW/CTE and TEMPORARY TABLE
120847	2026-07-02 17:28	2026-07-03 9:22	MySQL Server: Data Types	Verified (79 days)	S2	9.6.0	Ubuntu	Any	Inconsistent comparison behavior for ENUM-derived CASE expression between VIEW/CTE and TEMPORARY TABLE
120846	2026-07-02 17:00	2026-07-03 7:49	MySQL Server: Optimizer	Verified (79 days)	S2	9.6.0	Ubuntu	Any	Wrong result with CTE, AVG(NUMERIC(62)), MIN() and derived table join
120845	2026-07-02 16:55	2026-07-03 7:44	MySQL Server: Optimizer	Verified (79 days)	S2	9.6.0	Ubuntu	Any	Wrong result with CTE, nested STDDEV_POP(), GROUP BY and UNION
120844	2026-07-02 16:47	2026-07-03 16:21	MySQL Server: Optimizer	Can't repeat (79 days)	S2	9.6.0	Ubuntu	Any	Wrong result with VIEW, DAYNAME(), UNION and NOT IN subquery
120843	2026-07-02 16:43	2026-07-03 9:14	MySQL Server: Optimizer	Verified (79 days)	S2	9.6.0	Ubuntu	Any	VIEW and CTE return wrong results with YEAR(), UNION and uncorrelated EXISTS subquery
120842	2026-07-02 16:34	2026-07-02 20:22	MySQL Server: Optimizer	Verified (80 days)	S2	9.6.0	Ubuntu	Any	Wrong result with CTE, DISTINCT, NULL vs empty string, GROUP_CONCAT() and UNION
120841	2026-07-02 16:26	2026-07-02 20:14	MySQL Server: Optimizer	Verified (80 days)	S2	9.6.0	Ubuntu	Any	Wrong result with CTE, ORDER BY LIMIT, GROUP BY, SUM() and outer UNION
120840	2026-07-02 16:20	2026-07-02 20:09	MySQL Server: Optimizer	Verified (80 days)	S2	9.6.0	Ubuntu	Any	VIEW and equivalent CTE differ when LOWER(JSON_TYPE(...)) is compared with JSON_TYPE() result in a UNION query
120839	2026-07-02 15:37	2026-07-02 20:04	MySQL Server: Optimizer	Verified (80 days)	S2	9.6.0	Ubuntu	Any	Wrong result with CTE, YEAR column, scalar subquery, outer UNION and MAX() aggregate
120838	2026-07-02 15:28	2026-08-10 18:00	MySQL Server: Optimizer	Verified (41 days)	S2	9.6.0	Ubuntu	Any	Wrong result with CTE, UNION, BIT column and NOT IN subquery containing NULL
120837	2026-07-02 15:20	2026-07-02 19:44	MySQL Server: Optimizer	Verified (80 days)	S2	9.6.0	Any	Any	Wrong result with CTE, UNION ALL, GROUP BY/HAVING and LOCATE('', column)
120836	2026-07-02 15:08	2026-07-02 19:35	MySQL Server: Optimizer	Verified (80 days)	S2	9.6.0	Ubuntu	Any	Wrong result with VIEW, UNION, MAKETIME(), MEDIUMTEXT and NOT IN subquery containing NULL
120835	2026-07-02 14:24	2026-07-02 14:24	MySQL Server: InnoDB storage engine	Open	S3	9.7.0	Any	Any	UBSan error on log0log.log_writer test
120834	2026-07-02 10:38	2026-07-21 16:25	MySQL Server: Optimizer	Verified (80 days)	S1	8.0.46, 8.4.10, 9.7.1	Any	Any	AVG on Large DOUBLE Values Returns Inconsistent Results Across Execution Paths (Index Scan vs. Temporary Table)
120833	2026-07-02 10:32	2026-07-21 16:27	MySQL Server: Optimizer	Verified (79 days)	S1	8.0.46, 8.4.10, 9.7.1	Any	Any	Index Lookup Truncates DOUBLE to BIGINT for IF(NULL, …) and GREATEST(string, double) in IN Conditions
120832	2026-07-02 10:02	2026-07-20 11:08	MySQL Server: Optimizer	Verified (80 days)	S1	9.1	Any	Any	WITH ROLLUP Super‑Aggregate Row Missing in Zero Input Rows Short‑Circuit Path
120830	2026-07-02 3:11	2026-07-02 9:34	MySQL Server: Optimizer	Verified (80 days)	S5	9.7.1	Ubuntu (22.04.4 LTS)	x86 (x86_64, Intel(R) Xeon(R) Gold 5220)	Optimizer chooses 2800x slower join order despite lower-cost JOIN_PREFIX plan
120829	2026-07-01 22:32	2026-08-12 3:40	MySQL Server: Optimizer	Verified (39 days)	S5	8.0.48, 8.4.11	Any	Any	Functional index intermittently unusable under concurrent load: possible_keys=NULL, FORCE INDEX silently ignored
120827	2026-07-01 12:25	2026-07-01 12:25	MySQL Server: InnoDB storage engine	Open	S5	8.0.45	Linux	Any	Clarification on deadlock during concurrent INSERT into secondary index without preceding locking reads
120821	2026-07-01 8:16	2026-07-08 11:11	MySQL Server: Optimizer	Verified (74 days)	S2	9.5.0	Any	Any	SELECT DISTINCT makes an equivalent query ~170x faster on round90.t1 in MySQL 9.5.0
120817	2026-06-30 8:54	2026-07-08 11:08	MySQL Server: InnoDB storage engine	Can't repeat (74 days)	S1	8.0.42	Other (kylinV10)	x86 (intel)	mysqld startup error
120814	2026-06-30 2:27	2026-06-30 10:28	MySQL Server: Optimizer	Duplicate (82 days)	S2	8.0.46	Any	Any	Wrong result with indexed INT comparison to fractional DECIMAL/function expression
120809	2026-06-29 7:31	2026-07-02 14:07	MySQL Server: Optimizer	Verified (80 days)	S5	9.7.1 and 8.0.31	Ubuntu (22.04.4 LTS)	Any	Optimizer misses DISTINCT early-out and chooses 40M-row hash join Cartesian product
120804	2026-06-28 13:41	2026-06-28 21:27	MySQL Server: InnoDB storage engine	Open	S1	mysql 8.4.9	Ubuntu (20.04)	x86	Unexpected deadlock under RR/SER when updating a row already locked by the same transaction
120803	2026-06-28 13:20	2026-06-29 2:51	MySQL Server: Optimizer	Verified (83 days)	S1	9.6	Any	Any	CTE Materialization Causes LEAST to Degenerate from String Comparison to Numeric Comparison
120802	2026-06-28 12:34	2026-06-28 20:51	MySQL Server: Optimizer	Can't repeat (84 days)	S1	MySQL 9.6	Any	Any	Index Lookup with COALESCE Constant Causes Truncation to 0, Incorrectly Matching BIGINT Column
120801	2026-06-28 12:22	2026-06-29 6:15	MySQL Server: Optimizer	Not a Bug (83 days)	S1	MySQL 9.6	Any	Any	ROW_NUMBER() Aligned Derived Table Causes Inconsistent Comparison Behavior for LEAST(Double, Double) = BIGINT Condition
120800	2026-06-28 11:51	2026-06-29 2:48	MySQL Server: Optimizer	Not a Bug (83 days)	S1	MySQL 9.6	Any	Any	LATERAL Derived Table Merge Causes Type Propagation Error, FLOAT Precision Loss in CASE Expression Constants
120799	2026-06-28 8:09	2026-09-09 15:21	MySQL Server: InnoDB storage engine	Duplicate (11 days)	S2	mysql 8.4.9	Ubuntu (20.04)	x86	SELECT ... LOCK IN SHARE MODE returns different row sets depending on index choice under RC/RU
120797	2026-06-27 15:18	2026-07-02 13:29	MySQL Server: Optimizer	Verified (80 days)	S5	9.7.1	Ubuntu (22.04.4 LTS)	x86	Poor plan for DISTINCT Cartesian product: hash join materializes full product while NO_BNL is about 50x faster
120793	2026-06-27 11:52	2026-07-08 9:30	MySQL Server: Optimizer	Verified (74 days)	S5	9.7.1	Ubuntu (22.04.4 LTS)	x86 (Intel(R) Xeon(R) Gold 5220 CPU @ 2.20GHz)	Default heuristic pruning misses join-connected prefix in 3-table query, causing ~40x slower plan
120789	2026-06-26 11:14	2026-06-26 14:32	MySQL Server: DML	Not a Bug (86 days)	S3	9.7.0	Any	Any	TIMESTAMPDIFF/DAYOFYEAR/WEEKDAY ignore ALLOW_INVALID_DATES
120787	2026-06-26 11:04	2026-09-14 10:17	MySQL Server: Optimizer	Closed (6 days)	S2	9.7.0	Any	Any	IN (DATE/TIME constant list) wrongly TRUE for non-temporal string
120786	2026-06-26 4:51	2026-06-26 8:50	MySQL Server: Optimizer	Duplicate (86 days)	S1	MySQL 9.6	Any	Any	Derived Table Materialization with Pushed-Down IN Condition Causes Empty Result Instead of NULL for Aggregate
120785	2026-06-26 4:17	2026-06-26 9:20	MySQL Server: Optimizer	Duplicate (86 days)	S1	MySQL 9.6	Any	Any	Temporary Table Deduplication Uses Binary Comparison for FLOAT -0 and +0, Incorrectly Treating Them as Distinct Values
120782	2026-06-25 20:24	2026-06-26 4:47	MySQL Server: Optimizer	Verified (86 days)	S2	9.7.0	Linux	Any	Derived merge: temporal expr ignores NULL-extended LEFT JOIN row
120781	2026-06-25 20:22	2026-06-26 6:48	MySQL Server: DML	Duplicate (86 days)	S2	9.7.0	Linux	Any	DECIMAL BETWEEN returns NULL for every row evaluated after a NULL row
120780	2026-06-25 20:19	2026-06-26 7:00	MySQL Server: DML	Verified (86 days)	S2	9.7.0	Linux	Any	Nested DATE_ADD on a date string adds spurious 00:00:00, drops WHERE rows
120779	2026-06-25 20:16	2026-09-14 10:27	MySQL Server: DML	Closed (6 days)	S2	9.7.0	Linux	Any	POW(x, NULL) returns 1 instead of NULL (NULL exponent ignored)
120777	2026-06-25 19:24	2026-06-26 6:29	MySQL Server: Replication	Verified (86 days)	S3	8.4.9, 9.7.0	Linux	Any	Replica crash on short Format_description_event post_header_len
120774	2026-06-25 12:16	2026-06-25 12:16	MySQL Server: Replication	Open	S2	8.4.8	Linux	Any	replication worker thread dealock
120773	2026-06-25 11:54	2026-06-26 10:38	MySQL Server: Optimizer	Verified (86 days)	S5	9.7.1	Ubuntu (Ubuntu (22.04.4 LTS))	x86 (Intel(R) Xeon(R) Gold 5220 CPU @ 2.20GHz)	Hash join misses DISTINCT ORDER BY LIMIT early termination
120772	2026-06-25 10:27	2026-07-08 9:03	MySQL Server: Optimizer	Verified (74 days)	S5	9.7.1 and 8.0.31	Ubuntu (22.04.4 LTS)	x86 (Intel(R) Xeon(R) Gold 5220 CPU @ 2.20GHz)	UPDATE HISTOGRAM causes optimizer to use stale cardinalities and miss faster join order
120758	2026-06-24 6:13	2026-07-14 14:43	MySQL Server: InnoDB storage engine	Open	S3		Any	Any	Add logging for redo log scan performance statistics
120757	2026-06-24 6:04	2026-09-17 16:47	MySQL Server: Replication	Closed (3 days)	S2	8.4	Any	Any	"Start Transaction" modifier in the binary log cannot be replayed on an instance that does not have binary logs enabled.

Showing all 273 (Edit, Save, CSV, Feed)