v.20.1New Feature

Improvements in ANY JOIN Logic Consistency

Official CH changelog text
Improvements in consistency of ANY JOIN logic. Now t1 ANY LEFT JOIN t2 equals t2 ANY RIGHT JOIN t1. #7665 (Artem Zuikov)
Improved consistency in the behavior of ANY JOIN operations, ensuring that t1 ANY LEFT JOIN t2 now produces the same result as t2 ANY RIGHT JOIN t1.

Why it matters

To resolve inconsistencies in ANY JOIN logic, making the join results symmetric and predictable regardless of join direction. This enhancement simplifies reasoning about queries and increases reliability when using ANY JOIN.

How to use it

Users can directly benefit from this improvement without changing their queries. Writing either ANY LEFT JOIN or the equivalent ANY RIGHT JOIN will now yield consistent and equivalent results.

Related resources

PreviousNext