[SERVER-62597] Add QSN for $lookup Created: 13/Jan/22  Updated: 29/Oct/23  Resolved: 25/Jan/22

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

Type: Task Priority: Major - P3
Reporter: Eric Cox (Inactive) Assignee: Anna Wawrzyniak
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Backwards Compatibility: Fully Compatible
Sprint: QE 2022-02-07, QE 2022-01-24
Participants:

 Description   

This work should add a new QSN called EqLookupNode with the following data,

  • joinFieldLocal - The outer “left” join field.
  • joinFieldForeign - The inner “right” join field.
  • joinField - The “as” field for the output array field.
  • foreignCollection - the foreign collection namespace string
  • Additional fields for indexed NLJ (up to EMEA team).

 

Consider a possible explain format, 

 

LOOKUP: {
      from: <foreignCollection>,
      as: <joinField>,
      localField: <joinFieldLocal>,
      foreignField: <joinFieldForeign>,
    }

 



 Comments   
Comment by Githook User [ 25/Jan/22 ]

Author:

{'name': 'Anna Wawrzyniak', 'email': 'anna.wawrzyniak@mongodb.com', 'username': 'anna-wawrzyniak'}

Message: SERVER-62597 Add EqLookupNode to QuerySolution
Branch: master
https://github.com/mongodb/mongo/commit/3b0acb3b7b42309b0d62a2b7cc329ed7e8e9238a

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