[
https://issues.apache.org/jira/browse/CALCITE-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937758#comment-17937758
]
xiong duan commented on CALCITE-6905:
-------------------------------------
I guess this SQL involves a type conversion between a Java Type and an Sql Type.
> Comparing string and int produce exception
> ------------------------------------------
>
> Key: CALCITE-6905
> URL: https://issues.apache.org/jira/browse/CALCITE-6905
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.39.0
> Reporter: Alexander Drugov
> Priority: Major
>
> With java class
> {code:java}
> public class Employee {
> public String id
> ...
> }{code}
> {code:sql}
> select * from employees e where e.id = 1{code}
> This query produce {_}java.lang.NoSuchMethodException:
> org.apache.calcite.runtime.SqlFunctions.eq(java.lang.String, int){_}. But
> this worked at 1.38 version.
>
> However I successfully can execute:
> {code:sql}
> with t as (
> select '123' id
> )
> select id from t where id = 123
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
