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

Posted to issues@calcite.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/05/02 02:43:09 UTC

[jira] [Created] (CALCITE-710) Identical Conditions in the WHERE-CLAUSE caused assertion error

Sean Hsuan-Yi Chu created CALCITE-710:
-----------------------------------------

             Summary: Identical Conditions in the WHERE-CLAUSE caused assertion error
                 Key: CALCITE-710
                 URL: https://issues.apache.org/jira/browse/CALCITE-710
             Project: Calcite
          Issue Type: Bug
            Reporter: Sean Hsuan-Yi Chu
            Assignee: Julian Hyde


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)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)