| Showing all 267 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 120943 | 2026-07-16 5:53 | 2026-07-16 5:53 | MySQL Server: Optimizer | Open | 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 (1 day) | 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-15 10:45 | MySQL Server: Optimizer | Open | S2 | 9.5.0 | Any | Any | Duplicate equivalent EXISTS predicate is not eliminated and causes a much slower execution plan |
| 120933 | 2026-07-15 9:54 | 2026-07-15 9:54 | MySQL Server: InnoDB storage engine | Open | S3 | 8.4.7-7 | Any | Any | mysqld crash during shutdown |
| 120929 | 2026-07-14 16:35 | 2026-07-14 16:35 | MySQL Server: InnoDB storage engine | Open | 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-14 14:07 | MySQL Server: Optimizer | Open | 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-14 14:04 | MySQL Server: Optimizer | Open | 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-14 13:59 | MySQL Server: Optimizer | Open | 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-14 13:53 | MySQL Server: Optimizer | Open | S3 | 8.4.10 | Any | Any | Wrong result with CTE, UNION ALL, GROUP BY, and COUNT() |
| 120921 | 2026-07-14 13:51 | 2026-07-14 13:51 | MySQL Server: Optimizer | Open | S3 | 8.4.10 | 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 (2 days) | S3 | 8.4.10 | Any | Any | Wrong result with VIEW, EXISTS, BINARY comparison, and LEFT JOIN |
| 120918 | 2026-07-14 10:56 | 2026-07-15 5:25 | MySQL Server: Optimizer | Verified (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-07-15 5:23 | MySQL Server: Optimizer | Verified (2 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 (3 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 (3 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 (3 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-14 12:38 | MySQL Server: Optimizer | Verified (3 days) | S1 | MySQL 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-14 12:42 | MySQL Server: Optimizer | Verified (3 days) | S1 | MySQL 9.7.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-14 12:46 | MySQL Server: Optimizer | Verified (3 days) | S1 | MySQL 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 (3 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-14 12:56 | MySQL Server: Optimizer | Verified (3 days) | S1 | MySQL 9.7.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-13 9:59 | MySQL Server: Optimizer | Open | 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-14 13:03 | MySQL Server: Optimizer | Verified (3 days) | S1 | MySQL 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 (3 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-07-14 13:12 | MySQL Server: Optimizer | Verified (3 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-07-15 7:51 | MySQL Server: Optimizer | Open (2 days) | S2 | 9.5.0 | Any | Any | Redundant OR FALSE Predicate Causes a Much Slower Plan |
| 120899 | 2026-07-13 7:34 | 2026-07-13 7:34 | MySQL Server: Optimizer | Open | S2 | 9.5.0 | 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 (9 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 (3 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-07-07 6:42 | MySQL Server: Optimizer | Verified (10 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 (10 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 (11 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 (11 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-06 11:36 | MySQL Server: Optimizer | Verified (11 days) | S1 | MySQL 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 (11 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 (13 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 (13 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 (13 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 (13 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 (13 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 (10 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 (9 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 (10 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 (11 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 (14 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 (14 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 (14 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 (14 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 (14 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 (14 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 (14 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 (14 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 (14 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 (14 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 (14 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 (15 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 (15 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 (15 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 (15 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-07-02 19:57 | MySQL Server: Optimizer | Verified (15 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 (15 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 (15 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-02 19:03 | MySQL Server: Optimizer | Verified (15 days) | S1 | 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-03 1:33 | MySQL Server: Optimizer | Verified (14 days) | S1 | 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-02 18:06 | MySQL Server: Optimizer | Verified (15 days) | S1 | 9.7.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 (15 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-07-01 22:32 | MySQL Server: Optimizer | Open | S5 | 8.4.10, but not 9.7 | 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 (9 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 (9 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 (17 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 (15 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 (18 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 (19 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 (18 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 (18 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-06-29 17:29 | MySQL Server: InnoDB storage engine | Open (18 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 (15 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 (9 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 (21 days) | S3 | 9.7.0 | Any | Any | TIMESTAMPDIFF/DAYOFYEAR/WEEKDAY ignore ALLOW_INVALID_DATES |
| 120787 | 2026-06-26 11:04 | 2026-06-27 2:48 | MySQL Server: Optimizer | Documenting (21 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 (21 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 (21 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 (21 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 (21 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 (21 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-06-26 20:48 | MySQL Server: DML | Documenting (21 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 (21 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 (21 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 (9 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-07-16 20:48 | MySQL Server: Replication | Patch pending (1 day) | 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. |
| 120739 | 2026-06-22 11:42 | 2026-06-22 11:56 | MySQL Server: Replication | Open | S1 | 5.7.25 | Linux | x86 | Corruption of the index file caused stale binary log entries to be re-applied after executing FLUSH LOGS |
| 120738 | 2026-06-22 10:55 | 2026-06-22 11:26 | MySQL Server: Replication | Open | S1 | 5.7.25 | Linux (6) | x86 | Corruption of the index file caused stale binary log entries to be re-applied after executing FLUSH LOGS |
| 120737 | 2026-06-22 8:28 | 2026-06-22 10:31 | MySQL Server: Optimizer | Verified (25 days) | S1 | 8.0.45 | Any | Any | Inconsistent CAST Handling of Out-of-Range TEXT Values in Single Table vs. View/Join Paths |
| 120736 | 2026-06-22 6:46 | 2026-07-08 8:56 | MySQL Server: Optimizer | Verified (9 days) | S3 | 9.6.0 | Any | Any | FORCE INDEX make a query with OR (NOT NULL column <=> NULL) degrade from an index range scan to a full table scan |
| 120735 | 2026-06-21 14:10 | 2026-06-22 10:19 | MySQL Server: Optimizer | Not a Bug (25 days) | S1 | MySQL 9.6 | Any | Any | Index Range Scan Incorrectly Shrinks Range for IN Predicate with EXISTS and CAST(NULL AS SIGNED), Missing Rows |
| 120734 | 2026-06-20 14:02 | 2026-06-22 9:59 | MySQL Server: Optimizer | Verified (25 days) | S1 | 8.0.45 | Any | Any | Constant Table Optimization Ignores WHERE Condition for MAX(DISTINCT), Returning Incorrect Non-NULL Value |
| 120733 | 2026-06-20 13:38 | 2026-06-22 9:29 | MySQL Server: Optimizer | Verified (25 days) | S1 | MySQL 9.6 | Any | Any | DISTINCTROW with ROW_NUMBER() Derived Table and GROUP BY Causes Duplicate Removal Key to Miss a Non‑Aggregate Column, Me |
| 120732 | 2026-06-20 13:22 | 2026-06-22 6:37 | MySQL Server: Optimizer | Verified (25 days) | S3 | MySQL 9.6 | Any (Storage Engine: InnoDB) | Any | Derived Table Merging Causes Incorrect Duplicate Removal with DISTINCT + GROUP BY + SUM(DISTINCT EXISTS(subquery)) |
| 120721 | 2026-06-18 1:41 | 2026-06-18 11:41 | MySQL Server: Optimizer | Duplicate (29 days) | S1 | MySQL 9.6 | Any (Storage Engine: InnoDB) | Any | Auto-Key Data Type Truncation During Materialized Derived Table Lookup Causes Incorrect IN Match (Should Return Empty) |
| 120716 | 2026-06-17 12:31 | 2026-06-17 12:53 | MySQL Server: Optimizer | Verified (30 days) | S1 | 8.0.45 | Any (Storage Engine: MEMORY) | Any | MEMORY Engine Empty Outer Join Derived Table Causes Incorrect Aggregate Result (Should Be NULL) |
| 120715 | 2026-06-17 8:28 | 2026-06-18 2:12 | MySQL Server: InnoDB storage engine | Open (29 days) | S2 | 9.7.0 | Any | Any | Unexpected deadlock when one of the two transactions does not acquire any locks |
| 120713 | 2026-06-17 7:11 | 2026-07-08 8:49 | MySQL Server: Optimizer | Duplicate (9 days) | S5 | 8.0.24, 8.0.33 | Any | Any | Optimizer incorrectly prefers ordering index over selective index for ORDER BY … LIMIT 1 |
| 120712 | 2026-06-17 6:44 | 2026-07-09 6:19 | MySQL Server: Optimizer | Verified (8 days) | S3 | 9.7.0 | Any | Any | Inconsistent EXPLAIN row estimation |
| 120699 | 2026-06-16 5:52 | 2026-06-16 13:31 | MySQL Server: Optimizer | Duplicate (31 days) | S2 | 9.7.0, 9.6.0 | Any | Any | WHERE clause incorrectly returns rows when using COALESCE/IFNULL/LEAST/GREATEST on DECIMAL column |
| 120698 | 2026-06-16 3:17 | 2026-07-01 2:39 | MySQL Server: InnoDB storage engine | Open (16 days) | S1 | 8.0.44 | Any | Any | Contribution by Tencent: Compressed pages' records may out of order when using change buffer |
| 120690 | 2026-06-15 13:33 | 2026-06-16 7:40 | MySQL Server: DML | Verified (31 days) | S3 | 8.0.46 | Any | Any | CHAR type: inconsistent behavior between WHERE clause and UNIQUE constraint when comparing strings with trailing spaces |
| 120684 | 2026-06-15 3:22 | 2026-06-15 3:28 | MySQL Server: InnoDB storage engine | Open (32 days) | S2 | 9.4.0 | Any | Any | Inconsistent deadlock of UPDATE and SELECT FOR UPDATE with the same WHERE clause |
| 120683 | 2026-06-14 15:21 | 2026-07-09 5:10 | MySQL Server: Optimizer | Verified (8 days) | S5 | 9.7.0 | Any | Any | Optimizer overestimates cost and rows for LIMIT 1 without ORDER BY on a primary key index |
| 120681 | 2026-06-14 5:43 | 2026-06-14 5:43 | MySQL Server: FULLTEXT search | Open | S2 | 9.7 | Debian (Debian GNU/Linux 12 (bookworm)) | x86 ((86_64) | ngram FULLTEXT parser fails to match certain Latin tokens (e.g. "Sarah") in any query mode |
| 120680 | 2026-06-13 17:35 | 2026-06-30 16:35 | MySQL Server: Optimizer | Duplicate (17 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `NOT (col != COALESCE(NULL, ...))` |
| 120679 | 2026-06-13 17:35 | 2026-06-30 16:27 | MySQL Server: Optimizer | Duplicate (17 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `NOT (col NOT IN IFNULL(...))` |
| 120678 | 2026-06-13 17:34 | 2026-06-30 13:47 | MySQL Server: Optimizer | Duplicate (17 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `NOT IN (LEAST(NULL, ...)) IS UNKNOWN` |
| 120677 | 2026-06-13 17:33 | 2026-06-30 13:29 | MySQL Server: Optimizer | Verified (17 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `col OR GREATEST(...)` |
| 120676 | 2026-06-13 17:33 | 2026-06-30 13:23 | MySQL Server: Optimizer | Duplicate (17 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `COALESCE(...) && (literal IN col)` |
| 120675 | 2026-06-13 17:32 | 2026-06-30 13:24 | MySQL Server: Optimizer | Verified (17 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `CAST(NULL) IN col || CASE ... IN col` |
| 120674 | 2026-06-13 17:32 | 2026-06-26 4:38 | MySQL Server: Optimizer | Verified (21 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `CASE with EXISTS` compared to column |
| 120673 | 2026-06-13 17:31 | 2026-06-22 9:07 | MySQL Server: Optimizer | Duplicate (25 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `NOT (literal NOT IN col)` |
| 120672 | 2026-06-13 17:31 | 2026-06-15 12:50 | MySQL Server: Optimizer | Duplicate (32 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `NOT (IFNULL(col, n) OR (col = literal))` |
| 120671 | 2026-06-13 17:30 | 2026-06-15 13:29 | MySQL Server: Optimizer | Duplicate (32 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `col IN (IF(...))` |
| 120670 | 2026-06-13 17:30 | 2026-06-16 6:38 | MySQL Server: Optimizer | Not a Bug (31 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `NOT(...) && GREATEST(...) AND literal` |
| 120669 | 2026-06-13 17:29 | 2026-06-16 5:35 | MySQL Server: Optimizer | Verified (31 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `CASE + LIKE + XOR` with `||` |
| 120668 | 2026-06-13 17:28 | 2026-06-15 12:40 | MySQL Server: Optimizer | Verified (32 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `LEAST(...) IN (col)` |
| 120666 | 2026-06-12 15:58 | 2026-06-16 6:23 | MySQL Server: Optimizer | Verified (32 days) | S5 | 9.7.0 | Any | Any | Optimizer fails to convert ABS(column) < constant to range scan, resulting in full table scan |
| 120665 | 2026-06-12 10:19 | 2026-06-15 8:49 | MySQL Server: Optimizer | Open (32 days) | S2 | 8.4.8 | Any | Any | Non optimal query plan chosen for DML |
| 120663 | 2026-06-12 2:32 | 2026-06-29 21:35 | MySQL Server: Command-line Clients | Documenting (22 days) | S3 | Any | Any | Contribution: Bug #44929 #92403 #110570: Fix tty password length handling | |
| 120662 | 2026-06-11 22:16 | 2026-06-12 6:14 | MySQL Server: InnoDB storage engine | Open | S3 | Any | Any | Contribution: Use public variable name innodb_open_files in open-file timeo ... | |
| 120649 | 2026-06-09 17:53 | 2026-06-09 18:51 | MySQL Server: InnoDB storage engine | Open | S3 | Any | Any | Contribution: InnoDB: crash recovery of unfinished ALTER TABLESPACE ENCRYPT ... | |
| 120648 | 2026-06-09 17:53 | 2026-06-09 18:51 | MySQL Server: InnoDB storage engine | Open | S3 | Any | Any | Contribution: InnoDB: Crash resuming interrupted ALTER TABLESPACE ENCRYPTIO ... | |
| 120647 | 2026-06-09 17:40 | 2026-06-09 18:50 | MySQL Server: InnoDB storage engine | Open | S3 | Any | Any | Contribution: InnoDB: make_page_dirty debug command logs MLOG_2BYTES on com ... | |
| 120642 | 2026-06-09 10:44 | 2026-06-10 7:44 | MySQL Server: Optimizer | Not a Bug (37 days) | S1 | MySQL 9.6 | Any (Storage Engine: InnoDB) | Any | Derived table merging loses FLOAT display formatting context, causing inconsistent aggregated output |
| 120641 | 2026-06-09 10:23 | 2026-06-09 11:07 | MySQL Server: Optimizer | Verified (38 days) | S1 | 9.7.0 | Any (Storage Engine: InnoDB) | Any | Derived condition pushdown causes wrong row filtering due to incorrect constant folding with any_value() aggregation |
| 120640 | 2026-06-09 10:13 | 2026-06-09 11:00 | MySQL Server: Optimizer | Verified (38 days) | S3 | 9.6.0 | Ubuntu (22.04) | Any | WHERE NULLIF(...) IS NULL returns rows when NULLIF is non-NULL |
| 120639 | 2026-06-09 10:08 | 2026-06-09 10:52 | MySQL Server: Optimizer | Verified (38 days) | S1 | 8.0.46 | Any (Storage Engine: InnoDB) | Any | COUNT(*) on an indexed integer column produces incorrect results when the WHERE clause uses NOT (IFNULL(non-integer cons |
| 120638 | 2026-06-09 8:53 | 2026-07-01 9:53 | MySQL Server: Optimizer | Duplicate (37 days) | S3 | 8.0.32 | Any | Any | The value of Rows_examined is incorrect when there is a query involving a union of derived tables |
| 120634 | 2026-06-09 4:07 | 2026-06-25 2:28 | MySQL Server: InnoDB storage engine | Open | S1 | 8.0.44 8.4.9 | Any | Any | buf_stat_per_index inc/dec is not paired: root page inc is never decremented, causing unbounded growth of ut_lock_free_h |
| 120614 | 2026-06-03 23:45 | 2026-06-04 9:52 | MySQL Server: Optimizer | Verified (43 days) | S3 | 8.0.45 | Windows | Any | LOWER() truncates trailing characters after character Ⱥ |
| 120610 | 2026-06-03 12:00 | 2026-06-03 12:21 | MySQL Server: InnoDB storage engine | Open (44 days) | S3 | 5.7 | Any | Any | REPEATABLE READ: no-change UPDATE causes MVCC Rule 1 violation — transaction cannot see own modification |
| 120608 | 2026-06-03 7:27 | 2026-06-17 14:41 | MySQL Server: Optimizer | Duplicate (32 days) | S5 | 9.6 | Any | Any | prefer_ordering_index makes a filtered ORDER BY pk LIMIT query do a full primary-key scan instead of a filtering index r |
| 120607 | 2026-06-03 7:22 | 2026-06-15 10:48 | MySQL Server: Optimizer | Duplicate (32 days) | S5 | 9.6 | Any | Any | Join-order enumeration ignores ORDER BY sort cost |
| 120602 | 2026-06-02 11:44 | 2026-06-03 8:05 | MySQL Server: InnoDB storage engine | Verified (44 days) | S2 | 8.0.46, 8.4.9, 9.7.0 | Any | Any | Memory leak in fil_ibd_same_as_default_path() |
| 120599 | 2026-06-02 8:24 | 2026-06-30 6:44 | MySQL Server: Optimizer | Verified (17 days) | S3 | 8.0.43 | Any | Any | Field_set::sql_type() Corrupts 4-byte UTF-8 Characters, Breaking Replication |
| 120598 | 2026-06-02 7:06 | 2026-06-02 7:07 | MySQL Server: InnoDB storage engine | Open (45 days) | S3 | 8.0.46, 8.4.9 | Linux | x86 | Autoincrement problem |
| 120597 | 2026-06-02 6:58 | 2026-06-02 6:58 | MySQL Server: Performance Schema | Open | S5 | 8.0.46, 8.4.9 | Linux | x86 | performance_schema atomic values maintaining CPU cache-friendliness |
| 120596 | 2026-06-02 6:37 | 2026-06-02 6:37 | MySQL Server: InnoDB storage engine | Open | S5 | 8.0.46, 8.4.9 | Linux | x86 | WAIT_FOR_READ, WAIT_FOR_WRITE is stuck in the 2012 |
| 120586 | 2026-06-01 9:25 | 2026-06-01 9:48 | MySQL Server: Optimizer | Duplicate (46 days) | S2 | 8.0.41 | Any | Any | Incorrect duplicate rows caused by lost IN predicate during semijoin materialization with view column using COLLATE |
| 120585 | 2026-06-01 9:13 | 2026-06-01 9:42 | MySQL Server: Optimizer | Duplicate (46 days) | S2 | 9.6.0 | Any | Any | InnoDB FULLTEXT index scan silently drops rows when ORDER BY combines with type-coerced equality |
| 120584 | 2026-06-01 5:18 | 2026-06-01 7:16 | MySQL Server: Optimizer | Verified (46 days) | S2 | 8.0.45 | Any | Any | Optimizer picks BIGINT gen col index for DECIMAL expression, BIGINT truncation falsely matches fractional values |
| 120583 | 2026-06-01 2:10 | 2026-06-01 5:33 | MySQL Server: Optimizer | Verified (46 days) | S2 | 9.7.0 | Any | Any | JOIN_ORDER hint causes "Optimizer failed to find a plan" with a leading derived table and same table names in nested sql |
| 120582 | 2026-05-31 10:11 | 2026-06-01 6:13 | MySQL Server: Optimizer | Verified (46 days) | S3 | 8.0.44 | MacOS | Any | unique index causes incorrect result when comparing DOUBLE and BIGINT |
| 120581 | 2026-05-31 9:02 | 2026-06-01 6:17 | MySQL Server: Optimizer | Verified (46 days) | S2 | 8.0.44 | MacOS | Any | unique index causes incorrect result for IN comparison with implicit type conversion |
| 120580 | 2026-05-31 7:52 | 2026-06-01 6:21 | MySQL Server: Optimizer | Verified (46 days) | S3 | 8.0.44 | Any | Any | MyISAM prefix index causes incorrect range query result |
| 120579 | 2026-05-30 11:39 | 2026-06-01 6:53 | MySQL Server: Optimizer | Verified (46 days) | S3 | 8.0.45 | Any | Any | LIKE query returns inconsistent results with MyISAM prefix index |
| 120578 | 2026-05-30 9:05 | 2026-06-01 5:47 | MySQL Server: Optimizer | Verified (46 days) | S3 | 8.0.45 | Any | Any | Multiple-Column Index Creation Changes Query Results |
| 120575 | 2026-05-30 6:57 | 2026-05-30 6:57 | MySQL Server: Optimizer | Open | S2 | 8.0.41+ | Any | Any | Range optimizer chooses bad range plan for large IN lists and execution is very slow and memory usage spikes. |
| 120574 | 2026-05-29 14:05 | 2026-05-29 14:12 | MySQL Server: Optimizer | Open | S2 | 8.0.41 | Any | Any | Range optimizer exceeds memory limit and chooses bad range plan for large IN lists |
| 120564 | 2026-05-29 6:43 | 2026-05-29 6:46 | MySQL Server: InnoDB storage engine | Open | S3 | 9.7.0 | Any | Any | InnoDB FTS: Off-by-one error in fts_init_index() causes unsynced document to be lost after crash recovery |
| 120561 | 2026-05-28 11:11 | 2026-05-29 4:41 | MySQL Server: DDL | Open (50 days) | S3 | 9.7/8.4/8.0 | Any | Any | tablespace marked missing after rollback of copy-style ALTER |
| 120558 | 2026-05-27 11:21 | 2026-05-27 11:41 | MySQL Server: InnoDB storage engine | Open (51 days) | S3 | 8.4.8 | Any | Any | Redo log archiving started by dead connection cannot be disabled later |
| 120555 | 2026-05-27 8:22 | 2026-05-27 11:39 | MySQL Server: Optimizer | Verified (51 days) | S2 | 8.0.45 | Ubuntu | Any | Equivalent VIEW and CTE queries return different row counts with EXISTS, BINARY ENUM comparison, and LEFT JOIN |
| 120544 | 2026-05-25 10:47 | 2026-05-27 12:38 | MySQL Server: Optimizer | Duplicate (51 days) | S3 | 8.4.8 | Any | Any | MySQL `MERGE` vs `TEMPTABLE` view evaluation changes `CROSS JOIN ... ON EXISTS(...)` cardinality |
| 120543 | 2026-05-25 9:57 | 2026-05-27 5:37 | MySQL Server: Optimizer | Verified (51 days) | S2 | 8.4.8 | Any | Any | MySQL `MERGE` vs `TEMPTABLE` view evaluation changes `MAX(SET)` result |
| 120540 | 2026-05-25 1:44 | 2026-06-02 14:48 | MySQL Server: Optimizer | Documenting (51 days) | S2 | 9.7.0 | Ubuntu | x86 | A negated `IS TRUE` guard can still match a DECIMAL row for which the guarded predicate is true |
| 120539 | 2026-05-24 15:26 | 2026-05-24 15:26 | MySQL Server: FULLTEXT search | Open | S2 | 9.6.0 | Linux | Any | Duplicate FULLTEXT index on a column returns wrong MATCH...AGAINST results when combined with a STORED generated column |
| 120538 | 2026-05-24 13:46 | 2026-05-27 13:53 | MySQL Server: Optimizer | Duplicate (51 days) | S2 | 9.7.0 | Ubuntu | x86 | A RIGHT JOIN predicate treats IFNULL(NULL, non-NULL DECIMAL ZEROFILL) as non-matching and drops obvious rows |
| 120535 | 2026-05-24 5:29 | 2026-05-26 12:42 | MySQL Server: Optimizer | Verified (52 days) | S3 | 8.0.45 | Any | Any | Incorrect Query Result: IN and NOT IN return the same row simultaneously (boolean logic violation) |
| 120534 | 2026-05-24 5:19 | 2026-05-26 12:26 | MySQL Server: Optimizer | Verified (52 days) | S3 | 8.0.45 | Any | Any | Wrong Query Result Due to Incorrect Evaluation of GREATEST() with Mixed Types in OR (||) Boolean Context |
| 120533 | 2026-05-23 12:35 | 2026-05-26 8:30 | MySQL Server: Optimizer | Verified (52 days) | S2 | 8.0.45 | Ubuntu | x86 | A LEFT JOIN over DECIMAL ZEROFILL UNIQUE wrongly loses an obvious match |
| 120532 | 2026-05-23 12:34 | 2026-05-27 13:43 | MySQL Server: Optimizer | Duplicate (51 days) | S2 | 9.7.0 | Ubuntu | x86 | An unused derived subquery triggers a DISTINCT/IFNULL wrong-result in the original path |
| 120531 | 2026-05-23 12:33 | 2026-05-26 7:24 | MySQL Server: Optimizer | Verified (52 days) | S2 | 8.0.45 | Ubuntu | x86 | A NULL comparison inside an IN subquery becomes spuriously true in the original path |
| 120529 | 2026-05-22 17:08 | 2026-07-16 14:48 | MySQL Server: InnoDB storage engine | In progress (1 day) | S3 | Any | Any | Contribution: Log a warning when history list length exceeds threshold | |
| 120527 | 2026-05-22 11:47 | 2026-06-01 9:39 | MySQL Server: Optimizer | Verified (46 days) | S2 | 9.6.0 | Linux | Any | FULLTEXT index scan with ORDER BY and numeric WHERE filter returns empty result set |
| 120526 | 2026-05-22 11:47 | 2026-05-26 6:59 | MySQL Server: Optimizer | Verified (52 days) | S3 | 8.0.43 | Any | Any | Wrong result for IN subquery involving CURRENT_USER(), BIT column, and UNIQUE prefix index |
| 120525 | 2026-05-22 9:41 | 2026-05-26 6:49 | MySQL Server: Optimizer | Verified (52 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Append-Only Growth Breaks Subset Monotonicity for Implicit VARCHAR-to-DECIMAL IN-Subquery Comparison |
| 120524 | 2026-05-22 9:40 | 2026-05-26 6:27 | MySQL Server: Optimizer | Verified (52 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Materialized Correlated EXISTS Returns Positive COUNT(*) But No Rows for Implicit VARCHAR-to-YEAR Comparison |
| 120523 | 2026-05-22 9:13 | 2026-05-31 17:44 | MySQL Server: Optimizer | Duplicate (47 days) | S3 | 8.0.43 | Any | Any | Wrong result for arithmetic expression involving DAYNAME() and BIT column |
| 120522 | 2026-05-22 6:39 | 2026-06-01 6:58 | MySQL Server: Optimizer | Verified (46 days) | S5 | 9.7.0 | Any | Any | Sub‑optimal execution plan for multi‑table row‑value IN condition leads to full index scan instead of index range scans |
| 120520 | 2026-05-21 16:34 | 2026-05-25 19:58 | MySQL Server: Optimizer | Verified (53 days) | S3 | 8.0.43 | Any | Any | Wrong result for IS NOT UNKNOWN when NULLIF() uses CURRENT_USER() as an argument |
| 120519 | 2026-05-21 15:49 | 2026-05-25 19:43 | MySQL Server: Optimizer | Verified (53 days) | S3 | 8.0.43 | Any | Any | Wrong result for BETWEEN predicate with LONGBLOB prefix PRIMARY KEY and implicit type conversion |
| 120518 | 2026-05-21 14:29 | 2026-05-31 21:28 | MySQL Server: Optimizer | Duplicate (47 days) | S3 | 8.0.43 | Any | Any | Wrong result for SOME quantified comparison with ELT() returning NULL and PRIMARY KEY optimization |
| 120515 | 2026-05-21 10:36 | 2026-05-21 11:55 | MySQL Server: Optimizer | Verified (57 days) | S3 | 8.0 | Any | Any | Wrong result for NOT BETWEEN involving interval arithmetic and implicit type conversion |
| 120514 | 2026-05-21 9:19 | 2026-05-21 11:47 | MySQL Server: Optimizer | Unsupported (57 days) | S3 | 8.0 | Any | Any | Wrong result for ALL quantified comparison involving interval arithmetic and PRIMARY KEY optimization |
| 120512 | 2026-05-21 7:43 | 2026-05-21 11:23 | MySQL Server: Optimizer | Verified (57 days) | S3 | 8.0 | Any | Any | ALL quantified comparison involving implicit numeric conversion of BLOB values |
| 120511 | 2026-05-21 7:24 | 2026-05-21 8:26 | MySQL Server: Optimizer | Verified (57 days) | S3 | 8.0.46 | Ubuntu | x86 | LEFT JOIN ON with IN (empty subquery) produces a spurious match |
| 120504 | 2026-05-20 11:53 | 2026-05-29 10:36 | MySQL Server: InnoDB storage engine | Verified (49 days) | S3 | 9.7 | Any | Any | Can't create some of tables with SPATIAL KEY because of ER_TOO_BIG_ROWSIZE |
| 120502 | 2026-05-20 10:16 | 2026-06-08 11:31 | MySQL Server: Optimizer | Verified (39 days) | S5 | 9.7.0 | Any | Any | Impossible WHERE with inequality-only contradictions not optimized |
| 120499 | 2026-05-20 5:02 | 2026-05-20 5:02 | MySQL Server: Stored Routines | Open | S2 | 9.6.0 | Linux | x86 (AMD EPYC 9K65) | Recursive stored procedure with max_sp_recursion_depth >= 250 crashes mysqld |
| 120497 | 2026-05-19 3:12 | 2026-05-21 6:37 | MySQL Server: Optimizer | Duplicate (59 days) | S3 | 8.4.8, 9.7.0 | Any | Any | INDEX Hint Prevents Reuse of InnoDB Primary-Key Suffix Order and Forces a Temporary Table |
| 120495 | 2026-05-18 16:12 | 2026-05-27 6:34 | MySQL Server: Optimizer | Verified (51 days) | S5 | 9.7.0 | Any | Any | Incorrect Cardinality Estimation for Index Lookup with Equality Predicate on the Index Column |
| 120493 | 2026-05-18 14:26 | 2026-05-19 19:53 | MySQL Server: Optimizer | Verified (59 days) | S3 | 8.0 | Any | Any | Wrong result for SOME quantified comparison in WHERE clause |
| 120491 | 2026-05-18 5:53 | 2026-05-18 12:22 | MySQL Server: Optimizer | Verified (60 days) | S2 | 8.0.46 | CentOS | Any | Semijoin returns wrong results for VARCHAR-to-DECIMAL comparison with non-canonical numeric strings |
| 120490 | 2026-05-18 3:24 | 2026-05-18 8:26 | MySQL Server: Optimizer | Verified (60 days) | S5 | 9.7.0 | Any | Any | Join Not Eliminated When Constant Table is Empty Due to PrimaryKeyCol IN (NULL) Condition |
| 120480 | 2026-05-14 20:59 | 2026-06-12 21:18 | MySQL Server: Replication | Open (35 days) | S3 | 8.0.40 | Any | Any | Crash in set_and_validate_user_attributes during relay log recovery |
| 120477 | 2026-05-14 15:50 | 2026-05-18 10:26 | MySQL Server: Optimizer | Verified (60 days) | S5 | 9.7.0 | Any | Any | Index Not Used for HAVING Without GROUP BY or aggregate functions |
| 120476 | 2026-05-14 11:53 | 2026-05-18 8:25 | MySQL Server: Optimizer | Verified (60 days) | S2 | 9.6.0 | Linux | Any | Index Merge Union returns duplicate row for overlapping OR conditions, producing wrong result count |
| 120475 | 2026-05-14 9:09 | 2026-05-18 10:20 | MySQL Server: Optimizer | Verified (60 days) | S2 | 8.0.46 | Linux | Any | Index Merge Intersection incorrectly drops matching rows in SELECT with OR predicate, returning wrong result count |
| 120472 | 2026-05-14 4:07 | 2026-06-04 8:43 | MySQL Server: Optimizer | Verified (43 days) | S2 | 8.0.43 | Any | Any | Wrong Result After Removing Semantically Redundant RIGHT JOIN ... ON FALSE |
| 120471 | 2026-05-14 0:08 | 2026-05-18 9:15 | MySQL Server: Replication | Open (64 days) | S1 | 8.0.43, 8.0.46, 8.4.9, 9.7.0 | Any (reproduced on macOS and Linux) | Any | binary log violates read after write (commit) consistency |
| 120469 | 2026-05-13 17:00 | 2026-05-18 9:12 | MySQL Server: InnoDB storage engine | Open | S3 | Any | Any | Contribution: Fix ut_error() at ENABLE INNODB REDO_LOG when innodb_checkpo ... | |
| 120467 | 2026-05-13 15:57 | 2026-05-18 9:09 | MySQL Server: InnoDB storage engine | Open | S3 | 8.0.45 | Any | Any | dd_open_fk_tables function heap-use-after-free |
| 120465 | 2026-05-13 8:31 | 2026-06-19 14:48 | MySQL Server: Optimizer | Documenting (60 days) | S3 | 8.0.46 | Any | Any | AVG(ASCII()) result truncated to 99.9999 with SQL_BUFFER_RESULT due to incorrect decimal precision |
| 120457 | 2026-05-12 15:03 | 2026-05-28 1:13 | MySQL Server: Optimizer | Patch pending (61 days) | S2 | 9.7 | CentOS | x86 | Hypergraph optimizer returns wrong results for LEFT JOIN LATERAL with SEMI JOIN when derived_merge |
| 120456 | 2026-05-12 15:02 | 2026-05-17 23:00 | MySQL Server: Optimizer | Verified (61 days) | S2 | 8.0.46 | Linux | Any | Semijoin Nested Loop index lookup uses raw VARCHAR keys against a DOUBLE B-tree, causing mismatches when the string over |
| 120441 | 2026-05-11 11:29 | 2026-06-09 20:48 | MySQL Server: InnoDB storage engine | Documenting (39 days) | S2 | trunk 8.0.24 8.4.9 | Any | Any | InnoDB btr_create() can hold page latches for a long time because buf_stat_per_index->inc() may synchronously run ut_loc |
| 120437 | 2026-05-11 8:47 | 2026-06-26 7:08 | MySQL Server: Information schema | Verified (21 days) | S2 | 8.0.35, 8.4.8, 9.3.0, 9.7.0 | Any | Any | information_schema.partitions returns UINT64_MAX (18446744073709551615) for DATA_LENGTH of partition dropped during conc |
| 120435 | 2026-05-11 7:21 | 2026-05-19 14:18 | MySQL Server: DDL | Open | S3 | Any | Any | Add DDL Triggers Support in MySQL | |
| 120429 | 2026-05-10 7:04 | 2026-05-28 1:13 | MySQL Server: Optimizer | Documenting (67 days) | S2 | 9.7.0 | Windows (Windows Server 2022) | Any | IFNULL function does not handle NULL |
| 120422 | 2026-05-08 8:56 | 2026-07-02 1:00 | MySQL Server: Optimizer | No Feedback (16 days) | S2 | 9.7.0 (also reproducible in 8.0.x) | Any | Any | ORDER BY ignored when internal_tmp_mem_storage_engine = TempTable with GROUP BY on CTE |
| 120420 | 2026-05-08 8:19 | 2026-07-02 1:00 | MySQL Server: Optimizer | No Feedback (16 days) | S3 | 9.7.0 (also reproducible in 8.0.x) | Any | Any | ORDER BY ignored when internal_tmp_mem_storage_engine = TempTable with GROUP BY on temp table |
| 120419 | 2026-05-08 7:50 | 2026-05-08 19:26 | MySQL Server: Optimizer | Verified (70 days) | S3 | 8.0.46 | Linux | Any | rematerialized temptable cause wrong order |
| 120417 | 2026-05-08 6:22 | 2026-05-20 11:16 | MySQL Server: InnoDB storage engine | Open | S3 | 8.0.40 | Linux | x86 | MY-013028] [InnoDB] MySQL is freeing a thd though trx->n_mysql_tables_in_use is X and trx->mysql_n_tables_locked is Y |
| 120416 | 2026-05-08 0:28 | 2026-05-11 8:05 | MySQL Server: Documentation | Open | S3 | 8.4.9 | Any | Any | Missing system variable in document for 8.4 |
| 120414 | 2026-05-07 15:19 | 2026-05-11 12:42 | MySQL Server: InnoDB storage engine | Open (67 days) | S5 | 8.0.32 - 9.7 | Any | Any | InnoDB performance regression because of validate_rec_offset |
| 120406 | 2026-05-06 4:46 | 2026-05-06 9:43 | MySQL Server: Documentation | Verified (72 days) | S3 | Any | Any | Inconsistent GBK-to-utf8mb4 conversion between implicit INSERT ... SELECT assignment and explicit CONVERT() | |
| 120403 | 2026-05-05 13:47 | 2026-05-28 1:13 | MySQL Server: Optimizer | Documenting (72 days) | S2 | 8.0.46, 8.4.9, 9.7.0 | Any | Any | Regression in MySQL 8.0.46, 8.4.9 & 9.7.0: WHERE equality condition fails to match existing row |
| 120400 | 2026-05-04 17:19 | 2026-05-04 17:46 | MySQL Server: Documentation | Open (74 days) | S3 | Any | Any | Docs for innodb_sort_buffer_size are wrong or confusing | |
| 120395 | 2026-05-04 6:49 | 2026-05-04 6:49 | MySQL Server: Documentation | Open | S3 | 9.7.0 | Any | Any | Documentation for enable_cascade_triggers has incorrect Scope and Dynamic attributes |
| 120389 | 2026-05-01 2:10 | 2026-05-27 6:49 | MySQL Server: Command-line Clients | Open | S3 | 9.7 | Any | Any | HELP result contains the link to MySQL 9.1 |
| 120388 | 2026-04-30 19:36 | 2026-05-01 9:44 | MySQL Server: InnoDB storage engine | Open | S5 | 8.4.9 | Oracle Linux (9.5) | x86 | High contention on InnoDB per-page BUF_BLOCK_MUTEX during concurrent range-selects to same row/page |
| 120377 | 2026-04-29 8:45 | 2026-06-04 8:43 | MySQL Server: Optimizer | Verified (43 days) | S2 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | Incorrect row count in MySQL when using LATERAL derived table with DISTINCT and CASE |
| 120370 | 2026-04-28 16:33 | 2026-06-23 3:32 | MySQL Server: DDL | Duplicate (24 days) | S2 | 8.0.46 | Any | Any | Regression (from 8.0.45) on Row size too large |
| 120363 | 2026-04-28 6:58 | 2026-06-04 8:42 | MySQL Server: Optimizer | Verified (43 days) | S2 | 8.0.43 | Any (Docker container) | Any (x86_64) | LEFT JOIN ON FALSE causes incorrect NULL comparison result in MySQL |
| 120362 | 2026-04-28 6:13 | 2026-04-28 9:37 | MySQL Server: Documentation | Verified (80 days) | S2 | 9.7.0 | Any | Any | Incorrect syntax for CREATE VIEW in docs |
| 120356 | 2026-04-27 14:52 | 2026-04-27 17:21 | MySQL Server: DDL | Duplicate (81 days) | S2 | 8.0.46 | Linux (Debian 12) | x86 | ERROR 1118 Row size too large (> 8126) on 8.0.46 |
| 120353 | 2026-04-27 11:55 | 2026-04-29 11:43 | MySQL Server: InnoDB storage engine | Can't repeat (79 days) | S2 | <=8.0.42-debug | Any | Any | InnoDB crashes with assertion failure (ut_dbg_assertion_failed) when creating index with ALGORITHM COPY on table with F |
| 120352 | 2026-04-27 9:34 | 2026-04-28 4:26 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.6.0 | Linux | Any | Prefix index with length 1 causes incorrect "Zero rows" optimization with float overflow literal in range condition |
| 120350 | 2026-04-27 8:35 | 2026-04-28 4:31 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.6.0 | Linux | Any | Prefix index on TEXT column causes range scan to miss qualifying rows in MySQL |
| 120348 | 2026-04-27 4:37 | 2026-04-30 12:52 | MySQL Server: Documentation | Open | S3 | 9.7 | Any | Any | Doc Request: What Is New in MySQL 9.7 between MySQL 8.4 LTS and MySQL 9.7 LTS |
| 120344 | 2026-04-26 6:43 | 2026-04-27 4:04 | MySQL Server: Optimizer | Verified (81 days) | S2 | 9.6.0 | Any | Any | VIEW and equivalent CTE return different results with UNION, YEAR(0), and repeated reference in subquery |
| 120340 | 2026-04-24 9:13 | 2026-07-09 5:42 | MySQL Server: Optimizer | Not a Bug (8 days) | S2 | 8.0.43 (MySQL Community Server - GPL) | Any | Any | Inconsistent evaluation of NULLIF(ROUND(VAR_SAMP(...)), const) <= value between MySQL and PostgreSQL/DuckDB causes diffe |
| 120338 | 2026-04-23 20:37 | 2026-04-23 20:37 | MySQL Server: Documentation | Open | S3 | 9.6, 9.7 | Any | Any | What Is New in MySQL 9.7 manual page has contents from 9.5 |
| 120327 | 2026-04-23 7:46 | 2026-04-23 12:40 | MySQL Server: Replication | Open | S2 | MySQL 8.4 | Any | Any | Unsigned integer wraparound in Binlog_sender::run() when binlog_row_event_max_size is set to a large value |
| 120323 | 2026-04-22 12:51 | 2026-06-30 14:48 | MySQL Server: DDL | Documenting (85 days) | S1 | 8.4.9 | Debian (12) | x86 | Regression : "Row size too large (> 8126)" error with table using InnoDb DYNAMIC row format |
| 120321 | 2026-04-22 8:52 | 2026-04-22 8:52 | MySQL Server: Documentation | Open | S3 | 9.7 | Any | Any | Typo in 9.7 doc describing about offline_mode |
| 120319 | 2026-04-22 7:11 | 2026-04-22 9:43 | MySQL Server: Optimizer | Duplicate (86 days) | S2 | MySQL 8.4.6 LTS | Any | Any | IN() clause containing over-length string values for VARCHAR(N) column causes full table scan in MySQL 8.4.x, while sing |
| 120318 | 2026-04-22 6:31 | 2026-04-22 6:31 | MySQL Server: InnoDB storage engine | Open | S3 | 9.6.0 | Linux | Any | InnoDB partition statistics not auto-updated after ALTER TABLE REORGANIZE PARTITION |
| 120313 | 2026-04-21 17:11 | 2026-04-22 4:43 | MySQL Server: Optimizer | Verified (86 days) | S1 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result when only GROUP BY key order is changed in a join query with nested window-function input |
| 120312 | 2026-04-21 16:58 | 2026-04-22 4:40 | MySQL Server: Optimizer | Verified (86 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result for MIN(TIME) UNION ALL DATE after view extraction |
| 120311 | 2026-04-21 16:52 | 2026-04-22 4:38 | MySQL Server: Optimizer | Verified (86 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result for grouped SUM(DISTINCT ...) with DENSE_RANK() after view extraction |
| 120310 | 2026-04-21 16:45 | 2026-04-22 4:34 | MySQL Server: Optimizer | Verified (86 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result for MAX(BIT(8)) UNION ALL BLOB after view extraction in a window-function workload |
| 120308 | 2026-04-21 14:03 | 2026-04-22 4:27 | MySQL Server: Optimizer | Verified (86 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result for string-vs-`BIT` comparison in a window-function query |
| 120307 | 2026-04-21 14:02 | 2026-04-22 4:23 | MySQL Server: Optimizer | Verified (86 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Wrong result for `<= ANY (subquery)` in a window-function query |
| 120306 | 2026-04-21 2:23 | 2026-04-21 5:49 | MySQL Server: DDL | Verified (87 days) | S3 | 8.0.43 | Any | Any | ALGORITHM=INPLACE allows creating a VIRTUAL GENERATED COLUMN with invalid expressions for existing data, causing subsequ |
| 120304 | 2026-04-20 22:05 | 2026-05-06 4:55 | MySQL Server: InnoDB storage engine | Duplicate (72 days) | S1 | 8.0.44 | CentOS (07) | x86 (x86_64) | MySQL 8.0.44 crashes with InnoDB assertion failure on replica when TRUNCATE TABLE is applied to a table whose tablespace |
| 120302 | 2026-04-20 9:51 | 2026-04-20 11:26 | MySQL Server: Optimizer | Verified (88 days) | S2 | 9.6.0 | Any | Any | Inconsistent results between VIEW and CTE involving YEAR(DATETIME), UNION, and JOIN. |
| 120300 | 2026-04-20 9:02 | 2026-04-20 11:03 | MySQL Server: Optimizer | Verified (88 days) | S2 | 8.0.45 | Any (Observed on Linux via the `mysql:9.6` ) | Any | Window function logic mismatch across engines |
| 120299 | 2026-04-20 9:00 | 2026-04-20 10:41 | MySQL Server: Optimizer | Verified (88 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | mismatch in `DELETE ... EXISTS` under window function query |
| 120298 | 2026-04-20 8:58 | 2026-04-20 10:56 | MySQL Server: DML | Can't repeat (88 days) | S3 | 8.0.31-tr-debug | Any | Any | opt_explain_json.cc:507 assert failure — EXPLAIN FORMAT=JSON on INTERSECT subquery crashes mysqld |
| 120297 | 2026-04-20 8:44 | 2026-04-20 10:04 | MySQL Server: Optimizer | Verified (88 days) | S2 | 8.0.32 | Any | Any | query_term.cc:320 assert(false) crash — UNION query triggers unhandled AccessPath |
| 120296 | 2026-04-20 7:50 | 2026-04-20 9:24 | MySQL Server: Optimizer | Verified (88 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Materialized Correlated EXISTS Loses Implicit VARCHAR-to-YEAR Coercion,Causing Plan-Dependent Result Divergence |
| 120294 | 2026-04-19 17:16 | 2026-04-27 14:11 | MySQL Server: Optimizer | Verified (81 days) | S3 | 9.6.0; 8.0.45 | Any | Any | Inconsistent fractional seconds precision (FSP) for TIME function results between VIEW and CTE |
| 120293 | 2026-04-19 17:10 | 2026-04-27 14:10 | MySQL Server: Optimizer | Verified (81 days) | S1 | 9.6.0; 8.0.45 | Any | Any | Query result inconsistency between VIEW and CTE involving a UNION of scalar aggregation and grouped aggregation |
| 120292 | 2026-04-19 17:01 | 2026-04-27 14:09 | MySQL Server: Optimizer | Verified (81 days) | S2 | 9.6.0; 8.0.45 | Any | Any | Inconsistent results between VIEW and CTE involving IN subquery and RIGHT JOIN |
| 120291 | 2026-04-19 16:45 | 2026-04-27 13:16 | MySQL Server: Optimizer | Verified (81 days) | S2 | 9.6.0 | Any | Any | Inconsistent results between VIEW and CTE involving EXISTS subquery and LEFT JOIN |
| 120289 | 2026-04-19 14:35 | 2026-04-20 8:13 | MySQL Server: Optimizer | Verified (88 days) | S2 | 9.6 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Mismatch in indexed `IN` under windows function query |
| 120288 | 2026-04-19 14:29 | 2026-04-20 8:04 | MySQL Server: Optimizer | Verified (88 days) | S2 | 8.0.45 | Linux (Observed on Linux via the `mysql:9.6` ) | Any | Window function logic mismatch in indexed `NOT IN` |
| 120286 | 2026-04-19 5:14 | 2026-04-20 7:53 | MySQL Server: Optimizer | Verified (88 days) | S2 | 8.0.45 | Any | Any | `SUM(DISTINCT pk)` returns `NULL` with a window function when a secondary index is used for group-by scanning |
| 120285 | 2026-04-18 15:49 | 2026-06-30 6:34 | MySQL Server: Optimizer | Verified (17 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Materialized Semijoin + Outer ORDER BY Loses Rows for Correlated EXISTS,Causing Plan-Dependent Result Divergence |
| 120284 | 2026-04-18 15:46 | 2026-04-20 7:33 | MySQL Server: Optimizer | Verified (88 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Materialized `IN (subquery)` Loses VARCHAR-to-YEAR Coercion,Causing Plan-Dependent Result Divergence |
| Showing all 267 (Edit, Save, CSV, Feed) |
