| Showing all 272 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 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 (2 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-23 7:55 | MySQL Server: DDL | Open (2 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-23 6:40 | MySQL Server: Optimizer | Open (2 days) | S1 | 9.7.1 | Any | Any | Timezone-dependent generated column breaks UNIQUE and makes table unrestorable |
| 121155 | 2026-08-22 15:02 | 2026-08-22 15:02 | MySQL Server: Optimizer | Open | 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 | 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 (3 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 | 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 (1 day) | 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 (4 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 (4 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 (4 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 (5 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 (5 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 (5 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 (6 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 (6 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 (6 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 (6 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-08-21 14:11 | MySQL Server: InnoDB storage engine | Verified (4 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 (6 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 (6 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 (11 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 (11 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 (12 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 (12 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 (12 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 (12 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 (13 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 (14 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 (12 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 (15 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 (19 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 (12 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 (20 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 (21 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 (21 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 (20 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 (21 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 (21 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 (25 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 (19 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 (22 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-08-04 14:48 | MySQL Server: Optimizer | Patch pending (22 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 (22 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 (26 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 (22 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 (25 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 (25 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 (25 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 (25 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 (27 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 (15 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 (27 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 (27 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 (27 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 (29 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 (29 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 (29 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 (28 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 (28 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 (28 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 (28 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 (22 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 (19 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 (22 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 (22 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 (22 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 (22 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 (22 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 (22 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 (22 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 (22 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 (19 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 (4 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 (19 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 (26 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 (27 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 (27 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 (22 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 (34 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 (34 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 (34 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 (34 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 (34 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 (34 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 (35 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 (35 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 (35 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 (35 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 (34 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 (34 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 (36 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 (35 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 (40 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 (34 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 (35 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 (35 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 (35 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 (35 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 (35 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 (35 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 (41 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 (41 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 (41 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 (42 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 (42 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 (42 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 (42 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 (42 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 (42 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 (42 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 (42 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 (34 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 (42 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 (42 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-08-03 10:44 | MySQL Server: InnoDB storage engine | Verified (42 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 (22 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 (22 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 (48 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 (42 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-08-21 14:44 | MySQL Server: Optimizer | Verified (49 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 (49 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 (50 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 (50 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 (50 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 (50 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 (52 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 (52 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 (52 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 (52 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 (52 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 (49 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 (48 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 (49 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 (50 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 (53 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 (53 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 (53 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 (53 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 (53 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 (53 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 (53 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 (53 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 (53 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 (53 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 (53 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 (54 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 (54 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 (54 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 (54 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 (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 (54 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 (54 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 (54 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 (53 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 (54 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 (54 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 (13 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 (48 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 (48 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 (56 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 (54 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 (57 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 (58 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 (57 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 (57 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 (57 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 (54 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 (48 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 (60 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 (60 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 (60 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 (60 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 (60 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 (60 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 (60 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 (60 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 (60 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 (60 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 (48 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-08-17 8:48 | MySQL Server: Replication | Documenting (40 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. |
| 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 (64 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 (48 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 (64 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 (64 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 (64 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 (64 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 (68 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 (69 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 (68 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 (48 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 (47 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 (70 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 (55 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 (70 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 (71 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 (47 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 (56 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 (56 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 (56 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 (56 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 (56 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 (56 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 (60 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 (64 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 (71 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 (71 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 (70 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 (70 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 (71 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 (71 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-08-03 12:11 | MySQL Server: Optimizer | Duplicate (22 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 (61 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 (76 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-07-20 11:12 | MySQL Server: Optimizer | Verified (77 days) | S1 | 8.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 (77 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 (77 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 (76 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 (82 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 (83 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 (71 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 (71 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 (83 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 (56 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 (84 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 (85 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 (85 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 (85 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 (85 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 (85 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 (85 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 (85 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 (85 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 (85 days) | S3 | 8.0.45 | Any | Any | Multiple-Column Index Creation Changes Query Results |
| 120575 | 2026-05-30 6:57 | 2026-08-04 14:17 | MySQL Server: Optimizer | Duplicate (21 days) | 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-08-04 13:50 | MySQL Server: Optimizer | Duplicate (21 days) | 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 (89 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 (90 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 (90 days) | S2 | 8.0.45 | Ubuntu | Any | Equivalent VIEW and CTE queries return different row counts with EXISTS, BINARY ENUM comparison, and LEFT JOIN |
| Showing all 272 (Edit, Save, CSV, Feed) |
