Bug #99807 | natural join returns wrong result when expression index is used | ||
---|---|---|---|
Submitted: | 8 Jun 2020 17:35 | Modified: | 25 Jun 2020 15:32 |
Reporter: | wj huang | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 8.0.19 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[8 Jun 2020 17:35]
wj huang
[8 Jun 2020 21:09]
MySQL Verification Team
Thank you for the bug report.
[25 Jun 2020 15:32]
Paul DuBois
Posted by developer: Fixed in 8.0.22. NATURAL JOIN evaluation could inadvertantly match hidden virtual columns created by functional indexes.