Investigate incorrect results for $search followed by $lookup in SBE when all stages are pushed down

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      SERVER-86281 shows a bug where a pipeline with search followed by lookup returns incorrect results after being called a second time. This could be a potential cache related bug. The test jstests/with_mongot_search_mocked_search_and_lookup_with_cache.js repros this bug with featureFlagSbeFull enabled.

      SERVER-86367 temporarily fixed the issue by not pushing down all eligible stages to sbe after search is pushed down.

      After fixing the issue, we should file a ticket to enable all stages being pushed down to SBE when search is present.

              Assignee:
              Zixuan Zhuang
              Reporter:
              Adi Agrawal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: