v.1.1.54362New Feature

Type Conversion for UNION ALL Now Supports Different Alias Names in SELECT Positions

Official CH changelog text
Added type conversion for UNION ALL. Different alias names are allowed in SELECT positions in UNION ALL, in compliance with the SQL standard.
Added type conversion support for UNION ALL queries, allowing different alias names in SELECT positions while complying with the SQL standard.

Why it matters

This feature resolves issues when using UNION ALL with queries that have differing alias names in their SELECT clauses. It ensures that ClickHouse correctly performs type conversion and merges results according to the SQL standard, improving query compatibility and user experience.

How to use it

Users can simply write UNION ALL queries with different aliases in the SELECT statements as usual. The system now automatically handles the type conversions and alias differences without requiring any additional configuration.
PreviousNext