[jira] [Commented] (CALCITE-3899) cast( string as date ) throw exception in dynamic parameter

["Danny Chen (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-3899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17077083#comment-17077083 ] 

Danny Chen commented on CALCITE-3899:
-------------------------------------

Thanks, can you try the master code, 1.12 is a very old version.

> cast( string as date ) throw exception in dynamic parameter
> -----------------------------------------------------------
>
>                 Key: CALCITE-3899
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3899
>             Project: Calcite
>          Issue Type: Bug
>    Affects Versions: 1.12.0
>            Reporter: Zhixiong Chen
>            Priority: Major
>
> sql like::
> SELECT   cast( ? as date)
>  FROM
>  Table  group by cast( ? as date)
> the dynamic parameter is string like  '2020-04-07'
>  
> But it throw exception like  java.lang.String cannot be cast to java.lang.Integer
> then I find in calcite plan it will cast string as integer and throw exception
> public Object current(){
>     return (Integer) root.get("?0");
>  }
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)