morrySnow opened a new pull request, #23440:
URL: https://github.com/apache/doris/pull/23440
we use two facilities to do predicate infer: PredicatePropagation and
PullUpPredicates. When we do propagation in PredicatePropagation, we save the
source predicates could be used in the upper node. However, we shoud not save
any predicates from join on clause. Because these expression is not same with
predicate in filter and could not prepagate to other not except the join's
Immediate children.
For example:
```sql
select a.c1
from a
left join b on a.c2 = b.c2 and a.c1 = '1'
left join c on a.c2 = c.c2 and a.c1 = '2'
inner join d on a.c3=d.c3
```
the predicates `a.c1 = '1'` and `a.c1 = '2'` should not be inferred as
filter to relation `a`
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
