Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:
Hide

Given the documents

{ "status" : "A", "type" : "C" } { "status" : "A", "type" : "D" } { "status" : "B", "type" : "C" } { "status" : "B", "type" : "D" }

Issuing a query like this:

db.collection.find({ "$or": [ { "status": { "$ne": "A" } }, { "type": { "$ne": "C" }}, ] })

Returns all documents, when the expected result would be to exclude the first document.
Show
Given the documents { "status" : "A" , "type" : "C" } { "status" : "A" , "type" : "D" } { "status" : "B" , "type" : "C" } { "status" : "B" , "type" : "D" } Issuing a query like this: db.collection.find({ "$or" : [ { "status" : { "$ne" : "A" } }, { "type" : { "$ne" : "C" }}, ] }) Returns all documents, when the expected result would be to exclude the first document.

There is a different behavior of a given query using inequality matching in combination with $or.

There is some additional information on consideration of $not as a top level operator in SERVER-14201