| Showing all 36 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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) |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| Showing all 36 (Edit, Save, CSV, Feed) |
