[CALCITE-710] Identical conditions in the WHERE clause cause assertion error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0-incubating
• Assignee: Julian Hyde
• Reporter: Sean Hsuan-Yi Chu
• Created: 02/May/15 00:43
• Updated: 01/Jun/15 18:25
• Resolved: 05/May/15 22:23

Description

The following is a simple example,
select empno
from EMP
where deptno in (1, 2) or deptno in (1, 2)
(Using AND can also reproduce this issue)

We have two identical conditions in the where-clause. Queries falling in this pattern triggers assertion error (SqlToRelConverter.java:4083)