[CALCITE-2551] ClassCastException in SqlToRelConverter#pushDownNotForIn

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.18.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: pengzhiwei
• Created: 11/Sep/18 09:30
• Updated: 23/Dec/18 00:12
• Resolved: 13/Sep/18 21:53

Description

In the sql as follow:

select empno from emp 
where not case when true then deptno in (10,20) else true end

A ClassCastException was thrown out as follow:

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 

The reason for this issue is that   the SqlToRelConverter#pushDownNotForIn method missing consideration

 for SqlCase as the code shown below:

I have made a PR for this issue which push not down through SqlCase.Anybody can have a check for me? Thanks!

 

Issue Links

• links to: PR 827