[jira] [Created] (CALCITE-2933) In Druid adapter, expression like "cast(cast(\"timestamp\" as timestamp) as varchar)" returns as epoch millisecond

["Hongze Zhang (JIRA)" <ji...@apache.org>]

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)