v.21.2Improvements

SELECT count() can now be executed with only one column from the table

Official CH changelog text
SELECT count() FROM table now can be executed if only one any column can be selected from the table. This PR fixes #10639. #18233 (Vitaly Baranov).
SELECT count() queries are now supported on tables when selecting only one any column.

Why it matters

This feature fixes an issue where SELECT count() could not be executed if the query selected only one any column from the table, improving query flexibility and correctness.

How to use it

Users can now write queries like:

SELECT count() FROM table WHERE <conditions>;


when only selecting a single any column from table without errors.

Related resources

PreviousNext