10.7.0-dbg>CREATE TABLE t1 (c1 FLOAT);
|
Query OK, 0 rows affected (0.013 sec)
|
|
10.7.0-dbg>INSERT INTO t1 VALUES (1.1);
|
Query OK, 1 row affected (0.003 sec)
|
|
10.7.0-dbg>SELECT * FROM t1;
|
+------+
|
| c1 |
|
+------+
|
| 1.1 |
|
+------+
|
1 row in set (0.001 sec)
|
|
10.7.0-dbg>SELECT SFORMAT('{}',(SELECT 1.1));
|
+----------------------------+
|
| SFORMAT('{}',(SELECT 1.1)) |
|
+----------------------------+
|
| 1.1 |
|
+----------------------------+
|
1 row in set (0.000 sec)
|
|
10.7.0-dbg>SELECT SFORMAT('{}',(SELECT c1 FROM t1));
|
+-----------------------------------+
|
| SFORMAT('{}',(SELECT c1 FROM t1)) |
|
+-----------------------------------+
|
| 1.100000023841858 |
|
+-----------------------------------+
|
1 row in set (0.001 sec)
|