v.23.3Improvement

Allow IPv4 in range function to generate IP ranges

Allow IPv4 in the range function to generate IP ranges. #46995 (Yakov Olkhovskiy).
The range function now supports IPv4 addresses, enabling generation of IP address ranges.

Why it matters

This feature extends the capability of the range function to handle IPv4 addresses, allowing users to generate consecutive IP ranges. It simplifies working with IP data and enhances ClickHouse's networking-related querying capabilities.

How to use it

Use the range function with IPv4 address arguments to generate ranges of IP addresses. For example, you can call range('192.168.1.1', '192.168.1.255') to produce all IPs in the specified range.