morningman commented on issue #3480:
URL: 
https://github.com/apache/incubator-doris/issues/3480#issuecomment-624617918


   > @morningman Hi, I have the check for join type:
   > 
   > ```
   >             if ((tblRef.getJoinOp().isInnerJoin() || 
tblRef.getJoinOp().isLeftOuterJoin())) {
   > ```
   > 
   > So why left semi join will be affected?
   
   For this example: 
   
   ```
   select * from
   join1 left semi join join2
   on join1.id = join2.id and join2.id > 1;
   ```
   When you call `join1.getJoinOp()`, the `joinOp` of table `join1` is null, 
but `getJoinOp()` will
   return `INNER_JOIN`.
   
   So for table `join1`, it will pass the `if(inner join)` check, and begin to 
do the predicate passing
   through and push down.


----------------------------------------------------------------
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:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to