[SBE] Produce EOF plan for pushed down $lookup when outer collection does not exist

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Major - P3
    • 8.1.0-rc0, 8.0.5
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • Fully Compatible
    • v8.0
    • 200
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      At the time of writing, we can get an elaborate plan for $lookup in SBE when the outer collection does not exist (but the inner one does). This ticket tracks the work to instead, produce EOF plans. 

      Note that if we do this, we should ensure that we don't wind up create a plan cache entry for the EOF plan (in case the outer collection does get created)

            Assignee:
            Milena Ivanova
            Reporter:
            Mihai Andrei
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: