Bug #109149 | The representation of 0 in MOD function in computing string | ||
---|---|---|---|
Submitted: | 20 Nov 2022 5:01 | Modified: | 21 Nov 2022 5:17 |
Reporter: | Chenglin Tian | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 8.0.31, 5.7 | OS: | Ubuntu |
Assigned to: | CPU Architecture: | x86 |
[20 Nov 2022 5:01]
Chenglin Tian
[21 Nov 2022 5:17]
MySQL Verification Team
Hello Chenglin Tian, Thank you for the report. regards, Umesh
[21 Nov 2022 8:37]
Roy Lyseng
Workaround: SELECT MOD(CAST('-12' AS SIGNED), -4);