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

Support rooted $or queries with partial indexes in SBE plan cache

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

      SERVER-94212 describes how partial index discriminators are effectively broken for root $or queries (using the subplanner) for the SBE plan cache, which can lead to incorrect query results. That ticket disabled such affected queries from using SBE.

      The task in this ticket is to design and implement a mechanism to make the SBE plan cache robust to this problem. One idea is to make the partial index discriminators sunplanner aware, which may involve encoding a discriminator for each branch of the rooted $or instead of just one globally for a partial index.

            Assignee:
            Unassigned Unassigned
            Reporter:
            ben.shteinfeld@mongodb.com Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: