-
Type:
Bug
-
Resolution: Done
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: Aggregation Framework
-
None
-
Environment:MongoDB server version: 3.6.0-rc1
-
Fully Compatible
-
ALL
-
v3.6
-
Query 2017-11-13, Query 2017-12-04, Query 2017-12-18, Query 2018-01-01, Query 2018-01-15
-
0
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'
}}
])
- is duplicated by
-
-
- Closed
-
-
-
- Closed
-
- is related to
-
SERVER-32549 allow $expr with $in expression use a non-multikey index
-
- Open
-
- related to
-
-
- Closed
-