v.22.3Backward Incompatible Changes
Enhance IP Address Casting Functions and Error Handling in ClickHouse
Make functioncast(value, 'IPv4'),cast(value, 'IPv6')behave same astoIPv4,toIPv6functions. Changed behavior of incorrect IP address passed into functionstoIPv4,toIPv6, now if invalid IP address passes into this functions exception will be raised, before this function return default value. Added functionsIPv4StringToNumOrDefault,IPv4StringToNumOrNull,IPv6StringToNumOrDefault,IPv6StringOrNulltoIPv4OrDefault,toIPv4OrNull,toIPv6OrDefault,toIPv6OrNull. FunctionsIPv4StringToNumOrDefault,toIPv4OrDefault,toIPv6OrDefaultshould be used if previous logic relied onIPv4StringToNum,toIPv4,toIPv6returning default value for invalid address. Added settingcast_ipv4_ipv6_default_on_conversion_error, if this setting enabled, then IP address conversion functions will behave as before. Closes #22825. Closes #5799. Closes #35156. #35240 (Maksim Kita).