v.22.6Improvement

Functions dictGetHierarchy, dictIsIn, dictGetChildren, and dictGetDescendants Add Nullable HIERARCHICAL Support

Functions dictGetHierarchy, dictIsIn, dictGetChildren, dictGetDescendants added support nullable HIERARCHICAL attribute in dictionaries. Closes #35521. #37805 (Maksim Kita).
Functions dictGetHierarchy, dictIsIn, dictGetChildren, and dictGetDescendants now support nullable HIERARCHICAL attributes in dictionaries.

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 nullable HIERARCHICAL attributes without needing additional configuration. Just ensure the dictionary attribute is defined as nullable hierarchical to benefit from the updated support.