[SERVER-78246] Add $project and $addFields to the set of stages handled by findSbeCompatibleStagesForPushdown Created: 20/Jun/23  Updated: 29/Oct/23  Resolved: 20/Jul/23

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

Type: New Feature Priority: Major - P3
Reporter: Justin Seyster Assignee: Kevin Cherkauer
Resolution: Fixed Votes: 0
Labels: auto-reverted
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-78596 SBE $project aggregation $sqrt: {NaN}... Closed
Problem/Incident
Assigned Teams:
Query Execution
Backwards Compatibility: Fully Compatible
Participants:
Linked BF Score: 158

 Description   

Pushdown should initially be gated by featureFlagSbeFull.



 Comments   
Comment by Githook User [ 20/Jul/23 ]

Author:

{'name': 'Kevin Cherkauer', 'email': 'kevin.cherkauer@mongodb.com', 'username': 'kevin-cherkauer'}

Message: SERVER-78246 Push down $project and $addFields from agg pipeline to SBE
Branch: master
https://github.com/mongodb/mongo/commit/221a29fc45c5e3b8cd153d63d65605de033a2ce1

Comment by Kevin Cherkauer [ 20/Jul/23 ]

The new test query_limits_test.js that failed and caused autorevert of the first version of this PR has itself been reverted again 2023-07-20 in master by this commit, so the test file no longer exists. Thus the coming re-delivery of the current ticket is identical to the original delivery on 2023-07-18.

When query_test_limit.js comes back, note that the changes needed to fix it for the current ticket were in this PR commit which was reversed by the following PR commit of the second PR.

Comment by xgen-buildbaron-user [ 19/Jul/23 ]

Ticket re-opened due to revert. query_stats_passthrough_writeonly began a consistent failure of jstests/aggregation/query_limits_test.js

Comment by Githook User [ 19/Jul/23 ]

Author:

{'name': 'auto-revert-processor', 'email': 'dev-prod-dag@mongodb.com', 'username': ''}

Message: Revert "SERVER-78246 Push down $project and $addFields from agg pipeline to SBE"

This reverts commit 427cfff2dad3a96fb004535b3f7625d1e8b37684.
Branch: master
https://github.com/mongodb/mongo/commit/383615f022fbc3cf09f525326c31e042b11dde28

Comment by Githook User [ 18/Jul/23 ]

Author:

{'name': 'Kevin Cherkauer', 'email': 'kevin.cherkauer@mongodb.com', 'username': 'kevin-cherkauer'}

Message: SERVER-78246 Push down $project and $addFields from agg pipeline to SBE
Branch: master
https://github.com/mongodb/mongo/commit/427cfff2dad3a96fb004535b3f7625d1e8b37684

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