Hongze Zhang created CALCITE-2933:
-------------------------------------
Summary: In Druid adapter, expression like
"cast(cast(\"timestamp\" as timestamp) as varchar)" returns as epoch millisecond
Key: CALCITE-2933
URL: https://issues.apache.org/jira/browse/CALCITE-2933
Project: Calcite
Issue Type: Improvement
Reporter: Hongze Zhang
SQL 1:
{code}
select cast("timestamp" as timestamp) as t from "foodmart" order by t limit 1
{code}
Result:
{code}
T=1997-01-01 00:00:00
{code}
SQL 2:
{code}
select cast(cast("timestamp" as timestamp) as varchar) as t from "foodmart"
order by t limit 1
{code}
Result:
{code}
T=852076800000
{code}
The second query should returns the same value as the first one.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
