In SBE Support lookup + unwind with preserveNullAndEmptyArrays

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • QE 2025-09-15
    • None
    • 3
    • TBD
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Currently if $lookup has absorbed $unwind with preserveNullAndEmptyArrays it is not SBE-eligible: https://github.com/mongodb/mongo/blob/e00c730185a6649209d9cd7e844ad89b21534e6e/src/mongo/db/pipeline/document_source_lookup.cpp#L959

      We should support it as it is a common-case join.

              Assignee:
              Unassigned
              Reporter:
              Ivan Fefer
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Created:
                Updated: