[CALCITE-6362] JSON_OBJECT. Internal representation of DATE values leaks into resulting JSON object - ASF JIRA

XML

Word

Printable

JSON

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"}

causes

IGNITE-22032 Sql. JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object