v.22.6Improvement
Functions dictGetHierarchy, dictIsIn, dictGetChildren, and dictGetDescendants Add Nullable HIERARCHICAL Support
FunctionsdictGetHierarchy,dictIsIn,dictGetChildren,dictGetDescendantsadded support nullableHIERARCHICALattribute in dictionaries. Closes #35521. #37805 (Maksim Kita).
Why it matters
This feature addresses the limitation of these dictionary functions not handling nullable hierarchical attributes. It improves flexibility when working with hierarchical data structures that may contain null values, allowing more accurate and robust queries on dictionaries.How to use it
Users can utilize these functions as usual with dictionaries that have nullableHIERARCHICAL attributes without needing additional configuration. Just ensure the dictionary attribute is defined as nullable hierarchical to benefit from the updated support.