Details
-
Bug
-
Status: In Review (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2.22, 10.3.15, 10.2, 10.3, 10.4, 10.5
-
None
-
Windows 10 64 bit
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