Make sure $lookup, lowered to NLJ in SBE, has proper semantics for empty arrays

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Fixed
    • Priority: Major - P3
    • 6.0.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • QE 2022-04-04, QE 2022-03-07, QE 2022-03-21
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      The current implementation of $lookup via NLJ in SBE doesn't match the semantics in the classic engine (that is, it doesn't match terminal empty arrays to null/missing/undefined). SERVER-63368 tracks whether we'd like to change the classic semantics.

            Assignee:
            Irina Yatsenko (Inactive)
            Reporter:
            Irina Yatsenko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: