v.19.4Improvements

Result of Multiple Joins Need Correct Result Names to Be Used in Subselects

Official CH changelog text
Result of multiple JOINs need correct result names to be used in subselects. Replace flat aliases with source names in result. #4474 (Artem Zuikov)
Fixes the naming of result columns in multiple JOIN operations by replacing flat aliases with the original source names to ensure correct reference in subselects.

Why it matters

When performing multiple JOINs, the result column names were flattened into aliases that could cause misreferences in subsequent subselect queries. This feature resolves that issue by preserving the original source names, improving query correctness and predictability.

How to use it

This improvement is applied automatically in the query execution engine for multiple JOIN scenarios; no special user action is required to enable it.

Related resources

PreviousNext