Fix interaction between CollectionIndexUsageTracker/CurOp DebugInfo and the new QSN plans produced by join re-ordering

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major - P3
    • 8.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • Fully Compatible
    • ALL
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Our existing code to track collscan/ixscan usage (CollectionIndexUsageTracker and CurOp DebugInfo) assumes that any access path (STAGE_IXSCAN, STAGE_COLLSCAN, etc) present in the QuerySolution tree is applied to the main collection of a query. With the plans produced by join re-ordering, this is no longer true. 
       
      This bad assumption can result in query failures and incorrect stats tracking. 

            Assignee:
            Hana Pearlman
            Reporter:
            Hana Pearlman
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: