Bug #101269 | using different index may produce different results | ||
---|---|---|---|
Submitted: | 22 Oct 2020 3:26 | Modified: | 11 Apr 2022 9:06 |
Reporter: | xiaoyang chen | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S1 (Critical) |
Version: | 5.7, 8.0, 8.0.22, 5.7.32 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[22 Oct 2020 3:26]
xiaoyang chen
[22 Oct 2020 3:40]
xiaoyang chen
no more
[22 Oct 2020 4:36]
MySQL Verification Team
Hello xiaoyang chen, Thank you for the report and test case. regards, Umesh
[17 Nov 2021 0:41]
hao chen
This bug has repaired in Bug#32345941 - SELECT RESULT IS MISMATCH WHEN USE COALESCE AND NOT. See: https://github.com/mysql/mysql-server/commit/c204c7ff9d40b37cd4e5e66246953d82ff4e31e1
[11 Apr 2022 9:06]
Erlend Dahl
The above observation is correct. Duplicate of Bug#102151 select result is mismatch when use COALESCE and not. which was fixed in 8.0.27.