Bug #83320 | round(bin) returns unexpected negative results | ||
---|---|---|---|
Submitted: | 10 Oct 2016 13:02 | Modified: | 17 Feb 2021 11:18 |
Reporter: | 帅 Bang | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.6, 5.6.33, 5.7.15 | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[10 Oct 2016 13:02]
帅 Bang
[12 Oct 2016 7:30]
MySQL Verification Team
Hello Bang, Thank you for the report and test case. Observed this with 5.6.33/5.7.15. Thanks, Umesh
[17 Feb 2021 11:18]
Erlend Dahl
This looks like it as been fixed in 8.0.23: [5 Oct 2020 7:07] Tor Didriksen 8.0.23 select round(c1, c3) from t1; +----------------------+ | round(c1, c3) | +----------------------+ | 18446744073709551615 | +----------------------+ 1 row in set (0.00 sec) select hex(round(c1, c3)) from t1; +--------------------+ | hex(round(c1, c3)) | +--------------------+ | FFFFFFFFFFFFFFFF | +--------------------+ 1 row in set (0.00 sec)