Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-710

Identical conditions in the WHERE clause cause assertion error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.3.0-incubating
    • Component/s: None
    • Labels:
      None

      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)

        Attachments

          Activity

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              seanhychu Sean Hsuan-Yi Chu
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: