• Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 5.3.0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Fully Compatible
    • QE 2022-02-07, QE 2022-01-24

      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>,
          }
      

       

            Assignee:
            anna.wawrzyniak@mongodb.com Anna Wawrzyniak
            Reporter:
            eric.cox@mongodb.com Eric Cox (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: