[SERVER-3596] type bracketing used for $not query indexing, but not matching Created: 15/Aug/11  Updated: 07/Mar/14  Resolved: 28/Nov/12

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Aaron Staple Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-7261 field range with $not should properly... Closed
Related
related to SERVER-7388 Implement all query operators using M... Closed
is related to SERVER-1937 $gt/$lt/$ne with scalar operand yield... Closed
Operating System: ALL
Participants:

 Description   

> 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


Generated at Thu Feb 08 03:03:29 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.