tree 39aa399d1bdb4c6b5fade138c64c2a00e2693fc9
parent 4c4c708cd7f422e49a0c32a15a4649fee72e8a1b
author englefly <zhouminghong@selectdb.com> 1780977462 +0800
committer englefly <zhouminghong@selectdb.com> 1780977462 +0800

[fix](nereids) strip NULL access path when OFFSET path exists for the same field in NestedColumnPruning

stripNullSuffixPaths() already contains the logic to remove [col.NULL] when
[col.OFFSET] covers the same prefix (lines 834-839), but it was only called
in the string-like and general branches, not in the array/map early-continue
branch. This caused queries like `SELECT cardinality(arr), arr IS NULL` to
emit redundant [arr.NULL] alongside [arr.OFFSET] in the access paths.

Fix: move stripNullSuffixPaths() call to line 278 (before all type-specific
early-continue branches) so it applies uniformly to all complex data types.

Add regression tests covering array root, map root, struct string subfield,
struct array subfield, and struct map subfield.