[SERVER-14225] Compound Index is not working as expected Created: 11/Jun/14 Updated: 10/Dec/14 Resolved: 14/Jul/14 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 2.6.1 |
| Fix Version/s: | None |
| Type: | Question | Priority: | Major - P3 |
| Reporter: | Andre Mantei | Assignee: | David Storch |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Participants: |
| Description |
|
Hi, I have a collection that contains Dokuments in the following fashion:
The following indexes exists:
When I query the collection with a hint to different indexes, it gives back different results. I would not expect that:
The first query gives back the correct result. Why is this happening ? Bye, Andre |
| Comments |
| Comment by David Storch [ 25/Jun/14 ] | |||||||||||
|
Hi andrempunkt, I haven't heard from you in a while, so I just wanted to ping you again. Is there any chance that you would be able to provide the output from the commands that I pasted above? Also, can you reproduce the issue against both version 2.6.1 and version 2.6.3? Thanks very much for your help, Dave | |||||||||||
| Comment by David Storch [ 11/Jun/14 ] | |||||||||||
|
Hi andrempunkt, In addition to the .explain(true) output that Ramon mentioned, another thing that might help us to diagnose and reproduce the issue is if you paste the output without the projection. So, all together, could you please provide the output of the following four commands?
These results will allow us to both see what query plan is being used, and see the coordinates of the results that are being returned. Thanks, | |||||||||||
| Comment by Ramon Fernandez Marina [ 11/Jun/14 ] | |||||||||||
|
Hi andrempunkt, can you please post the output of your two find() queries above with .explain(true) appended to them? |