silundong opened a new pull request, #4266:
URL: https://github.com/apache/calcite/pull/4266
For the following SQL:
`
select t1.name from t1, t2
where t1.id = t2.id
and (
(t1.id > 20 and t2.height < 50)
or
(t1.weight < 200 and t2.sales > 100)
)
`
The disjuction `(t1.id > 20 and t2.height < 50) or (t1.weight < 200 and
t2.sales > 100)` uses t1 and t2, thus cannot be pushed below the join.
In fact, we can extract redundant `(t1.id > 20 or t1.weight < 200)` ,
`(t2.height < 50 or t2.sales > 100)` from this predicate by a new rule and push
down these two predicates to both side of Join input.
More detail: [https://issues.apache.org/jira/browse/CALCITE-6914](url)
--
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]
