| Showing 1-30 of 11304 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 120918 | 2026-07-14 10:56 | 2026-07-15 5:25 | MySQL Server: Optimizer | Verified | S3 | 9.5.0 | Any | Any | MySQL returns the wrong column alias for an empty result query |
| 120917 | 2026-07-14 10:34 | 2026-07-15 5:23 | MySQL Server: Optimizer | Verified | S3 | 9.5.0 | Any | Any | Adding OR FALSE to an IN-subquery predicate changes the query result |
| 120911 | 2026-07-13 13:28 | 2026-07-14 7:03 | MySQL Server: Optimizer | Verified (1 day) | S2 | 9.6.0,9.7.0 | Ubuntu | Any | Wrong result after predicate pushdown to HAVING for SUM(DOUBLE) in VIEW/CTE |
| 120910 | 2026-07-13 12:29 | 2026-07-14 12:31 | MySQL Server: Optimizer | Verified (1 day) | S3 | 8.4.10 | Any | Any | Wrong result with VIEW, EXISTS, BINARY comparison, nullable boolean expression, and RIGHT JOIN |
| 120909 | 2026-07-13 11:05 | 2026-07-14 12:38 | MySQL Server: Optimizer | Verified (1 day) | S1 | MySQL 9.7.1 | Any | Any | ROLLUP Incorrectly Sets Base Group Row to NULL for Constant Folded Expression |
| 120908 | 2026-07-13 10:50 | 2026-07-14 12:42 | MySQL Server: Optimizer | Verified (1 day) | S1 | MySQL 9.7.1 | Any | Any | DISTINCTROW with GROUP BY in Derived Table Loses Rows Due to Incomplete Duplicate Removal Key |
| 120907 | 2026-07-13 10:36 | 2026-07-14 12:46 | MySQL Server: Optimizer | Verified (1 day) | S1 | MySQL 9.7.1 | Any | Any | Index Lookup Loses Unary Plus Operator During Condition Pushdown, Causing String-to-Integer Truncation and Wrong Match |
| 120906 | 2026-07-13 10:18 | 2026-07-14 12:50 | MySQL Server: Optimizer | Verified (1 day) | S3 | 8.4.10 | Any | Any | Wrong result with VIEW, UNION, NOT IN, NULL-safe equality, and LENGTH() |
| 120905 | 2026-07-13 10:06 | 2026-07-14 12:56 | MySQL Server: Optimizer | Verified (1 day) | 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 |
| 120903 | 2026-07-13 9:57 | 2026-07-14 13:03 | MySQL Server: Optimizer | Verified (1 day) | S1 | MySQL 9.7.1 | Any | Any | WITH ROLLUP in Derived Table Incorrectly Evaluates IFNULL Expression Due to Partial NULL Propagation |
| 120902 | 2026-07-13 9:13 | 2026-07-14 13:06 | MySQL Server: Optimizer | Verified (1 day) | S5 | 9.7.1 | Linux (Ubuntu (22.04.4 LTS)) | x86 (x86_64, Intel(R) Xeon(R) Gold 5220) | Hash join AccessPath double-applies probe-side condition filtering |
| 120901 | 2026-07-13 8:53 | 2026-07-14 13:12 | MySQL Server: Optimizer | Verified (1 day) | S3 | 8.4.9, 8.4.10 | Any | Any | SELECT ... LOCK IN SHARE MODE returns different row sets depending on index choice under RC/RU |
| 120874 | 2026-07-06 13:30 | 2026-07-07 6:42 | MySQL Server: Optimizer | Verified (8 days) | S3 | 8.4.x, 9.7.x | Any | Any | MySQL's INET6_NTOA function is not RFC 5952 complaint |
| 120870 | 2026-07-06 5:20 | 2026-07-07 6:30 | MySQL Server: Optimizer | Verified (8 days) | S5 | 9.7.1 | Ubuntu (22.04.4 LTS) | x86 (x86_64, Intel(R) Xeon(R) Gold 5220) | Hypergraph misses BETWEEN equality, causing 100x slowdown |
| 120869 | 2026-07-05 10:46 | 2026-07-06 5:40 | MySQL Server: Optimizer | Verified (9 days) | S5 | 9.7.1 | Ubuntu (22.04.4 LTS) | x86 (x86_64, Intel(R) Xeon(R) Gold 5220) | Optimizer chooses 26x slower join order due to fanout misestimation despite histograms |
| 120868 | 2026-07-05 8:42 | 2026-07-06 5:30 | MySQL Server: Optimizer | Verified (9 days) | S5 | 9.7.1 | Linux (22.04.4 LTS) | x86 (x86_64, Intel(R) Xeon(R) Gold 5220) | Optimizer misses ORDER BY LIMIT optimization when ordering key is equivalent through join equality |
| 120867 | 2026-07-04 10:14 | 2026-07-06 11:36 | MySQL Server: Optimizer | Verified (9 days) | S1 | MySQL 9.7.1 | Any | Any | Const Table Optimization Incorrectly Evaluates FLOAT Comparison with Extreme DOUBLE Constant Due to Overflow |
| 120861 | 2026-07-03 12:43 | 2026-07-04 13:48 | MySQL Server: Optimizer | Verified (11 days) | S5 | 9.7.1 | Ubuntu (22.04.4 LTS) | x86 (x86_64, Intel(R) Xeon(R) Gold 5220) | SELECT DISTINCT inner join expands duplicate-insensitive fanout instead of using semijoin/existence semantics |
| 120857 | 2026-07-03 6:23 | 2026-07-07 7:25 | MySQL Server: Optimizer | Verified (8 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 (7 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 (8 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 (9 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 (12 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 (12 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 |
| 120850 | 2026-07-03 3:32 | 2026-07-03 9:57 | MySQL Server: Optimizer | Verified (12 days) | S5 | 9.7.1 | Linux (Ubuntu (22.04.4 LTS)) | x86 (x86_64, Intel(R) Xeon(R) Gold 5220) | Optimizer misses impossible INNER JOIN condition with IS NULL and normal equality |
| 120848 | 2026-07-02 17:43 | 2026-07-03 16:34 | MySQL Server: Data Types | Verified (12 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 (12 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 (12 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 (12 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 (12 days) | S2 | 9.6.0 | Ubuntu | Any | VIEW and CTE return wrong results with YEAR(), UNION and uncorrelated EXISTS subquery |
| Showing 1-30 of 11304 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
