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: None
    • Component/s: None
    • None
    • Query Execution
    • ALL

      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:
            Unassigned Unassigned
            Reporter:
            ian.boros@mongodb.com Ian Boros
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: