[SERVER-57555] Change IX scan stage builder to support bounds not known at query compile time Created: 08/Jun/21  Updated: 06/Dec/22  Resolved: 18/Feb/22

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

Type: Task Priority: Major - P3
Reporter: Ian Boros Assignee: Backlog - Query Execution
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-63572 Index SBEPlan: Translate EqLookup for... Closed
Assigned Teams:
Query Execution
Participants:

 Description   

To support $lookup using an indexed nested loop join, we will need some way to run an index scan using bounds that are not known until runtime. The bounds will be provided as a correlated value from the left side of the join.

This work will involve changing sbe_stage_builder_index_scan to support cases where the bounds are provided via slots, rather than as IndexBounds known at compile time.



 Comments   
Comment by Rushan Chen [ 18/Feb/22 ]

This work is now being done in SERVER-63572 and SERVER-63574.

Generated at Thu Feb 08 05:42:10 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.