Details
-
Bug
-
Resolution: Duplicate
-
Major - P3
-
None
-
3.6.0, 3.6.2
-
None
-
ALL
-
Description
While using $lookup stages in aggregation pipelines using the new "Multiple Join Conditions", which requires $expr commands, the lookup uses COLLSCAN instead of indexes to fetch the destination values.
In fact this seems to be a problem with the "$expr" command and not the $lookup phase itself. (see steps to reproduce)
Attachments
Issue Links
- duplicates
-
SERVER-31760 Lookup sub-pipeline is not using index for equality match
-
- Closed
-