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: [email protected] With regards, Apache Git Services
