| Showing all 10 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 44397 | 2009-04-22 2:46 | 2012-05-18 20:19 | MySQL Server: FULLTEXT search | Verified (6193 days) | S2 | 5.0.79, 5.1.33, 5.1.34, 6.0.9 | Any | Any | Negative relevancy value for boolean fulltext query using a left join |
| 47454 | 2009-09-19 19:33 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6042 days) | S3 | 5.1.35 | Any | Any | Not exists optimization method is not used for NULL columns in the right table |
| 105637 | 2021-11-19 9:52 | 2021-11-19 10:25 | MySQL Server: Optimizer | Verified (1599 days) | S2 | 8.0.25, 8.0.27 | Any | Any | left join + semijoin produce wrong results when using materialization strategy |
| 107585 | 2022-06-17 10:29 | 2022-06-17 11:18 | MySQL Server: Optimizer | Verified (1389 days) | S3 | 8.0.29 | Ubuntu (ubuntu 20.04) | x86 | Incorrect result in semi-join and left-join |
| 110614 | 2023-04-05 8:32 | 2023-04-05 13:48 | MySQL Server: Optimizer | Verified (1097 days) | S3 | 8.0 | Any | Any | Left join query with wrong result |
| 109155 | 2022-11-22 5:43 | 2023-12-13 11:44 | MySQL Server: Optimizer | Verified (1231 days) | S5 | 8.0.18, 8.0.31, 8.0.35 | Any | Any | Invalid scan on left join tables of which columns not in distinct output fields |
| 115565 | 2024-07-11 9:37 | 2024-07-11 13:11 | MySQL Server: Optimizer | Verified (634 days) | S3 | 8.0 | Any | Any | Partition tables:compare the field with null and return an incorrect result |
| 115559 | 2024-07-10 13:59 | 2024-07-11 13:10 | MySQL Server: Optimizer | Verified (634 days) | S3 | 8.0 | Any | Any | Row constructor comparison with nested join fails to match rows |
| 119447 | 2025-11-23 8:34 | 2025-11-27 5:04 | MySQL Server: Optimizer | Verified (130 days) | S5 | 8.0.41 | CentOS | x86 | Prepare Statement execute much slower than normal select query |
| 120152 | 2026-03-25 8:50 | 2026-03-26 9:05 | MySQL Server: Optimizer | Verified (11 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | Unexpected behavior of LEFT JOIN + empty subquery with NULL comparison in WHERE clause |
| Showing all 10 (Edit, Save, CSV, Feed) |
