v.22.3Improvement
Implicit Type Casting for Dict Functions in ClickHouse
Implicit type casting of the key argument for functionsdictGetHierarchy,dictIsIn,dictGetChildren,dictGetDescendants. Closes #34970. #35027 (Maksim Kita).
Why it matters
This feature addresses type mismatch issues by automatically casting the key argument to the expected type in dictionary functions. It enhances user experience by reducing errors and simplifying queries when the key type provided does not exactly match the dictionary key type.How to use it
Users do not need to make any explicit changes. When callingdictGetHierarchy, dictIsIn, dictGetChildren, or dictGetDescendants, ClickHouse will automatically perform implicit type casting of the key argument as needed.