[SERVER-78561] Build the SBE plan for $search with ID lookup Created: 29/Jun/23  Updated: 29/Oct/23  Resolved: 11/Sep/23

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

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

Issue Links:
Depends
depends on SERVER-78163 Push down DocumentSourceSearch into SBE Closed
Problem/Incident
Assigned Teams:
Query Execution
Backwards Compatibility: Fully Compatible
Sprint: QE 2023-07-24, QE 2023-08-07, QE 2023-08-21, QE 2023-09-04, QE 2023-09-18
Participants:
Linked BF Score: 162

 Description   

PlanStageSlots: {kResult: output_doc, kMetadataSearchScore: searchScore_metadata}
 
nlj  searchScore_metadata, output_doc, output_id
left
     search_cursor_stage mongot_doc [output_id = “_id”, searchScore_metadata = “searchScore”, ...] firstBatchSlot cursorIdSlot hostAndPortSlot
right
    limit 1
    nlj  output_doc, output_record_id
    left
        ix_scan input_index_key, {"_id": 1}, output_record_id
    right
        scan input_record_id, output_doc 



 Comments   
Comment by Githook User [ 11/Sep/23 ]

Author:

{'name': 'zixuan zhuang', 'email': 'zixuan.zhuang@mongodb.com', 'username': 'leozzx'}

Message: SERVER-78561: Build the SBE plan for $search with ID lookup
Branch: master
https://github.com/mongodb/mongo/commit/97fc4c8cfe7d280fe8eafd9cbe4d2731e17aa1ce

Comment by xgen-buildbaron-user [ 07/Sep/23 ]

Ticket re-opened due to revert. search_pinned_connections_auth began a consistent failure of src/mongo/db/modules/enterprise/jstests/search/search_pushdown.js

Comment by Githook User [ 07/Sep/23 ]

Author:

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

Message: Revert "SERVER-78561: Build the SBE plan for $search with ID lookup"

This reverts commit 3abe11d70783a4629d05f9e4d238aedc1324fc3a.
Branch: master
https://github.com/mongodb/mongo/commit/4eb47a0dd85f12e8a83737ee08dadda34801852e

Comment by Githook User [ 07/Sep/23 ]

Author:

{'name': 'zixuan zhuang', 'email': 'zixuan.zhuang@mongodb.com', 'username': 'leozzx'}

Message: SERVER-78561: Build the SBE plan for $search with ID lookup
Branch: master
https://github.com/mongodb/mongo/commit/3abe11d70783a4629d05f9e4d238aedc1324fc3a

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