Showing all 11
| 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 (6403 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 (6252 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 (1809 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 (1599 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 (1307 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 (1441 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 (844 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 (844 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 (340 days) | S5 | 8.0.41 | CentOS | x86 | Prepare Statement execute much slower than normal select query |
| 120152 | 2026-03-25 8:50 | 2026-06-04 8:38 | MySQL Server: Optimizer | Verified (151 days) | S2 | 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 |
| 121331 | 2026-09-21 5:05 | 2026-09-21 9:29 | MySQL Server: Optimizer | Verified (42 days) | S3 | 8.4.12, 9.7.3, 26.7.1 | Linux | Any | Optimizer discards the chosen range access and falls back to a table scan for antijoin / LEFT JOIN queries |
Showing all 11
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.014 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.