[SERVER-670] indexing arrays breaks some queries Created: 24/Feb/10 Updated: 12/Jul/16 Resolved: 02/Mar/10 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 1.2.3 |
| Fix Version/s: | 1.3.4 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Ian White | Assignee: | Aaron Staple |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Participants: |
| Description |
|
Tried this on 1.2.3: > db.test.drop(); ); ); } ); { "_id" : ObjectId("4b8536ef71f969641118df0b"), "list" : [ 1, 2 ] }> db.test.ensureIndex( { list: 1 } ); } ); { "_id" : ObjectId("4b8536ef71f969641118df0b"), "list" : [ 1, 2 ] } { "_id" : ObjectId("4b8536f371f969641118df0c"), "list" : [ 1, 3 ] } |
| Comments |
| Comment by Eliot Horowitz (Inactive) [ 02/Mar/10 ] |
|
No - don't want to backport. |
| Comment by auto [ 02/Mar/10 ] |
|
Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}Message: |
| Comment by Aaron Staple [ 02/Mar/10 ] |
|
The possibility of an array entry means we cannot do a simple key match with a negating operator. We must test against the whole object. Let me know if I should backport. |