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

Aggregate $project not working after $lookup

    • Type: Icon: Bug Bug
    • Resolution: Works as Designed
    • Priority: Icon: Minor - P4 Minor - P4
    • No version
    • Affects Version/s: 1.30.1
    • Component/s: Aggregation pipeline
    • Labels:
      None
    • Not Needed

      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

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

              Created:
              Updated:
              Resolved: