v.25.5Improvement

Extend the isIPAddressInRange function

Extend the isIPAddressInRange function to String, IPv4, IPv6, Nullable(String), Nullable(IPv4), and Nullable(IPv6) data types. #78364 (YjyJeff).
Extend the isIPAddressInRange function to support additional data types including String, IPv4, IPv6, and their Nullable variants.

Why it matters

This feature expands the usability of the isIPAddressInRange function by allowing it to work seamlessly with multiple IP-related data types, including nullable versions. It solves the limitation of the function being previously restricted to fewer data types, enabling users to perform IP range checks more flexibly and effectively.

How to use it

Use the isIPAddressInRange function as usual in SQL queries, now passing columns or values of types String, IPv4, IPv6, or their Nullable variants. For example:

SELECT isIPAddressInRange(ip_column, '192.168.0.0/16') FROM table;