v.23.7Improvement

Added Nullable Arguments Support for range Function

Added support for function range of Nullable arguments. #51767 (Dmitry Kardymon).
Added support for the range function to accept Nullable arguments.

Why it matters

This feature allows users to call the range function with Nullable arguments, improving its flexibility and compatibility with datasets that contain NULL values. It resolves issues where previously the function could not handle Nullable inputs, thus expanding the range of use cases for range in data processing and analysis within ClickHouse.

How to use it

Users can now pass Nullable typed arguments into the range function directly without needing to cast or filter out NULL values beforehand. Simply use range as usual with Nullable columns or expressions.