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

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: 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
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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
              Reporter:
              Ruoxin Xu
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: