-
Type:
Improvement
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
Fully Compatible
-
200
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Neither of the following operations use an index on total:
db.test.aggregate([ {
$match: {
$expr: {
$let: {
vars: {
total: 100,
},
in: { $gt: [ "$total", "$$total" ] }
}
}
}
}])
db.test.aggregate([ {
$match: {
$expr: {
$let: {
vars: {
unused_var: 'unused_value',
},
in: { $gt: [ "$total", 100 ] }
}
}
}
}])
We should improve this.
- causes
-
SERVER-99240 Investigate $filter with non-array parameters record failures
-
- Closed
-
- is related to
-
SERVER-99243 Investigate $split empty separator record failures
-
- Closed
-
-
SERVER-83524 Enable indexed plans for expressions with $$NOW, $$CLUSTER_TIME, and $$USER_ROLES
-
- Closed
-