Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:
Hide

Create the following document inside a random collection:

{"_id":{"$oid":"606717762ce596a43dde9c7b"},"array":[{"value":"MyValue"}]}

Run this query:

{ _id: ObjectId('606717762ce596a43dde9c7b'), "array.0.value": null }

The document will be returned by the database.

The next query works as expected (no match):

{ _id: ObjectId('606717762ce596a43dde9c7b'), "array.0.value": { $type: "null" } }
Show
Create the following document inside a random collection: { "_id" :{ "$oid" : "606717762ce596a43dde9c7b" }, "array" :[{ "value" : "MyValue" }]} Run this query: { _id: ObjectId( '606717762ce596a43dde9c7b' ), "array.0.value" : null } The document will be returned by the database. The next query works as expected (no match): { _id: ObjectId( '606717762ce596a43dde9c7b' ), "array.0.value" : { $type: " null " } }

MongoDB v4.4.4 (Atlas).

The database will match more documents than expected when using a null match against an array's item.

Tested with Compass, Robo3T, Mongo shell, and Node.js driver.

depends on

SERVER-27442 Positional path component in match language should not act as both an array index and a field name for a single document