Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
13.1
-
None
-
Not for Release Notes
Description
Hi,
I found that JSON_TYPE returns an unexpected warning on string and date values.
This is an example:
SELECT
|
JSON_TYPE(JSON_VALUE(JSON_OBJECT("id", 1, "name", "Monty"), '$.id')) AS json_type_numeric, |
JSON_TYPE(JSON_VALUE(JSON_OBJECT("id", 1, "name", "Monty"), '$.name')) AS json_type_string, |
JSON_TYPE(JSON_VALUE(JSON_OBJECT("id", 1, "d", CAST('2019-01-01' AS DATE)), '$.d')) AS json_type_date; -- INTEGER NULL NULL |
SHOW WARNINGS;
|
-- Warning 4038 Syntax error in JSON text in argument 1 to function 'json_type' at position 1
|
-- Warning 4038 Syntax error in JSON text in argument 1 to function 'json_type' at position 5 |