| Showing 1-10 of 41 (Edit, Save, CSV, Feed) | Show Next 10 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 120830 | 2026-07-02 3:11 | 2026-07-02 9:34 | MySQL Server: Optimizer | Verified (14 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 |
| 120832 | 2026-07-02 10:02 | 2026-07-02 18:06 | MySQL Server: Optimizer | Verified (14 days) | S1 | 9.7.1 | Any | Any | WITH ROLLUP Super‑Aggregate Row Missing in Zero Input Rows Short‑Circuit Path |
| 120833 | 2026-07-02 10:32 | 2026-07-03 1:33 | MySQL Server: Optimizer | Verified (13 days) | S1 | 9.7.1 | Any | Any | Index Lookup Truncates DOUBLE to BIGINT for IF(NULL, …) and GREATEST(string, double) in IN Conditions |
| 120834 | 2026-07-02 10:38 | 2026-07-02 19:03 | MySQL Server: Optimizer | Verified (14 days) | S1 | 9.7.1 | Any | Any | AVG on Large DOUBLE Values Returns Inconsistent Results Across Execution Paths (Index Scan vs. Temporary Table) |
| 120836 | 2026-07-02 15:08 | 2026-07-02 19:35 | MySQL Server: Optimizer | Verified (14 days) | S2 | 9.6.0 | Ubuntu | Any | Wrong result with VIEW, UNION, MAKETIME(), MEDIUMTEXT and NOT IN subquery containing NULL |
| 120837 | 2026-07-02 15:20 | 2026-07-02 19:44 | MySQL Server: Optimizer | Verified (14 days) | S2 | 9.6.0 | Any | Any | Wrong result with CTE, UNION ALL, GROUP BY/HAVING and LOCATE('', column) |
| 120838 | 2026-07-02 15:28 | 2026-07-02 19:57 | MySQL Server: Optimizer | Verified (14 days) | S2 | 9.6.0 | Ubuntu | Any | Wrong result with CTE, UNION, BIT column and NOT IN subquery containing NULL |
| 120839 | 2026-07-02 15:37 | 2026-07-02 20:04 | MySQL Server: Optimizer | Verified (14 days) | S2 | 9.6.0 | Ubuntu | Any | Wrong result with CTE, YEAR column, scalar subquery, outer UNION and MAX() aggregate |
| 120840 | 2026-07-02 16:20 | 2026-07-02 20:09 | MySQL Server: Optimizer | Verified (14 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 |
| 120841 | 2026-07-02 16:26 | 2026-07-02 20:14 | MySQL Server: Optimizer | Verified (14 days) | S2 | 9.6.0 | Ubuntu | Any | Wrong result with CTE, ORDER BY LIMIT, GROUP BY, SUM() and outer UNION |
| Showing 1-10 of 41 (Edit, Save, CSV, Feed) | Show Next 10 Entries » |
