v.18.14Improvement

Qualified Asterisks Functionality in JOIN Queries

Official CH changelog text
Qualified asterisks work correctly in queries with JOIN. Winter Zhang
Qualified asterisks now work correctly in queries that use JOIN, allowing accurate selection of columns with the syntax like table.*.

Why it matters

Previously, using qualified asterisks (e.g., table.*) in queries involving JOIN could lead to incorrect column selection or errors. This feature ensures that when users specify qualified asterisks in joined queries, the columns are resolved properly, improving query accuracy and usability.

How to use it

Users can simply write queries with JOIN using qualified asterisks syntax like table.* to select all columns from a specific table without any additional configuration required.

Related resources

PreviousNext