| Showing 1-30 of 47 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 120291 | 2026-04-19 16:45 | 2026-04-27 13:16 | MySQL Server: Optimizer | Verified (131 days) | S2 | 9.6.0 | Any | Any | Inconsistent results between VIEW and CTE involving EXISTS subquery and LEFT JOIN |
| 120292 | 2026-04-19 17:01 | 2026-04-27 14:09 | MySQL Server: Optimizer | Verified (131 days) | S2 | 9.6.0; 8.0.45 | Any | Any | Inconsistent results between VIEW and CTE involving IN subquery and RIGHT JOIN |
| 120293 | 2026-04-19 17:10 | 2026-04-27 14:10 | MySQL Server: Optimizer | Verified (131 days) | S1 | 9.6.0; 8.0.45 | Any | Any | Query result inconsistency between VIEW and CTE involving a UNION of scalar aggregation and grouped aggregation |
| 120294 | 2026-04-19 17:16 | 2026-04-27 14:11 | MySQL Server: Optimizer | Verified (131 days) | S3 | 9.6.0; 8.0.45 | Any | Any | Inconsistent fractional seconds precision (FSP) for TIME function results between VIEW and CTE |
| 120302 | 2026-04-20 9:51 | 2026-04-20 11:26 | MySQL Server: Optimizer | Verified (138 days) | S2 | 9.6.0 | Any | Any | Inconsistent results between VIEW and CTE involving YEAR(DATETIME), UNION, and JOIN. |
| 120344 | 2026-04-26 6:43 | 2026-04-27 4:04 | MySQL Server: Optimizer | Verified (131 days) | S2 | 9.6.0 | Any | Any | VIEW and equivalent CTE return different results with UNION, YEAR(0), and repeated reference in subquery |
| 120555 | 2026-05-27 8:22 | 2026-05-27 11:39 | MySQL Server: Optimizer | Verified (101 days) | S2 | 8.0.45 | Ubuntu | Any | Equivalent VIEW and CTE queries return different row counts with EXISTS, BINARY ENUM comparison, and LEFT JOIN |
| 120836 | 2026-07-02 15:08 | 2026-07-02 19:35 | MySQL Server: Optimizer | Verified (65 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 (65 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-08-10 18:00 | MySQL Server: Optimizer | Verified (26 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 (65 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 (65 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 (65 days) | S2 | 9.6.0 | Ubuntu | Any | Wrong result with CTE, ORDER BY LIMIT, GROUP BY, SUM() and outer UNION |
| 120842 | 2026-07-02 16:34 | 2026-07-02 20:22 | MySQL Server: Optimizer | Verified (65 days) | S2 | 9.6.0 | Ubuntu | Any | Wrong result with CTE, DISTINCT, NULL vs empty string, GROUP_CONCAT() and UNION |
| 120843 | 2026-07-02 16:43 | 2026-07-03 9:14 | MySQL Server: Optimizer | Verified (64 days) | S2 | 9.6.0 | Ubuntu | Any | VIEW and CTE return wrong results with YEAR(), UNION and uncorrelated EXISTS subquery |
| 120844 | 2026-07-02 16:47 | 2026-07-03 16:21 | MySQL Server: Optimizer | Can't repeat (64 days) | S2 | 9.6.0 | Ubuntu | Any | Wrong result with VIEW, DAYNAME(), UNION and NOT IN subquery |
| 120845 | 2026-07-02 16:55 | 2026-07-03 7:44 | MySQL Server: Optimizer | Verified (64 days) | S2 | 9.6.0 | Ubuntu | Any | Wrong result with CTE, nested STDDEV_POP(), GROUP BY and UNION |
| 120846 | 2026-07-02 17:00 | 2026-07-03 7:49 | MySQL Server: Optimizer | Verified (64 days) | S2 | 9.6.0 | Ubuntu | Any | Wrong result with CTE, AVG(NUMERIC(62)), MIN() and derived table join |
| 120847 | 2026-07-02 17:28 | 2026-07-03 9:22 | MySQL Server: Data Types | Verified (64 days) | S2 | 9.6.0 | Ubuntu | Any | Inconsistent comparison behavior for ENUM-derived CASE expression between VIEW/CTE and TEMPORARY TABLE |
| 120848 | 2026-07-02 17:43 | 2026-07-03 16:34 | MySQL Server: Data Types | Verified (64 days) | S2 | 9.6.0 | Ubuntu | Any | Inconsistent comparison behavior for MAKETIME() expression between VIEW/CTE and TEMPORARY TABLE |
| 120849 | 2026-07-02 17:52 | 2026-07-03 11:01 | MySQL Server: Data Types | Duplicate (64 days) | S2 | 9.6.0 | Ubuntu | Any | Wrong result / inconsistent comparison behavior for SEC_TO_TIME() expression between VIEW/CTE and TEMPORARY TABLE |
| 120851 | 2026-07-03 5:24 | 2026-07-03 16:17 | MySQL Server: Data Types | Duplicate (64 days) | S2 | 9.6.0,9.7.0 | Ubuntu | Any | Wrong result / inconsistent comparison behavior for TIME() expression between VIEW/CTE and TEMPORARY TABLE |
| 120852 | 2026-07-03 5:32 | 2026-07-03 10:09 | MySQL Server: Data Types | Verified (64 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 |
| 120853 | 2026-07-03 5:42 | 2026-07-03 10:12 | MySQL Server: Optimizer | Verified (64 days) | S2 | 9.6.0,9.7.0 | Ubuntu | Any | Wrong result with LOWER(JSON), UPPER() comparison and utf8mb4_bin collation in VIEW/CTE |
| 120854 | 2026-07-03 5:49 | 2026-07-06 15:23 | MySQL Server: Optimizer | Verified (61 days) | S2 | 9.6.0,9.7.0 | Ubuntu | Any | Wrong result with COALESCE(YEAR, 0), arithmetic and window function in VIEW/CTE |
| 120855 | 2026-07-03 6:02 | 2026-07-07 7:18 | MySQL Server: Optimizer | Verified (60 days) | S2 | 9.6.0,9.7.0 | Ubuntu | Any | Wrong result with QUOTE(NULL) in VIEW/CTE WHERE predicate |
| 120856 | 2026-07-03 6:15 | 2026-07-08 8:18 | MySQL Server: Data Types | Verified (59 days) | S2 | 9.7.0 | Any | Any | COERCIBILITY() differs for expression-derived strings between VIEW/CTE and TEMPORARY TABLE |
| 120857 | 2026-07-03 6:23 | 2026-07-07 7:25 | MySQL Server: Optimizer | Verified (60 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 |
| 120911 | 2026-07-13 13:28 | 2026-07-14 7:03 | MySQL Server: Optimizer | Verified (53 days) | S2 | 9.6.0,9.7.0 | Ubuntu | Any | Wrong result after predicate pushdown to HAVING for SUM(DOUBLE) in VIEW/CTE |
| 120983 | 2026-07-23 10:07 | 2026-07-29 10:20 | MySQL Server: Optimizer | Verified (38 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 |
| Showing 1-30 of 47 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
