| Showing 1-30 of 11278 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 120843 | 2026-07-02 16:43 | 2026-07-02 20:33 | MySQL Server: Optimizer | Verified | 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 | 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 | 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 | 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 | 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 | 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 | 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 | S2 | 9.6.0 | Ubuntu | Any | Wrong result with VIEW, UNION, MAKETIME(), MEDIUMTEXT and NOT IN subquery containing NULL |
| 120834 | 2026-07-02 10:38 | 2026-07-02 19:03 | MySQL Server: Optimizer | Verified | 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-02 18:46 | MySQL Server: Optimizer | Verified | 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 | 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 | 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 |
| 120809 | 2026-06-29 7:31 | 2026-07-02 14:07 | MySQL Server: Optimizer | Verified | 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 |
| 120803 | 2026-06-28 13:20 | 2026-06-29 2:51 | MySQL Server: Optimizer | Verified (3 days) | S1 | 9.6 | Any | Any | CTE Materialization Causes LEAST to Degenerate from String Comparison to Numeric Comparison |
| 120797 | 2026-06-27 15:18 | 2026-07-02 13:29 | MySQL Server: Optimizer | Verified | 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 |
| 120782 | 2026-06-25 20:24 | 2026-06-26 4:47 | MySQL Server: Optimizer | Verified (6 days) | S2 | 9.7.0 | Linux | Any | Derived merge: temporal expr ignores NULL-extended LEFT JOIN row |
| 120780 | 2026-06-25 20:19 | 2026-06-26 7:00 | MySQL Server: DML | Verified (6 days) | S2 | 9.7.0 | Linux | Any | Nested DATE_ADD on a date string adds spurious 00:00:00, drops WHERE rows |
| 120777 | 2026-06-25 19:24 | 2026-06-26 6:29 | MySQL Server: Replication | Verified (6 days) | S3 | 8.4.9, 9.7.0 | Linux | Any | Replica crash on short Format_description_event post_header_len |
| 120773 | 2026-06-25 11:54 | 2026-06-26 10:38 | MySQL Server: Optimizer | Verified (6 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 |
| 120737 | 2026-06-22 8:28 | 2026-06-22 10:31 | MySQL Server: Optimizer | Verified (10 days) | 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 (10 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 (10 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 (10 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)) |
| 120716 | 2026-06-17 12:31 | 2026-06-17 12:53 | MySQL Server: Optimizer | Verified (15 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 (16 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 (17 days) | S3 | 9.7.0 | Any | Any | Incorrect result of MEMBER OF |
| 120677 | 2026-06-13 17:33 | 2026-06-30 13:29 | MySQL Server: Optimizer | Verified (2 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `col OR GREATEST(...)` |
| 120675 | 2026-06-13 17:32 | 2026-06-30 13:24 | MySQL Server: Optimizer | Verified (2 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 (6 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `CASE with EXISTS` compared to column |
| 120669 | 2026-06-13 17:29 | 2026-06-16 5:35 | MySQL Server: Optimizer | Verified (16 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `CASE + LIKE + XOR` with `||` |
| Showing 1-30 of 11278 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
