[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: |
|
||||||||
| 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. |