[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maksim Zhuravkov updated CALCITE-6362: -------------------------------------- Summary: JSON_OBJECT. Internal representation of DATE values leaks into resulting JSON object (was: JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object) > JSON_OBJECT. Internal representation of DATE values leaks into resulting JSON > object > ------------------------------------------------------------------------------------ > > Key: CALCITE-6362 > URL: https://issues.apache.org/jira/browse/CALCITE-6362 > Project: Calcite > Issue Type: Bug > Components: core > Reporter: Maksim Zhuravkov > Priority: Minor > > When a CAST function is used inside a JSON_OBJECT, then resulting JSON > contains a number of days instead > {code} > SELECT JSON_OBJECT('a': CAST('2010-01-01' AS DATE)) as c1 > {"a":14610} > {code} > I expected to get a date in a string form as many databases do in such case: > Bigquery: > {code} > SELECT JSON_OBJECT('a', CAST('2010-01-10' AS DATE)) > {"a":"2010-01-10"} > {code} > PostgreSQL > {code} > SELECT json_build_object('a', '2010-01-01'::DATE) > {"a":"2010-01-01"} > {code} > MySql > {code} > SELECT json_object('a', DATE '2010-01-01') > {"a": "2010-01-01"} > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)