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.

Fiddle

Describe alternatives you've considered

No response

Additional context

No response