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
-
Activity
| Transition | Time In Source Status | Execution Times |
|---|
|
421d 19h 2m | 1 |
|
1348d 9h | 1 |
|
26d 35m | 1 |
|
15d 9h 36m | 1 |