Loading...

XML

Word

Printable

JSON

Assigned Teams:

Query Execution
Operating System:
ALL
Steps To Reproduce:
Hide

Insert any one document in a collection. Run aggregation:

db.test.aggregate([{$lookup: {as: "out", from: "test", pipeline: [{$project: {_id: 0, now: "$$NOW"}}]}}, {$addFields: {now: "$$NOW"}}])

Observe the result:

[ { _id: ObjectId('69259026e301e10a0d726631'), a: 1, out: [ { now: ISODate('2025-11-25T11:18:31.095Z') } ], now: ISODate('2025-11-25T11:18:31.094Z') } ]
Show
Insert any one document in a collection. Run aggregation: db.test.aggregate([{$lookup: {as: "out" , from: "test" , pipeline: [{$project: {_id: 0, now: "$$NOW" }}]}}, {$addFields: {now: "$$NOW" }}]) Observe the result: [ { _id: ObjectId( '69259026e301e10a0d726631' ), a: 1, out: [ { now: ISODate( '2025-11-25T11:18:31.095Z' ) } ], now: ISODate( '2025-11-25T11:18:31.094Z' ) } ]
CAR Domain/s:
None

In an aggregation pipeline, if $$NOW is referenced after a sub-pipeline stage, it can have a different value inside and outside of a sub-pipeline.

is related to

SERVER-114196 $$NOW unavailable after $unionWith in aggregation pipeline

SERVER-107976 Split ExpressionContext class to simplify OperationContext propagation