Details
Description
MariaDB [test]> select json_object('a', json_object('b', 'c')); |
+-----------------------------------------+ |
| json_object('a', json_object('b', 'c')) | |
+-----------------------------------------+ |
| {"a": {"b": "c"}} | |
+-----------------------------------------+ |
1 row in set (0.000 sec) |
|
MariaDB [test]> select json_object('a', if(1, json_object('b', 'c'), json_object('e', 'f'))); |
+-----------------------------------------------------------------------+ |
| json_object('a', if(1, json_object('b', 'c'), json_object('e', 'f'))) | |
+-----------------------------------------------------------------------+ |
| {"a": "{\"b\": \"c\"}"} | |
+-----------------------------------------------------------------------+ |
1 row in set (0.001 sec) |
|
MariaDB [test]> select json_object('a', coalesce(json_object('b', 'c'))); |
+---------------------------------------------------+ |
| json_object('a', coalesce(json_object('b', 'c'))) | |
+---------------------------------------------------+ |
| {"a": "{\"b\": \"c\"}"} | |
+---------------------------------------------------+ |
1 row in set (0.000 sec) |
other functions (CASE, NULLIF, IFNULL) are likely affected too.
Attachments
Issue Links
- blocks
-
MDEV-26506 Over-quoted JSON when combining JSON_ARRAYAGG with JSON_OBJECT
- Closed
- relates to
-
MDEV-27350 Complex CHECK constraint loses JSON property
- Open
-
MDEV-27358 Table level CHECK(JSON_VALID()) constraint loses JSON property
- Open
-
MDEV-27359 Crossed JSON_VALID constraint imposes JSON property to a wrong column
- Open
-
MDEV-27361 Hybrid functions with JSON arguments do not send format metadata
- Open
-
MDEV-27370 UNION looses JSON property
- Open
-
MDEV-13701 Nesting JSON
- Closed
-
MDEV-26506 Over-quoted JSON when combining JSON_ARRAYAGG with JSON_OBJECT
- Closed
-
MDEV-27360 Column level CHECK constraint is not SQL Standard compliant
- Open
-
MDEV-27533 The result of `CONVERT(json USING ...)` is erroneously treated as JSON
- Open
-
MDEV-27864 Alter table modify column for same data type copying table
- Closed