v.22.3Improvement

Implicit Type Casting for Dict Functions in ClickHouse

Implicit type casting of the key argument for functions dictGetHierarchy, dictIsIn, dictGetChildren, dictGetDescendants. Closes #34970. #35027 (Maksim Kita).
Implicit type casting for the key argument in the dictionary functions dictGetHierarchy, dictIsIn, dictGetChildren, and dictGetDescendants.

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 calling dictGetHierarchy, dictIsIn, dictGetChildren, or dictGetDescendants, ClickHouse will automatically perform implicit type casting of the key argument as needed.