Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-86409

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

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

      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@mongodb.com Zixuan Zhuang
            Reporter:
            adi.agrawal@mongodb.com Adi Agrawal
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: