| Showing 1-30 of 11251 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 120737 | 2026-06-22 8:28 | 2026-06-22 10:31 | MySQL Server: Optimizer | Verified (1 day) | S1 | 8.0.45 | Any | Any | Inconsistent CAST Handling of Out-of-Range TEXT Values in Single Table vs. View/Join Paths |
| 120734 | 2026-06-20 14:02 | 2026-06-22 9:59 | MySQL Server: Optimizer | Verified (1 day) | 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 (1 day) | 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 (1 day) | S3 | MySQL 9.6 | Any (Storage Engine: InnoDB) | Any | Derived Table Merging Causes Incorrect Duplicate Removal with DISTINCT + GROUP BY + SUM(DISTINCT EXISTS(subquery)) |
| 120716 | 2026-06-17 12:31 | 2026-06-17 12:53 | MySQL Server: Optimizer | Verified (6 days) | S1 | 8.0.45 | Any (Storage Engine: MEMORY) | Any | MEMORY Engine Empty Outer Join Derived Table Causes Incorrect Aggregate Result (Should Be NULL) |
| 120690 | 2026-06-15 13:33 | 2026-06-16 7:40 | MySQL Server: DML | Verified (7 days) | S3 | 8.0.46 | Any | Any | CHAR type: inconsistent behavior between WHERE clause and UNIQUE constraint when comparing strings with trailing spaces |
| 120687 | 2026-06-15 8:48 | 2026-06-15 11:06 | MySQL Server: JSON | Verified (8 days) | S3 | 9.7.0 | Any | Any | Incorrect result of MEMBER OF |
| 120669 | 2026-06-13 17:29 | 2026-06-16 5:35 | MySQL Server: Optimizer | Verified (7 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 (8 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 (8 days) | S5 | 9.7.0 | Any | Any | Optimizer fails to convert ABS(column) < constant to range scan, resulting in full table scan |
| 120664 | 2026-06-12 7:56 | 2026-06-15 8:33 | MySQL Server: JSON | Verified (8 days) | S3 | 9.6.0 | Any | Any | INDEX hint blocks generated column substitution for multi-valued indexes with MEMBER OF |
| 120641 | 2026-06-09 10:23 | 2026-06-09 11:07 | MySQL Server: Optimizer | Verified (14 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 (14 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 (14 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 |
| 120614 | 2026-06-03 23:45 | 2026-06-04 9:52 | MySQL Server: Optimizer | Verified (19 days) | S3 | 8.0.45 | Windows | Any | LOWER() truncates trailing characters after character Ⱥ |
| 120602 | 2026-06-02 11:44 | 2026-06-03 8:05 | MySQL Server: InnoDB storage engine | Verified (20 days) | S2 | 8.0.46, 8.4.9, 9.7.0 | Any | Any | Memory leak in fil_ibd_same_as_default_path() |
| 120584 | 2026-06-01 5:18 | 2026-06-01 7:16 | MySQL Server: Optimizer | Verified (22 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 (22 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 (22 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 (22 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 (22 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 (22 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 (22 days) | S3 | 8.0.45 | Any | Any | Multiple-Column Index Creation Changes Query Results |
| 120555 | 2026-05-27 8:22 | 2026-05-27 11:39 | MySQL Server: Optimizer | Verified (27 days) | S2 | 8.0.45 | Ubuntu | Any | Equivalent VIEW and CTE queries return different row counts with EXISTS, BINARY ENUM comparison, and LEFT JOIN |
| 120543 | 2026-05-25 9:57 | 2026-05-27 5:37 | MySQL Server: Optimizer | Verified (27 days) | S2 | 8.4.8 | Any | Any | MySQL `MERGE` vs `TEMPTABLE` view evaluation changes `MAX(SET)` result |
| 120535 | 2026-05-24 5:29 | 2026-05-26 12:42 | MySQL Server: Optimizer | Verified (28 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 (28 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 (28 days) | S2 | 8.0.45 | Ubuntu | x86 | A LEFT JOIN over DECIMAL ZEROFILL UNIQUE wrongly loses an obvious match |
| 120531 | 2026-05-23 12:33 | 2026-05-26 7:24 | MySQL Server: Optimizer | Verified (28 days) | S2 | 8.0.45 | Ubuntu | x86 | A NULL comparison inside an IN subquery becomes spuriously true in the original path |
| 120527 | 2026-05-22 11:47 | 2026-06-01 9:39 | MySQL Server: Optimizer | Verified (22 days) | S2 | 9.6.0 | Linux | Any | FULLTEXT index scan with ORDER BY and numeric WHERE filter returns empty result set |
| Showing 1-30 of 11251 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
