You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "jin xing (Jira)" <ji...@apache.org> on 2019/09/19 06:26:00 UTC

[jira] [Comment Edited] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join

    [ 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: jinxing6042@126.com):
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)