[
https://issues.apache.org/jira/browse/CALCITE-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937726#comment-17937726
]
Alexander Drugov commented on CALCITE-6905:
-------------------------------------------
[~asolimando] I used git bisect and found offending commit:
commit e6de9b9c66c33e61f8301d6f7233042ce0dc038e
[CALCITE-6631] The common type for a comparison operator returns the wrong type
when comparing a Java type long with a SQL type INTEGER
> 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)
