Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.1.21, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
-
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)
|