v.25.8Improvement

Support resolution of more cases

Official CH changelog text
Support resolution of more cases for compound identifiers. Particularly, it improves the compatibility of ARRAY JOIN with the old analyzer. Introduce a new setting analyzer_compatibility_allow_compound_identifiers_in_unflatten_nested to keep the old behaviour. #85492 (Nikolai Kochetov).
Improves the resolution of compound identifiers in ClickHouse queries, enhancing compatibility of ARRAY JOIN with the old query analyzer.

Why it matters

This feature addresses the problem of limited support for compound identifiers in query parsing, especially in conjunction with ARRAY JOIN. It provides better compatibility with legacy query analyzers, allowing more queries to work without modification.

How to use it

Enable the old behavior by setting the new setting analyzer_compatibility_allow_compound_identifiers_in_unflatten_nested to true. This maintains compatibility with legacy query parsing involving compound identifiers.

Related resources

PreviousNext