Bug #100967 | Join get wrong result for type bit(64) | ||
---|---|---|---|
Submitted: | 27 Sep 2020 6:35 | Modified: | 25 Nov 2020 18:02 |
Reporter: | Shenghui Wu | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 8.0.21 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[27 Sep 2020 6:35]
Shenghui Wu
[27 Sep 2020 21:24]
MySQL Verification Team
Thank you for the bug report.
[25 Nov 2020 12:27]
Tor Didriksen
Posted by developer: Fixed by the patch for: Bug #31832001 HASH JOIN MISMATCHES SIGNED AND UNSIGNED
[25 Nov 2020 18:02]
Paul DuBois
Posted by developer: Fixed in 8.0.23. When performing a hash join, the optimizer could register a false match between a negative integer value and a very large unsigned integer value.