In SBE Support lookup + unwind with preserveNullAndEmptyArrays

    • Type: New Feature
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • None
    • 3
    • TBD
    • 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:
            4 Start watching this issue

              Created:
              Updated: