[ https://issues.apache.org/jira/browse/CALCITE-2933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16796912#comment-16796912 ]
Danny Chan commented on CALCITE-2933: ------------------------------------- [~zhztheplayer] It seems that the error does not has any relationship with the cast func reduction, i have tried {code:java} Select cast(\"store_sales\" as varchar) as t from \"foodmart\" order by t limit 1 {code} and {code:java} Select cast(\"timestamp\" as varchar) as t from \"foodmart\" order by t limit 1 {code} they all throw the same exception. I tried to open the debug log of Druid server, but i don't know where it is yet. > 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: Bug > Affects Versions: 1.18.0 > Reporter: Hongze Zhang > Assignee: Danny Chan > Priority: Major > > 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 with the same format as the first one. > See test case: > https://github.com/apache/calcite/blob/1229ef27094ea73ad9c7a397f442285c7e1df9b0/druid/src/test/java/org/apache/calcite/test/DruidAdapterIT2.java#L3930 -- This message was sent by Atlassian JIRA (v7.6.3#76005)