-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Labels:None
-
Fully Compatible
-
ALL
-
Query Execution 2021-03-08, Query Execution 2021-03-22
-
167
> db.test.find()
{ "_id" : ..., "a" : [ ] }
{ "_id" : ..., "a" : [ 1, 2, 3 ] }
{ "_id" : ..., "a" : [ {c: 1} ] }
[Classic Engine]
> db.test.find({a: {$not: {$elemMatch: {b: 1}}}}).toArray()
[
{ "_id" : ..., "a" : [ ] },
{ "_id" : ..., "a" : [ 1, 2, 3 ] },
{ "_id" : ..., "a" : [ {c: 1} ] }
]
[SBE]
> db.test.find({a: {$not: {$elemMatch: {b: 1}}}}).toArray()
[ ]