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

Prevent SBE use in cases where $lookup pushdown may not use index

    • Type: Icon: Bug Bug
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 8.0.6, 8.1.0-rc1
    • Component/s: None
    • None
    • Query Execution
    • ALL
    • v8.1, v8.0
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      As described in SERVER-81555, there are edge cases when an SBE plan for $lookup may not use an index, while the corresponding classic plan would. This task is to detect when that situation may arise, and avoid using SBE altogether in those cases. This is intended to be a simple, backportable change that works around the issue.

      SERVER-81555 will track a complete, proper fix that allows SBE to use the correct index.

            Assignee:
            foteini.alvanaki@mongodb.com Foteini Alvanaki
            Reporter:
            ian.boros@mongodb.com Ian Boros
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              None
              None
              None
              None