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) and ON CLUSTER. Closes #24035. #25907 (alexey-milovidov).
Added support for queries containing a column named "null" when the column name is specified in back-ticks or double quotes, including queries using ON CLUSTER.

Why it matters

This feature solves the issue where queries could not correctly handle columns named null, 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 named null in back-ticks or double quotes in your query, for example:

SELECT </span>null<span class="token punctuation"> FROM table_name

or

SELECT "null" FROM table_name

This works both in regular queries and those executed with ON CLUSTER.