v.24.6New Feature

Add Support for Comparing IPv4 and IPv6 Using = Operator

Official CH changelog text
Add support for comparing IPv4 and IPv6 types using the = operator. #64292 (Francisco J. Jurado Moreno).
Add support for comparing IPv4 and IPv6 types using the = operator in ClickHouse.

Why it matters

This feature enables direct equality comparison between IPv4 and IPv6 data types, resolving compatibility issues and simplifying queries that involve IP address comparisons across different IP versions.

How to use it

Users can now use the = operator to compare columns or values of IPv4 and IPv6 types directly in their SQL queries without additional casting or conversion.

Related resources

PreviousNext