v.25.4Improvement
Support converting UInt128 to IPv6
Adding support for convertingUInt128toIPv6. This allows thebitAndoperation and arithmatics forIPv6and conversion back toIPv6. Closes #76752. This allows the result frombitAndoperation onIPv6to be converted back toIPv6, as well. See also #57707. #76928 (Muzammil Abdul Rehman).
Why it matters
This feature allows users to perform bitwisebitAnd and arithmetic operations directly on IPv6 values by converting them to UInt128 and then back to IPv6. It resolves limitations related to manipulating IPv6 addresses in queries, enhancing flexibility and usability for network data processing.How to use it
Users can apply bitwise and arithmetic operations such asbitAnd on IPv6 columns by leveraging the automatic or explicit conversion between IPv6 and UInt128. Conversion back to IPv6 is supported to obtain valid IPv6 results after operations.