Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 13.1
Description
Hi,
In the following test case, I adjust the order of the values in a JSON data, but the first view generates a truncated JSON:
CREATE VIEW v_bad AS |
SELECT JSON_SET('{}', '$.k1', 'x', '$.k2', REPEAT('b', 40)) AS j; |
|
|
CREATE VIEW v_good AS |
SELECT JSON_SET('{}', '$.k2', REPEAT('b', 40), '$.k1', 'x') AS j; |
|
|
SELECT 'bad_view' AS case_name, LENGTH(j) AS len, JSON_VALID(j) AS is_valid, j FROM v_bad; -- bad_view 33 0 {"k1": "x", "k2": "bbbbbbbbbbbbbb |
SELECT 'good_view' AS case_name, LENGTH(j) AS len, JSON_VALID(j) AS is_valid, j FROM v_good; -- good_view 61 1 {"k2": "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb", "k1": "x"} |
Attachments
Issue Links
- is duplicated by
-
MDEV-39973 Incorrect data size in CREATE TABLE when using JSON_INSERT in a subquery
-
- Closed
-