[
https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933093#comment-16933093
]
jin xing edited comment on CALCITE-3363 at 9/19/19 6:25 AM:
------------------------------------------------------------
Check my PR please;
For sql like below:
select r1.sal from emp r1 where r1.deptno not 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
was (Author: [email protected]):
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)
