| Showing all 63 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 120302 | 2026-04-20 9:51 | 2026-04-20 11:26 | MySQL Server: Optimizer | Verified (87 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 (80 days) | S2 | 9.6.0 | Any | Any | VIEW and equivalent CTE return different results with UNION, YEAR(0), and repeated reference in subquery |
| 120350 | 2026-04-27 8:35 | 2026-04-28 4:31 | MySQL Server: Optimizer | Verified (79 days) | S2 | 9.6.0 | Linux | Any | Prefix index on TEXT column causes range scan to miss qualifying rows in MySQL |
| 120352 | 2026-04-27 9:34 | 2026-04-28 4:26 | MySQL Server: Optimizer | Verified (79 days) | S2 | 9.6.0 | Linux | Any | Prefix index with length 1 causes incorrect "Zero rows" optimization with float overflow literal in range condition |
| 120476 | 2026-05-14 11:53 | 2026-05-18 8:25 | MySQL Server: Optimizer | Verified (59 days) | S2 | 9.6.0 | Linux | Any | Index Merge Union returns duplicate row for overlapping OR conditions, producing wrong result count |
| 120527 | 2026-05-22 11:47 | 2026-06-01 9:39 | MySQL Server: Optimizer | Verified (45 days) | S2 | 9.6.0 | Linux | Any | FULLTEXT index scan with ORDER BY and numeric WHERE filter returns empty result set |
| 120640 | 2026-06-09 10:13 | 2026-06-09 11:00 | MySQL Server: Optimizer | Verified (37 days) | S3 | 9.6.0 | Ubuntu (22.04) | Any | WHERE NULLIF(...) IS NULL returns rows when NULLIF is non-NULL |
| 120668 | 2026-06-13 17:28 | 2026-06-15 12:40 | MySQL Server: Optimizer | Verified (31 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `LEAST(...) IN (col)` |
| 120669 | 2026-06-13 17:29 | 2026-06-16 5:35 | MySQL Server: Optimizer | Verified (30 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `CASE + LIKE + XOR` with `||` |
| 120674 | 2026-06-13 17:32 | 2026-06-26 4:38 | MySQL Server: Optimizer | Verified (20 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `CASE with EXISTS` compared to column |
| 120675 | 2026-06-13 17:32 | 2026-06-30 13:24 | MySQL Server: Optimizer | Verified (16 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `CAST(NULL) IN col || CASE ... IN col` |
| 120677 | 2026-06-13 17:33 | 2026-06-30 13:29 | MySQL Server: Optimizer | Verified (16 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `col OR GREATEST(...)` |
| 120736 | 2026-06-22 6:46 | 2026-07-08 8:56 | MySQL Server: Optimizer | Verified (8 days) | S3 | 9.6.0 | Any | Any | FORCE INDEX make a query with OR (NOT NULL column <=> NULL) degrade from an index range scan to a full table scan |
| 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) |
| 120294 | 2026-04-19 17:16 | 2026-04-27 14:11 | MySQL Server: Optimizer | Verified (80 days) | S3 | 9.6.0; 8.0.45 | Any | Any | Inconsistent fractional seconds precision (FSP) for TIME function results between VIEW and CTE |
| 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 |
| 120842 | 2026-07-02 16:34 | 2026-07-02 20:22 | MySQL Server: Optimizer | Verified (14 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 (13 days) | S2 | 9.6.0 | Ubuntu | Any | VIEW and CTE return wrong results with YEAR(), UNION and uncorrelated EXISTS subquery |
| 120845 | 2026-07-02 16:55 | 2026-07-03 7:44 | MySQL Server: Optimizer | Verified (13 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 (13 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 (13 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 (13 days) | S2 | 9.6.0 | Ubuntu | Any | Inconsistent comparison behavior for MAKETIME() expression between VIEW/CTE and TEMPORARY TABLE |
| 120852 | 2026-07-03 5:32 | 2026-07-03 10:09 | MySQL Server: Data Types | Verified (13 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 (13 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 (10 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 (9 days) | S2 | 9.6.0,9.7.0 | Ubuntu | Any | Wrong result with QUOTE(NULL) in VIEW/CTE WHERE predicate |
| 120857 | 2026-07-03 6:23 | 2026-07-07 7:25 | MySQL Server: Optimizer | Verified (9 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 (2 days) | S2 | 9.6.0,9.7.0 | Ubuntu | Any | Wrong result after predicate pushdown to HAVING for SUM(DOUBLE) in VIEW/CTE |
| 120215 | 2026-04-04 16:59 | 2026-04-06 5:38 | MySQL Server: Optimizer | Verified (101 days) | S3 | 9.6.0 | Ubuntu (22.04) | Any | Inconsistent window aggregate results with GROUP BY ... WITH ROLLUP |
| 40151 | 2008-10-19 18:12 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (4823 days) | S3 | 6.0/5.6 | Any | Any | EXPLAIN doesn't show DISTINCT+join optimization |
| 33376 | 2007-12-19 17:35 | 2016-10-16 20:45 | MySQL Server: Row Based Replication ( RBR ) | Verified (5298 days) | S2 | 5.1, 6.0 bzr | Any | Any | Write set for table not set correctly when inserting an empty set |
| 60345 | 2011-03-04 17:11 | 2013-01-15 15:25 | MySQL Server | Verified (4930 days) | S5 | 5.1.55 6.0.11 | Any | Any | trim trailing spaces processes data only byte wise (the continue of bug14637) |
| 119918 | 2026-02-17 8:12 | 2026-02-17 8:31 | MySQL Server: Optimizer | Verified (149 days) | S2 | 9.6.0 | Any | Any | Tree based explain format doesn't work well with MySQL Client or MySQL Shell |
| 119938 | 2026-02-25 7:36 | 2026-03-04 3:50 | MySQL Server: Partitions | Verified (134 days) | S2 | 8.0.45, 8.4.8, 9.6.0 | Any | Any | select partition table with virtual column return wong result |
| 120146 | 2026-03-25 6:22 | 2026-06-08 11:29 | MySQL Server: Optimizer | Verified (38 days) | S2 | 9.6.0 | Linux (ubuntu 20.04) | x86 | Wrong result due to incorrect const-table pruning for NOT IN on FLOAT UNIQUE column in MEMORY engine |
| 120206 | 2026-04-02 19:48 | 2026-06-25 12:14 | MySQL Server: Partitions | Verified (21 days) | S2 | 8.0.46, 8.4.9, 9.6.0 | Any | Any | EXCHANGE PARTITION bypasses CHECK CONSTRAINT validation |
| 120217 | 2026-04-05 12:27 | 2026-04-06 5:24 | MySQL Server: Optimizer | Verified (101 days) | S3 | 9.6.0 | Ubuntu (22.04) | Any | GROUPING() in ORDER BY of EXISTS/IN/ALL/ANY subquery: invalid arguments not rejected |
| 120222 | 2026-04-07 12:02 | 2026-04-09 19:30 | MySQL Server: Data Types | Verified (98 days) | S2 | 9.6.0 | Linux | Any | VECTOR(n) dimension silently wraps to wrong value due to integer overflow in parser |
| 120223 | 2026-04-07 12:06 | 2026-04-09 19:33 | MySQL Server: Data Types | Verified (98 days) | S2 | 9.6.0 | Linux | Any | VECTOR(0) silently accepted, produces unusable column with corrupted metadata (dimension 4294967295) |
| 120251 | 2026-04-12 11:47 | 2026-04-13 4:58 | MySQL Server: DDL | Verified (94 days) | S2 | 9.6.0 | Any | Any | REPLACE INTO silently bypasses ON DELETE FK rules with innodb_native_foreign_keys=OFF |
| 120265 | 2026-04-14 8:24 | 2026-04-14 9:47 | MySQL Server: Optimizer | Verified (93 days) | S1 | 9.6.0 | Any | Any | Query returns with UNION, INTERSECT ALL and Derived SELECT DISTINCT |
| 120291 | 2026-04-19 16:45 | 2026-04-27 13:16 | MySQL Server: Optimizer | Verified (80 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 (80 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 (80 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 |
| 41071 | 2008-11-27 14:31 | 2025-12-07 20:45 | MySQL Server: C API (client library) | Patch pending (6397 days) | S3 | 6.0 | Any | Any | libmysql 6.0 doesn't work with Server < 6.0 (charset problems) |
| 40206 | 2008-10-21 12:12 | 2012-05-18 20:19 | MySQL Server: Embedded Library ( libmysqld ) | In progress (6443 days) | S2 | 5.1.30, 6.0.8-alpha | Linux (PPC) | Any | Timeout in "embedded" tests |
| 10132 | 2005-04-25 3:00 | 2018-09-23 20:45 | MySQL Server: InnoDB storage engine | Verified (4557 days) | S1 | 5.1, 6.0 | Linux (Linux) | Any | Crashing the server on corrupt InnoDB page is unhelpful |
| 50628 | 2010-01-26 15:46 | 2022-12-04 20:45 | MySQL Server: General | Verified (6015 days) | S3 | 5.5, 6.0,5.1 | Any | Any | Object names not accessible via case sensitive reference on lctn=1 systems |
| 43915 | 2009-03-27 15:40 | 2012-05-18 20:19 | MySQL Server: Compiling | Verified (6320 days) | S3 | 6.0 | Windows (Vista X64) | Any | Windows Server X64: so many compiler warnings |
| 43726 | 2009-03-18 12:07 | 2013-03-03 20:45 | MySQL Server: MyISAM storage engine | Verified (6329 days) | S5 | 5.1.32/6.0 | Any | Any | THR_LOCK_myisam is locked while flushing unwritten key blocks to disk |
| 43531 | 2009-03-10 11:24 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (6155 days) | S3 | 5.1, 6.0.11-bzr | Linux | Any | Crash if Falcon or MyISAM, subqueries, 4 clients |
| 43514 | 2009-03-09 21:16 | 2012-05-18 20:19 | MySQL Server: MyISAM storage engine | Verified (6337 days) | S3 | 6.0.11 | Windows | Any | Drop MyISAM fails on Windows with lower_case_table_names = 2 |
| 48151 | 2009-10-19 14:44 | 2022-12-04 20:45 | MySQL Server: General | Verified (6114 days) | S3 | 6.0.14 | MacOS (10.6.1) | Any | Tables not closed on Mac OS X using UTF-8 uppercase characters |
| 39775 | 2008-10-01 14:39 | 2022-12-04 20:45 | MySQL Server: Logging | Verified (6496 days) | S3 | 6.0.8,6.0 bzr,5.4 | Any | Any | DBUG problems in 6.0 |
| 37578 | 2008-06-23 7:00 | 2016-10-16 20:45 | MySQL Server: Replication | Verified (6595 days) | S3 | 5.1, 5.0, 6.0 | Any | Any | Execute Stored Functions Without Prelocks |
| 48245 | 2009-10-22 20:25 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6110 days) | S3 | 5.1,mysql-6.0-codebase-bugfixing | Any | Any | crash in Bitmap<64u>::merge called by add_key_field |
| 30985 | 2007-09-12 16:03 | 2012-05-18 20:19 | MySQL Server: Charsets | Verified (6874 days) | S3 | 6.0.3-alpha-debug | Linux (SUSE 10 64-bit) | Any | Results from weight_string() not as in specification |
| 30241 | 2007-08-04 20:39 | 2024-01-03 9:13 | MySQL Server: Charsets | Verified (6499 days) | S2 | 5.1, 6.0 | Linux | Any | Regular expression problems |
| 54121 | 2010-06-01 3:17 | 2011-02-16 23:44 | MySQL Server: General | Verified (5889 days) | S2 | M3 (Celosia), M4 (Dahlia), 6.0 | Any | Any | events_scheduling.test times out sporadically |
| Showing all 63 (Edit, Save, CSV, Feed) |
