Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
Description
When a CAST function is used inside a JSON_OBJECT, then resulting JSON contains a number of days instead
SELECT JSON_OBJECT('a': CAST('2010-01-01' AS DATE)) as c1 {"a":14610}
I expected to get a date in a string form as many databases do in such case:
Bigquery:
SELECT JSON_OBJECT('a', CAST('2010-01-10' AS DATE)) {"a":"2010-01-10"}
PostgreSQL
SELECT json_build_object('a', '2010-01-01'::DATE) {"a":"2010-01-01"}
MySql
SELECT json_object('a', DATE '2010-01-01') {"a": "2010-01-01"}
Attachments
Issue Links
- causes
-
IGNITE-22032 Sql. JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object
- Open