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

Use an accurate 'isCount' flag to encode a CanonicalQuery for SBE plan cache

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.3.0-rc0, 7.0.5
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • ALL
    • v7.1, v7.0
    • QO 2023-09-04, QE 2023-10-02, QE 2023-10-16, QE 2023-10-30, QE 2023-11-13
    • 3

      Currently the SBE plan cache key encoding uses isCountLike which is inaccurate. Queries with _isCountLike being true don't necessary use COUNT_SCAN plan. This could cause a IXSCAN plan and a COUNT_SCAN plan share a same SBE plan cache key.

            Assignee:
            matt.boros@mongodb.com Matt Boros
            Reporter:
            ruoxin.xu@mongodb.com Ruoxin Xu
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: