You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "pengzhiwei (JIRA)" <ji...@apache.org> on 2018/09/11 09:31:00 UTC

[jira] [Created] (CALCITE-2551) ClassCastException in SqlToRelConverter#pushDownNotForIn

pengzhiwei created CALCITE-2551:
-----------------------------------

             Summary: ClassCastException in SqlToRelConverter#pushDownNotForIn
                 Key: CALCITE-2551
                 URL: https://issues.apache.org/jira/browse/CALCITE-2551
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.17.0
            Reporter: pengzhiwei
            Assignee: Julian Hyde


In the sql as follow:
{code:java}
select empno from emp 
where not case when true then deptno in (10,20) else true end
{code}
A ClassCastException was thrown out as follow:
{code:java}
java.lang.ClassCastException: org.apache.calcite.sql.fun.SqlCase cannot be cast to org.apache.calcite.sql.SqlBasicCall

at org.apache.calcite.sql2rel.SqlToRelConverter.pushDownNotForIn(SqlToRelConverter.java:987)
at org.apache.calcite.sql2rel.SqlToRelConverter.convertWhere(SqlToRelConverter.java:1070)
at 
{code}
The problem is that   the SqlToRelConverter#pushDownNotForIn method miss consideration

 for SqlCase.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)