Bug #79505 | "if(1,1,1.234)" return 1 while the "Decimals" is 3 | ||
---|---|---|---|
Submitted: | 3 Dec 2015 10:57 | Modified: | 3 Dec 2015 12:07 |
Reporter: | Su Dylan | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.7.8, 5.5.48, 5.6.29, 5.7.9 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[3 Dec 2015 10:57]
Su Dylan
[3 Dec 2015 12:01]
Peter Laursen
MySQL 5.6 also returns "1" whilst MariaDB 10.1 returns "1.000". -- Peter -- not a MySQL/Oracle or MariaDB person
[3 Dec 2015 12:07]
MySQL Verification Team
Hello Su Dylan, Thank you for the report. Thanks, Umesh