[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933093#comment-16933093 ]
jin xing commented on CALCITE-3363: ----------------------------------- Check my PR please; For sql like below: select r1.sal from emp r1 where r1.deptno in (select deptno from dept d1 where deptno < 10 union all select deptno from dept d2 where deptno > 20) JoinUnionTransposeRule.RIGHT_UNIONĀ should NOT push the JOIN through UNION > JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join > ------------------------------------------------------------------ > > Key: CALCITE-3363 > URL: https://issues.apache.org/jira/browse/CALCITE-3363 > Project: Calcite > Issue Type: Bug > Components: core > Reporter: jin xing > Priority: Major > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > JoinUnionTransposeRule works by pull up union from below to top of join. Thus > it should not match semi/anti join by semantics. -- This message was sent by Atlassian Jira (v8.3.4#803005)