-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.2, 10.3, 10.3.9
-
Fix Version/s: 10.2.18
-
Component/s: JSON
-
Labels:None
-
Environment:Ubuntu 18.04
CREATE TEMPORARY TABLE a ( |
`data` mediumtext DEFAULT NULL |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
INSERT INTO a VALUES ('{}'); |
|
UPDATE a SET |
data = JSON_INSERT(data, '$.messages', JSON_QUERY('[]', '$')) , |
data = JSON_ARRAY_APPEND(data, '$.messages', JSON_QUERY('{"date":"2018-09-03","text":"mmmmmmm"}', '$')); |
|
-- Error (4038): Syntax error in JSON text in argument 1 to function 'json_array_append' at position 15
|
|
-- BUT, If in "JSON_QUERY('[]', '$'))" array is not empty:
|
|
UPDATE a SET |
data = JSON_INSERT(data, '$.messages', JSON_QUERY('["AAAAA"]', '$')) , |
data = JSON_ARRAY_APPEND(data, '$.messages', JSON_QUERY('{"date":"2018-09-03","text":"mmmmmmm"}', '$')); |
|
-- Not errors |
- relates to
-
MDEV-17001 JSON_MERGE returns nullwhen merging empty array
-
- Closed
-