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

Make "queryFramework" an input parameter on queries

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor - P4 Minor - P4
    • None
    • None
    • None
    • None
    • ALL

    Description

      When upgrading to MongoDB 7.0, we faced several severe issues with Slot-Based Query Engine (SBE), and we had no way to opt-out of using the SBE. Refer to Support CaseĀ https://support.mongodb.com/case/01207868.

      It would have been very nice if we could have opted-in to the SBE after upgrading to 7.0 on a per-query basis, i.e. by setting a "queryFramework" parameter on the query ("classic", "sbe", or "auto"). If this feature existed, it would be nice that if a given query is not possible to execute on the "sbe" it falls back to using "classic" without an error (hence this is more of a "queryFrameworkPreference" than a hard requirement.)

      We think this could be very valuable for helping customers on MongoDB 4/5/6 upgrade to 7. As we understand that SBE will be rolled out to more use cases in the future, it would still be nice to have this in MongoDB 8.0 and beyond.

      Attachments

        Activity

          People

            adam.harrison@mongodb.com Adam Harrison
            shields@tablecheck.com Johnny Shields
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: