Details
-
Task
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
Description
Documentation Request Summary:
The release notes list this ticket as a known issue in 3.6.0:
https://docs.mongodb.com/manual/release-notes/3.6/#known-issues-in-3-6-0
We will likely backport this fix, probably targeting 3.6.3. Do we need to do anything in the docs to reflect that the known issue has been resolved?
Engineering Ticket Description:
I am doing following aggregation to join two collection using foreign pipeline.
It seems match stage is not using index at all.
db.blogpost.aggregate([
|
{ $lookup: {
|
from: 'comment',
|
let: { blogpost_id: "$_id" },
|
pipeline: [ {
|
$match: { $expr: { $eq: [ "$blogpost.id", "$$blogpost_id"] } }
|
} ],
|
as: 'comments'
|
}}
|
])
|
Attachments
Issue Links
- documents
-
SERVER-31760 Lookup sub-pipeline is not using index for equality match
-
- Closed
-
- related to
-
DOCS-12191 Document workaround for aggregation issue: Lookup sub-pipeline is not using index for "in" match
-
- Closed
-