Loading...

XML

Word

Printable

JSON

Assigned Teams:

Server Triage
Operating System:
ALL
Steps To Reproduce:
Hide

Sample Data:

db.getCollection('foo').insertOne({ "docArray" : [ {"code" : 10}, {"code" : 20}], });

Query: constantly false condition, a number can't be less than and greater than itself.

db.getCollection('foo').find({ "docArray.code" : { "$gt" : 13, "$lt":13 } });

Expected Result:

No Result

Actual Result :

Returns the inserted document

Fixed Query: a sample query that looks like has the expected behavior.

db.getCollection('foo').find({ "docArray" : { "$elemMatch" : {"code" : { "$gt" : 13, "$lt":13 }} } });
Show
Sample Data: db.getCollection( 'foo' ).insertOne({ "docArray" : [ { "code" : 10}, { "code" : 20}], }); Query: constantly false condition , a number can't be less than and greater than itself. db.getCollection( 'foo' ).find({ "docArray.code" : { "$gt" : 13, "$lt" :13 } }); Expected Result: No Result Actual Result : Returns the inserted document Fixed Query: a sample query that looks like has the expected behavior. db.getCollection( 'foo' ).find({ "docArray" : { "$elemMatch" : { "code" : { "$gt" : 13, "$lt" :13 }} } });

Querying on an array of nested documents will split each search condition and apply them separately to the documents in the array.