-
Type: Task
-
Resolution: Duplicate
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
db.test.insert({"_id": 1, x:1}) db.test.insert({"_id": 2, x:{y:1}}) db.test.insert({"_id": 3, x:2}) db.test.insert({"_id": 4, x:null}) assert.sameMembers(db.test.aggregate([{$match: {x: {$ne: 1}}}]).toArray(), [ {"_id": 1, x:1}, {"_id": 2, x:{y:1}}, {"_id": 3, x:2}, ])
it returns only
{ "_id" : 3, "x" : 2 }
- duplicates
-
SERVER-68095 [CQF] Add $not to supported expression list
- Closed