[CALCITE-2103] error logical plan when size of In-list connected with OR exceeds inSubQueryThreshold

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 1.16.0
• Assignee: Julian Hyde
• Reporter: godfrey he
• Created: 21/Dec/17 12:19
• Updated: 29/Apr/19 17:14
• Resolved: 27/Jan/18 11:34

Description

inSubQueryThreshold = 3

SQL：

SELECT * FROM emp AS e WHERE e.empno in (130, 131, 132, 133, 134) OR e.ename in ('a', 'b', 'c', 'd', 'e')

logical plan：

LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
  LogicalFilter(condition=[OR(true, true)])
    LogicalJoin(condition=[=($1, $10)], joinType=[inner])
      LogicalJoin(condition=[=($0, $9)], joinType=[inner])
        LogicalTableScan(table=[[CATALOG, SALES, EMP]])
        LogicalAggregate(group=[{0}])
          LogicalValues(tuples=[[{ 130 }, { 131 }, { 132 }, { 133 }, { 134 }]])
      LogicalAggregate(group=[{0}])
        LogicalValues(tuples=[[{ 'a' }, { 'b' }, { 'c' }, { 'd' }, { 'e' }]])

the logical plan is wrong.

Issue Links

• duplicates: CALCITE-2071 Query with IN and OR in WHERE clause returns wrong result