v.19.6Improvements

Disable Push-down to Right Table in Left Join, Left Table in Right Join, and Both Tables in Full Join

Official CH changelog text
Disable push-down to right table in left join, left table in right join, and both tables in full join. This fixes wrong JOIN results in some cases. #4846 (Ivan)
Fix incorrect JOIN results by disabling push-down optimizations in certain JOIN types.

Why it matters

This change addresses incorrect query results caused by push-down optimizations during JOIN operations. By disabling push-down on the right table in LEFT JOIN, the left table in RIGHT JOIN, and both tables in FULL JOIN, the feature improves query correctness and reliability.

How to use it

This behavior is applied automatically with the update; users do not need to manually enable or configure anything. The fix is integrated into JOIN query execution to ensure correct results in the affected scenarios.

Related resources

PreviousNext