Bug #105762 | sum(least(a, NULL)) result error | ||
---|---|---|---|
Submitted: | 1 Dec 2021 9:42 | Modified: | 17 Dec 2021 18:18 |
Reporter: | Yukun Liang | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 8.0.13, 8.0.27, 5.7.36 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[1 Dec 2021 9:42]
Yukun Liang
[1 Dec 2021 10:09]
MySQL Verification Team
Hello Yukun Liang, Thank you for the report and test case. regards, Umesh
[17 Dec 2021 18:18]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL 8.0.29 release, and here's the proposed changelog entry from the documentation team: The functions MIN() and MAX() should return zero if they encounter a NULL value, as is done currently for integer and decimal types, but returned an incorrect result for double types. Thank you for the bug report.