10.7.0-dbg>select SFORMAT ('FLOAT {:.5f}',3);
|
+-----------------------------+
|
| SFORMAT ('FLOAT {:.5f}',3) |
|
+-----------------------------+
|
| NULL |
|
+-----------------------------+
|
1 row in set, 1 warning (0.000 sec)
|
|
10.7.0-dbg>show warnings;
|
+---------+------+-------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+-------------------------------------------------------------+
|
| Warning | 4183 | SFORMAT error: precision not allowed for this argument type |
|
+---------+------+-------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
10.7.0-dbg>select SFORMAT ('FLOAT {:.5f}',3.1);
|
+-------------------------------+
|
| SFORMAT ( 'FLOAT {:.5f}',3.1) |
|
+-------------------------------+
|
| FLOAT 3.10000 |
|
+-------------------------------+
|
1 row in set (0.000 sec)
|
|
10.7.0-dbg>select SFORMAT ('FLOAT {:.5f}',3.);
|
+------------------------------+
|
| SFORMAT ('FLOAT {:.5f}',3.) |
|
+------------------------------+
|
| FLOAT 3.00000 |
|
+------------------------------+
|
1 row in set (0.000 sec)
|