[MDEV-20700] FORMAT() returns a signed 0.0 value Created: 2019-09-30  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Data types
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Roman Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: 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)


Generated at Thu Feb 08 09:01:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.