Adopted Ipv6 Data Type in System Tables; Unified Client Info Columns in System.processes and System.query_log #5640 (alexey-milovidov)

Why it matters

This feature enables ClickHouse to natively support IPv6 addresses within its system tables, improving network address handling and consistency. Additionally, unifying the client info columns across key system tables provides a standardized way to inspect client-related query and process information, enhancing usability and data coherence for monitoring and diagnostics.

How to use it

Users can start using the IPv6 data type by querying the updated system tables such as system.processes and system.query_log, where client information columns now consistently represent IPv6 addresses where applicable. No special configuration is needed as these changes are applied directly at the system table schema level.