Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.7(EOL)
-
None
Description
Split from MDEV-25015
|
10.7.0 53b2c1f4664a3cb90f583979d9aa2771b7e1c98d (Debug) |
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)
|
And libfmt can print floats correctly, so pass float as float.
Attachments
Issue Links
- is caused by
-
MDEV-25015 Custom formatting of strings in MariaDB queries
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue is caused by |
| Description |
Split from {noformat:title=10.7.0 53b2c1f4664a3cb90f583979d9aa2771b7e1c98d (Debug)} 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) {noformat} |
Split from {noformat:title=10.7.0 53b2c1f4664a3cb90f583979d9aa2771b7e1c98d (Debug)} 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) {noformat} And libfmt can print floats correctly, so pass float as float. |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Assignee | Sergei Golubchik [ serg ] |
| Fix Version/s | 10.7.1 [ 26120 ] | |
| Fix Version/s | 10.7 [ 24805 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 125529 ] | MariaDB v4 [ 159716 ] |