[SERVER-8561] Query with sort ($natural:1) is reported as indexOnly when it should not be Created: 13/Feb/13 Updated: 18/Feb/13 Resolved: 14/Feb/13 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance |
| Affects Version/s: | 2.4.0-rc0 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Sridhar Nanjundeswaran | 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 | ||||||||
| Steps To Reproduce: |
var coll = db.getCollection("covered_negative_1") ) ) ) ) ).sort({$natural:1}).hint( {a:1, b:-1, c:1}).explain() |
||||||||
| Participants: | |||||||||
| Description |
|
Query with sort ($natural:1) should not be a covered query. The test below asserts with |
| Comments |
| Comment by Aaron Staple [ 14/Feb/13 ] |
|
Hi Sridhar - I think the root issue here is that $natural sort is being ignored when a hint that cannot provide natural ordering is specified. I filed SERVER-8564 to address this. |