Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3, 10.4
-
None
Description
MDB returns a signed 0 value from FORMAT() function.
Consider the scenario.
MariaDB [test]> create table i1(f float);
|
Query OK, 0 rows affected (0.719 sec)
|
MariaDB [test]> insert into i1 values (0.0025);
|
Query OK, 1 row affected (0.490 sec)
|
MariaDB [test]> insert into i1 values (-0.0025);
|
Query OK, 1 row affected (1.063 sec)
|
MariaDB [test]> select round(f,2) from i1;
|
+------------+
|
| round(f,2) |
|
+------------+
|
| 0.00 |
|
| -0.00 |
|
+------------+
|
2 rows in set (0.001 sec)
|