[ https://issues.apache.org/jira/browse/CALCITE-3206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16890610#comment-16890610 ]
Danny Chan commented on CALCITE-3206: ------------------------------------- For implicit type coercion, there is another issue CALCITE-2302, you can help to review the code if Interested. > Better error message when param type incompatibility > ---------------------------------------------------- > > Key: CALCITE-3206 > URL: https://issues.apache.org/jira/browse/CALCITE-3206 > Project: Calcite > Issue Type: Improvement > Components: core > Reporter: jin xing > Priority: Major > Labels: pull-request-available > Time Spent: 20m > Remaining Estimate: 0h > > In current code, when we query like below > {code:java} > @Test public void test() { > CalciteAssert.model(HR_FKUK_MODEL) > .query("select * from \"events\" where \"eventid\"='123'") > .returns(CalciteAssert.outputResult()); > } > {code} > Where {{eventid}} is of INTEGER type, Calcite will throw exception as below > {code:java} > Caused by: org.codehaus.commons.compiler.CompileException: Line 13, Column > 100: Cannot compare types "int" and "java.lang.String" > at > org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:12211) > at > org.codehaus.janino.UnitCompiler.compileBoolean2(UnitCompiler.java:4239) > at org.codehaus.janino.UnitCompiler.access$6600(UnitCompiler.java:215) > at > org.codehaus.janino.UnitCompiler$14.visitBinaryOperation(UnitCompiler.java:3957) > at > org.codehaus.janino.UnitCompiler$14.visitBinaryOperation(UnitCompiler.java:3935) > at org.codehaus.janino.Java$BinaryOperation.accept(Java.java:4864) > at > org.codehaus.janino.UnitCompiler.compileBoolean(UnitCompiler.java:3935) > at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:2475) > {code} > It's kind of hard to understand for user to refine the sql -- This message was sent by Atlassian JIRA (v7.6.14#76016)