v.21.4New Features
Add isIPAddressInRange function for CIDR network prefix testing
Add function isIPAddressInRange to test if an IPv4 or IPv6 address is contained in a given CIDR network prefix. #21329 (PHO).Why it matters
This feature addresses the need to easily verify whether an IP address belongs to a particular network range, facilitating network filtering, access control, and IP classification directly within ClickHouse queries.How to use it
Use the functionisIPAddressInRange(ip_address, cidr_prefix) in your SQL queries, where ip_address is the IPv4 or IPv6 address to test and cidr_prefix is the CIDR notation of the target network prefix.