Re: Bug(about timestamp dataType) - 20240509

[Xiong Duan]

Hi developer, Please log it in Calcite Jira:
https://issues.apache.org/jira/browse/CALCITE
<https://issues.apache.org/jira/projects/CALCITE/issues/CALCITE-4502?filter=allopenissues>
and
also use code reformat when description.


小艾 <854413...@qq.com.invalid> 于2024年5月9日周四 16:30写道：

> Version 1.36.0
> When there are two tables : #1 #2
> #1 has field(name is field1,dateType is Timestamp)
> #2 has field(name is field2,dateType is also Timestamp)
>
>
> Then will happen the Bug like that：
>
>
> Error while executing SQL "SELECT * from `#1` where `#1`.`Field1` =
> (SELECT `#2`.`Field2` from `#2` LIMIT 1)":Error while compiling generated
> Java code:public static class Record2_0 implements java.io.serializable {
> &nbsp;public boolean f0;
> &nbsp;public java.sql.Timestamp f1;
> ....
> ....
> }
>
>
>
>
> public ...Enumerable bind(...&nbsp; root){
> &nbsp;accumulatorAdders.add(new Function2(){
> &nbsp; &nbsp;public Record2_2 apply(Record2_0,Object[] in){
> &nbsp; &nbsp; &nbsp; &nbsp;...
> &nbsp; &nbsp; &nbsp; &nbsp;acc.f0=true;
> &nbsp; &nbsp; &nbsp; &nbsp;final Long input_value =
> ....SqlFunctions.toLongOptional(in[0]);
> &nbsp; &nbsp; &nbsp; &nbsp;acc.f1 = input_value;
> &nbsp; &nbsp; &nbsp; &nbsp;...
> }
> )
> }
>
>
> Data type conversion exception, please handle it.