[SERVER-63141] Difference in $lookup/$redact/$let behaviour with pipeline optimization Created: 31/Jan/22  Updated: 29/Oct/23  Resolved: 10/Feb/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: 5.3.0, 4.0.28, 4.2.17, 4.4.12, 5.0.7, 5.2.2
Fix Version/s: 5.3.0, 4.0.29, 5.2.1, 4.4.13, 5.0.7, 4.2.20, 5.2.2

Type: Bug Priority: Major - P3
Reporter: Alya Berciu Assignee: Alya Berciu
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Related
related to SERVER-63030 Correlated sub-pipeline analysis is i... Closed
related to SERVER-63845 Separate interface to get set of refe... Closed
is related to SERVER-66548 $lookup sequential cache can incorrec... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v5.2, v5.0, v4.4, v4.2, v4.0
Participants:
Linked BF Score: 151

 Description   

For the lookup stage described in steps to reproduce (see comment below), different results are obtained based on whether or not pipeline optimization is enabled.



 Comments   
Comment by Githook User [ 16/Mar/22 ]

Author:

{'name': 'Alya Berciu', 'email': 'alyacarina@gmail.com', 'username': 'alyacb'}

Message: SERVER-63141 Ensure stages without dependency tracking are not cached in $lookup
Branch: v4.0
https://github.com/mongodb/mongo/commit/274f2fddd6a0f975a678e8a953e704f7be6dda14

Comment by Githook User [ 01/Mar/22 ]

Author:

{'name': 'Alya Berciu', 'email': 'alyacarina@gmail.com', 'username': 'alyacb'}

Message: SERVER-63141 Ensure stages without dependency tracking are not cached in $lookup
Branch: v4.2
https://github.com/mongodb/mongo/commit/762d02f441876037b799bbcdcb250fe13ee6f2a4

Comment by Githook User [ 15/Feb/22 ]

Author:

{'name': 'Alya Berciu', 'email': 'alyacarina@gmail.com', 'username': 'alyacb'}

Message: SERVER-63141 Ensure stages without dependency tracking are not cached in $lookup
Branch: v4.4
https://github.com/mongodb/mongo/commit/7aee7ea11a58a81629d2d9d64bafb85f4e5b00e7

Comment by Githook User [ 14/Feb/22 ]

Author:

{'name': 'Alya Berciu', 'email': 'alyacarina@gmail.com', 'username': 'alyacb'}

Message: SERVER-63141 Ensure stages without dependency tracking are not cached in $lookup
Branch: v5.0
https://github.com/mongodb/mongo/commit/04bc77ecf6ebf79c345def0709233de36aa35ae8

Comment by Githook User [ 14/Feb/22 ]

Author:

{'name': 'Alya Berciu', 'email': 'alyacarina@gmail.com', 'username': 'alyacb'}

Message: SERVER-63141 Ensure stages without dependency tracking are not cached in $lookup
Branch: v5.2
https://github.com/mongodb/mongo/commit/36d2909d6f8ce9f91ecf2d72ee1561c66918be78

Comment by Alya Berciu [ 10/Feb/22 ]

Closing as the fix has been merged to master.

Comment by Githook User [ 09/Feb/22 ]

Author:

{'name': 'Alya Berciu', 'email': 'alyacarina@gmail.com', 'username': 'alyacb'}

Message: SERVER-63141 Ensure stages without dependency tracking are not cached in $lookup
Branch: master
https://github.com/mongodb/mongo/commit/116a38b637faf897e1a6014abdaadff137cdb496

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