[SERVER-8135] Unused index-boundaries on multikey Created: 10/Jan/13 Updated: 05/Jun/13 Resolved: 21/Jan/13 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance, Querying |
| Affects Version/s: | 2.2.2 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Ulrik Mikaelsson | Assignee: | Aaron Staple |
| Resolution: | Duplicate | Votes: | 1 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Ubuntu 12.04, 12.10 |
||
| Issue Links: |
|
||||||||
| Operating System: | ALL | ||||||||
| Steps To Reproduce: | Create a collection with documents having a ISODate-column in the root document, and a collection of embedded documents with some criteria in each of the embedded document, and try to perform a query including both a range of dates, and a value for the embedded field. |
||||||||
| Participants: | |||||||||
| Description |
|
Given the index , The query , The explain() is; , |
| Comments |
| Comment by Henrique Nunes [ 05/Jun/13 ] |
|
In case someone ends up here like I do, here's some additional info on how to use the above mentioned $min/$max technique with Pymongo to work around this issue: https://groups.google.com/forum/?fromgroups#!topic/mongodb-user/cw82dRPX2hE |
| Comment by Aaron Staple [ 21/Jan/13 ] |
|
Hi Ulrik - I'm going to resolve this as a duplicate of |
| Comment by Aaron Staple [ 15/Jan/13 ] |
|
Hi Ulrik, There is some background on this issue here: Until { }, or use the min / max functions as described in the the above link. Let us know if you have any questions. |
| Comment by Ulrik Mikaelsson [ 10/Jan/13 ] |
|
Seems to be related to |