[SERVER-25442] OR query does not use middle field of a compound index Created: 04/Aug/16 Updated: 04/Aug/16 Resolved: 04/Aug/16 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance |
| Affects Version/s: | 3.2.8 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Simon Cooper | 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: |
The query plan will have two index scans with the following bounds:
Note the [MinKey, MaxKey] on the bounds for f1. This should be [10, 10], from the condition in the query |
||||||||||||||||
| Participants: | |||||||||||||||||
| Description |
|
When doing an OR query with an equality match, if the equality match is on one of the fields of a compound index, bounds are not applied to that index correctly |
| Comments |
| Comment by Kelsey Schubert [ 04/Aug/16 ] |
|
Hi thecoop1984, Thanks for the report. This issue is tracked in Kind regards, |