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

[Zhixiong Chen (Jira)]

Zhixiong Chen created CALCITE-3899:
--------------------------------------

             Summary: 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


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


/* 22 */ public Object current() {
/* 23 */ return (Integer) root.get("?0");
/* 24 */ }



 



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