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

Reply via email to