[ https://issues.apache.org/jira/browse/CALCITE-2103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated CALCITE-2103: --------------------------------------------- Fix Version/s: 1.16.0 > error logical plan when size of In-list connected with OR exceeds > inSubQueryThreshold > ------------------------------------------------------------------------------------- > > Key: CALCITE-2103 > URL: https://issues.apache.org/jira/browse/CALCITE-2103 > Project: Calcite > Issue Type: Bug > Reporter: godfrey he > Assignee: Julian Hyde > Priority: Major > Fix For: 1.16.0 > > > {code:borderStyle=solid} > inSubQueryThreshold = 3 > {code} > SQL: > {code:borderStyle=solid} > SELECT * FROM emp AS e WHERE e.empno in (130, 131, 132, 133, 134) OR e.ename > in ('a', 'b', 'c', 'd', 'e') > {code} > logical plan: > {code:borderStyle=solid} > 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' }]]) > {code} > the logical plan is wrong. -- This message was sent by Atlassian JIRA (v7.6.3#76005)