Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-5636

Aggregate $project not working after $lookup

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Works as Designed
    • Icon: Minor - P4 Minor - P4
    • No version
    • 1.30.1
    • Aggregation pipeline
    • None
    • Not Needed

    Description

      Problem Statement/Rationale

      On an Aggregate, I have a simple $lookup that pulls an array of object, on the next pipeline I use a $project with a syntax that works perfectly fine with $set or $addField, so I'm not sure what's going on.

      I also launched the aggregate on the shell to see if it comes from Compass, but it also gives me an empty result.

      Steps to Reproduce

      It works perfectly fine on other collections, so I'm not sure I can reproduce it.

      Expected Results

      The same result as I get on $set pipeline

      Actual Results

      Not the same result as I get on $set pipeline

      Additional Notes

      I use MongoDB 5.0.6 Enterprise

      Attachments

        Activity

          People

            Unassigned Unassigned
            shadowbob45@gmail.com Shadoweb EB
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: