Filter pushdown for left outer joins with join_use_nulls = 1 #90978
Description
Company or project name
ClickHouse
Use case
Better filter pushdown in JOINs
Describe the solution you'd like
If
- we have a left outer JOIN, and
- the WHERE filter removes NULLs, and
- setting
join_use_nulls = 1
then the WHERE filter is pushed down and the JOIN is converted to an inner JOIN.
Describe alternatives you've considered
No response
Additional context
No response