| « Show Previous 10 Entries | Showing 11-20 of 1405 (Edit, Save, CSV, Feed) | Show Next 10 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 120732 | 2026-06-20 13:22 | 2026-06-22 6:37 | MySQL Server: Optimizer | Verified (108 days) | S3 | MySQL 9.6 | Any (Storage Engine: InnoDB) | Any | Derived Table Merging Causes Incorrect Duplicate Removal with DISTINCT + GROUP BY + SUM(DISTINCT EXISTS(subquery)) |
| 120733 | 2026-06-20 13:38 | 2026-06-22 9:29 | MySQL Server: Optimizer | Verified (108 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 |
| 119097 | 2025-09-30 9:04 | 2025-12-15 11:15 | MySQL Server: Optimizer | Verified (297 days) | S2 | MySQL 8.4.6 | Windows | Other (x64) | STRAIGHT_JOIN returns different results compared to INNER JOIN with identical conditions |
| 115661 | 2024-07-22 5:48 | 2024-08-15 14:22 | MySQL Server: Optimizer | Verified (808 days) | S2 | mysql 8.4.1, 8.0.38, 9.0.0 | Linux | Any | Query results are incorrect after semijoin is turned on |
| 120022 | 2026-03-11 2:22 | 2026-03-11 7:10 | MySQL Server: Optimizer | Verified (211 days) | S3 | MySQL 8.0.28 | Any | Any | CAST(AVG()) returns a different result than CAST(SUM()/COUNT()) on DECIMAL values |
| 107220 | 2022-05-05 9:18 | 2022-05-11 14:09 | MySQL Server: Optimizer | Verified (1617 days) | S3 | MySQL 8.0, 8.0.29 | Any | Any | Json query results are inconsistent with or without generated column indexes |
| 35724 | 2008-03-31 22:24 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6427 days) | S2 | MySQL 5.0.51a-community-nt, 5.1, 6.0 BK | Any | Any | Non-found left join data passed as a parameter to a function in WHERE |
| 41064 | 2008-11-27 2:25 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6524 days) | S3 | MySQL 5.0.27-standard, 5.0.70, 6.0.7 | Linux | Any | enum query never use index and it should |
| 119413 | 2025-11-17 23:52 | 2025-12-07 21:06 | MySQL Server: Optimizer | Verified (305 days) | S3 | mysql Ver 9.4. | Any | Any | Intersection order |
| 106155 | 2022-01-13 7:19 | 2022-01-13 8:34 | MySQL Server: Optimizer | Verified (1729 days) | S2 | mysql Ver 8.0.27 for Linux on x86_64 (M | Any | Any | subquery return wrong record when use expression index |
| « Show Previous 10 Entries | Showing 11-20 of 1405 (Edit, Save, CSV, Feed) | Show Next 10 Entries » |
