v.21.8Improvement
Support for Queries with Column Named null and ON CLUSTER
Support for queries with a column named"null"(it must be specified in back-ticks or double quotes) andON CLUSTER. Closes #24035. #25907 (alexey-milovidov).
Why it matters
This feature solves the issue where queries could not correctly handle columns namednull, which is a reserved keyword in SQL. Allowing such columns to be referenced properly enables users to work with tables that include a column named null without syntax errors, improving compatibility and flexibility.How to use it
To use this feature, wrap the column namednull in back-ticks or double quotes in your query, for example:SELECT </span>null<span class="token punctuation"> FROM table_nameor
SELECT "null" FROM table_nameThis works both in regular queries and those executed with
ON CLUSTER.