[SERVER-82547] Make "queryFramework" an input parameter on queries Created: 29/Oct/23  Updated: 31/Oct/23  Resolved: 30/Oct/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor - P4
Reporter: Johnny Shields Assignee: Adam Harrison
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by SERVER-61915 Provide the ability for queries to "h... Open
Operating System: ALL
Participants:

 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.



 Comments   
Comment by Johnny Shields [ 31/Oct/23 ]

Adam, thank you for the quick response. This is indeed a duplicate.

Comment by Adam Harrison [ 30/Oct/23 ]

Hi Johnny, 

This request looks similar to SERVER-61915 (Provide the ability for queries to 'hint' and use a particular Query Engine'). We're going to close this specific ticket but we recommend following the other ticket for updates on the availability of this feature. 

Generated at Thu Feb 08 06:49:36 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.