Details
Description
Hi this sentence:
select JSON_TYPE(json_value(JSON_OBJECT("id", 1, "name", 'Monty', "date", Cast('2019-01-01' as Date) ), '$.date')); |
Returns INTEGER, at least it should say 'STRING'
select JSON_TYPE(json_value(JSON_OBJECT("id", 1, "name", 'Monty', "date", Cast('2019-01-01' as Date) ), '$.name')); |
returns NULL, if you apply JSON_QUOTE for the JSON_VALUE returned value, it returns STRING.
Attachments
Issue Links
- is part of
-
MDEV-15931 JSON_TYPE doesn't work correctly
-
- Stalled
-