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

Posted to commits@calcite.apache.org by GitBox <gi...@apache.org> on 2019/09/22 15:55:39 UTC

[GitHub] [calcite] jinxing64 commented on issue #1466: [CALCITE-3363] JoinUnionTransposeRule.RIGHT_UNION should not match ANTI join

jinxing64 commented on issue #1466: [CALCITE-3363] JoinUnionTransposeRule.RIGHT_UNION should not match ANTI join
URL: https://github.com/apache/calcite/pull/1466#issuecomment-533893833
 
 
   @hsyuan 
   >Not only ANTI, but also SEMI. It should not match SEMI either.
   
   I guess semi-join should be fine.
   ```
   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)
   
   is equivalent to 
   
   select r1.sal from emp r1 where r1.deptno  in (select deptno from dept d1 where deptno < 10)
   union all
   select r1.sal from emp r1 where r1.deptno  in (select deptno from dept d1 where deptno > 20)
   
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services