[SERVER-66814] Call into classic MatchExpression evaluation code from SBE Created: 26/May/22  Updated: 29/Oct/23  Resolved: 08/Jun/22

Status: Closed
Project: Core Server
Component/s: Query Execution
Affects Version/s: None
Fix Version/s: 6.0.0-rc10, 6.1.0-rc0

Type: Task Priority: Major - P3
Reporter: David Storch Assignee: Ian Boros
Resolution: Fixed Votes: 0
Labels: pm2697-m2
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Gantt Dependency
has to be done before SERVER-67061 Remove SBE "applyClassicMatcher" VM i... Closed
Problem/Incident
Related
related to SERVER-67079 Re-enable $elemMatch projection in SBE Backlog
Backwards Compatibility: Fully Compatible
Backport Requested:
v6.0
Sprint: QE 2022-05-30, QE 2022-06-13
Participants:
Linked BF Score: 10

 Description   

Local experiments suggest that this has a positive performance benefit. It would be particularly noticeable for queries involving complex logical expressions, but which also have a $group/$lookup which makes them eligible for SBE pushdown by default.

This change does not interact well with the SBE plan cache's auto-parameterization implementation, and therefore it will only kick in when the plan cache is off. This behavior will need to be removed in order to enable the SBE plan cache. This won't matter for the 6.0 branch, however, since there are no plans to enable the SBE plan cache in 6.0.



 Comments   
Comment by Githook User [ 09/Jun/22 ]

Author:

{'name': 'Ian Boros', 'email': 'ian.boros@mongodb.com', 'username': 'borosaurus'}

Message: SERVER-66814 Use classic MatchExpression for applying filters in SBE

Co-authored-by: Eric Cox <eric.cox@mongodb.com>
(cherry picked from commit b16ad103a503897898fb91c5f9d198407e3e2abf)
Branch: v6.0
https://github.com/mongodb/mongo/commit/9847e9146a43f4b5b2c24cd0b22690ac612b64cc

Comment by Githook User [ 07/Jun/22 ]

Author:

{'name': 'Ian Boros', 'email': 'ian.boros@mongodb.com', 'username': 'borosaurus'}

Message: SERVER-66814 Use classic MatchExpression for applying filters in SBE

Co-authored-by: Eric Cox <eric.cox@mongodb.com>
Branch: master
https://github.com/mongodb/mongo/commit/6385b8fe69e121ab2bf50297fdeab5e4f2729d5a

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