Loading...

XML

Word

Printable

JSON

> c.find( {a:{$not:{$gt:19}}} ).hint( {$natural:1} )

{ "_id" : ObjectId("4e48cb782bd12c45a5d7f15b"), "a" : 4 } { "_id" : ObjectId("4e48cb7c2bd12c45a5d7f15c") }

> c.find( {a:{$not:{$gt:19}}} ).hint(

{a:1}

)

{ "_id" : ObjectId("4e48cb782bd12c45a5d7f15b"), "a" : 4 }

Just a note, I think defining the behavior of $not is part of ~~SERVER-1937~~

duplicates

SERVER-7261 field range with $not should properly account for type bracketing (query with $not returns different results after adding an index)

is related to

SERVER-1937 $gt/$lt/$ne with scalar operand yields inconsistent matches on arrays

related to

SERVER-7388 Implement all query operators using MatchExpression