v.25.5Improvement
Extend the isIPAddressInRange function
Extend theisIPAddressInRangefunction toString,IPv4,IPv6,Nullable(String),Nullable(IPv4), andNullable(IPv6)data types. #78364 (YjyJeff).
Why it matters
This feature expands the usability of theisIPAddressInRange 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 theisIPAddressInRange 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;