v.21.11Improvements

Disable Projections with ARRAY JOIN to Prevent Alias Issues

Official CH changelog text
Disable projections when ARRAY JOIN is used. In previous versions projection analysis may break aliases in array join. #29139 (Amos Bird).
Disable projections automatically when ARRAY JOIN is used to prevent alias resolution issues.

Why it matters

Previously, using projections with ARRAY JOIN could break aliases due to projection analysis. This feature disables projections in queries with ARRAY JOIN to ensure correct alias handling and query stability.

How to use it

No user action is required. The ClickHouse engine now automatically disables projections when it detects the use of ARRAY JOIN in a query.

Related resources

PreviousNext