[SERVER-252] $not operator Created: 24/Aug/09 Updated: 12/Jul/16 Resolved: 23/Feb/10 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | None |
| Fix Version/s: | 1.3.3 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Eliot Horowitz (Inactive) | Assignee: | Aaron Staple |
| Resolution: | Done | Votes: | 11 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Participants: | |||||||||
| Comments |
| Comment by auto [ 23/Feb/10 ] |
|
Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}Message: |
| Comment by Eliot Horowitz (Inactive) [ 23/Feb/10 ] |
|
i think this is none are greater than |
| Comment by Aaron Staple [ 23/Feb/10 ] |
|
What are the semantics supposed to be for multikeys? If we have {i:["a","b"]}and my query is {i:{$not:{$gt:"a"}}} is it a match? |
| Comment by Aaron Staple [ 23/Feb/10 ] |
|
I've implemented with all the "simple" btree limit optimizations - eg $not/$lt => $gte. I didn't implement any fancy optimizations, like for $not/$in or $not/$type - theoretically we could create bounds based on the complementary ranges for these query types, but not planning to do it unless necessary. |
| Comment by auto [ 23/Feb/10 ] |
|
Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}Message: |
| Comment by auto [ 23/Feb/10 ] |
|
Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}Message: |
| Comment by auto [ 23/Feb/10 ] |
|
Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}Message: |
| Comment by auto [ 23/Feb/10 ] |
|
Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}Message: |
| Comment by auto [ 23/Feb/10 ] |
|
Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}Message: |
| Comment by Eliot Horowitz (Inactive) [ 22/Feb/10 ] |
|
i think $not can only be applied to another $ operator |
| Comment by Aaron Staple [ 22/Feb/10 ] |
|
Can $not act as a substitute for $ne, or can $not only be applied to another $ operator? |