Details
Description
Actual Result
11.1.0-dbg>SELECT * FROM JSON_TABLE(JSON_KEY_VALUE('{"key1":{"a":01}}', '$.key1'), '$[*]' COLUMNS (k VARCHAR(11) PATH '$.key', v VARCHAR(5) PATH '$.value', id FOR ORDINALITY)) AS jt; |
Empty set (0.000 sec) |
|
11.1.0-dbg>
|
Expected Result
11.1.0-dbg>SELECT * FROM JSON_TABLE(JSON_KEY_VALUE('{"key1":{"a":01}}', '$.key1'), '$[*]' COLUMNS (k VARCHAR(11) PATH '$.key', v VARCHAR(5) PATH '$.value', id FOR ORDINALITY)) AS jt; |
+------+------+------+ |
| k | v | id |
|
+------+------+------+ |
| a | 1 | 1 |
|
+------+------+------+ |
1 row in set (0.000 sec) |
|
11.1.0-dbg>
|
Attachments
Issue Links
- is duplicated by
-
MDEV-31464 JSON_ARRAY_INTERSECT function prints zero when leading zero is present in a decimal integer
- Closed