Block TS queries that use bounded sort from lowering to SBE

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Fixed
    • Priority: Major - P3
    • 7.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Integration
    • Fully Compatible
    • QI 2023-10-02, QI 2023-10-16
    • 5
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      See PM-2096 for bounded sort optimizations. The rewrite is done on plan stages after creating the executor (in buildInnerQueryExecutorGeneric). We need to block the queries that use this optimization from being lowered to SBE. This might be tricky due to where in the stack the optimization is happening.

      In SERVER-77965 we block any pipeline that contains $sort and $_internalUnpackBucket from executing in SBE. This is too strict and we need to relax the condition to affect only those pipelines that actually have a chance of using bounded sort optimization.

            Assignee:
            Irina Yatsenko (Inactive)
            Reporter:
            Irina Yatsenko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: