Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.21, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 12.1(EOL)
-
None
-
MariaDB binary from Alpine Linux 3.5, running in a docker container on an Intel Xeon CPU (E5-2640 stepping 7, 2.50GHz)
Description
H know that floating point maths isn't precise, but this particular query on a regular FLOAT field in an InnoDB table can't be explained with precision errors:
MariaDB [...]> SELECT total, ROUND(`total`, 0) FROM table;
|
+---------+-------------------+
|
| total | ROUND(`total`, 0) |
|
+---------+-------------------+
|
| 5233510 | 5233512 |
|
+---------+-------------------+
|
1 row in set (0.00 sec)
|