Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Formatting obtained from 8.0 example at https://fmt.dev/latest/api.html#chrono-api
10.7.0 53b2c1f4664a3cb90f583979d9aa2771b7e1c98d (Debug) |
10.7.0-dbg>SELECT CURRENT_DATE();
|
+----------------+
|
| CURRENT_DATE() |
|
+----------------+
|
| 2021-09-20 |
|
+----------------+
|
1 row in set (0.000 sec)
|
|
10.7.0-dbg>SELECT SFORMAT ('{:Y-m-d}',CURRENT_DATE());
|
+-------------------------------------+
|
| SFORMAT ('{:Y-m-d}',CURRENT_DATE()) |
|
+-------------------------------------+
|
| NULL |
|
+-------------------------------------+
|
1 row in set, 1 warning (0.001 sec)
|
|
10.7.0-dbg>SHOW WARNINGS;
|
+---------+------+---------------------------------------+
|
| Level | Code | Message |
|
+---------+------+---------------------------------------+
|
| Warning | 4183 | SFORMAT error: invalid type specifier |
|
+---------+------+---------------------------------------+
|
1 row in set (0.000 sec)
|
|
10.7.0-dbg>SELECT SFORMAT ('{:Y-m-d}','2021-09-20');
|
+-----------------------------------+
|
| SFORMAT ('{:Y-m-d}','2021-09-20') |
|
+-----------------------------------+
|
| NULL |
|
+-----------------------------------+
|
1 row in set, 1 warning (0.000 sec)
|
|
10.7.0-dbg>SHOW WARNINGS;
|
+---------+------+---------------------------------------+
|
| Level | Code | Message |
|
+---------+------+---------------------------------------+
|
| Warning | 4183 | SFORMAT error: invalid type specifier |
|
+---------+------+---------------------------------------+
|
1 row in set (0.000 sec)
|
Attachments
Issue Links
- is caused by
-
MDEV-25015 Custom formatting of strings in MariaDB queries
- Closed
- relates to
-
MDEV-26648 Feature: SFORMAT auto-typing
- Open