[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: |
|
||||||||||||||||||||
| 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 |