[SERVER-13769] Distinct command on indexed field with geo predicate fails to execute Created: 28/Apr/14 Updated: 11/Jul/16 Resolved: 01/May/14 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 2.6.0 |
| Fix Version/s: | 2.6.2, 2.7.0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Lee Huffman | Assignee: | J Rassi |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||
| Operating System: | ALL | ||||
| Backport Completed: | |||||
| Participants: | |||||
| Description |
| Comments |
| Comment by Githook User [ 15/May/14 ] | ||||||||||||||||||||||||||||||||||||||||
|
Author: {u'username': u'jrassi', u'name': u'Jason Rassi', u'email': u'rassi@10gen.com'}Message: | ||||||||||||||||||||||||||||||||||||||||
| Comment by Githook User [ 15/May/14 ] | ||||||||||||||||||||||||||||||||||||||||
|
Author: {u'username': u'jrassi', u'name': u'Jason Rassi', u'email': u'rassi@10gen.com'}Message: | ||||||||||||||||||||||||||||||||||||||||
| Comment by Githook User [ 01/May/14 ] | ||||||||||||||||||||||||||||||||||||||||
|
Author: {u'username': u'jrassi', u'name': u'Jason Rassi', u'email': u'rassi@10gen.com'}Message: | ||||||||||||||||||||||||||||||||||||||||
| Comment by Githook User [ 01/May/14 ] | ||||||||||||||||||||||||||||||||||||||||
|
Author: {u'username': u'jrassi', u'name': u'Jason Rassi', u'email': u'rassi@10gen.com'}Message: | ||||||||||||||||||||||||||||||||||||||||
| Comment by J Rassi [ 28/Apr/14 ] | ||||||||||||||||||||||||||||||||||||||||
|
Thanks for the additional info. I am now able to reproduce this as follows:
Please watch this ticket for updates on when a fix will be available. | ||||||||||||||||||||||||||||||||||||||||
| Comment by Lee Huffman [ 28/Apr/14 ] | ||||||||||||||||||||||||||||||||||||||||
|
1)
2) Indexes:
Note, in testing 2.6, if I copy the _id.id to a new "id" field, then run the distinct query with key="id" instead of "_id.id" then the query works in 2.6 | ||||||||||||||||||||||||||||||||||||||||
| Comment by J Rassi [ 28/Apr/14 ] | ||||||||||||||||||||||||||||||||||||||||
|
Hi, Thanks for reporting this problem. I'd like to gather additional information to help further diagnose the issue. 1. You noted that the query that you ran that reproduced the failure was the following:
Could you please provide what you replaced "..." above with when reproducing this failure? 2. Could you please provide the output of running the following at the mongo shell:
Thanks. ~ Jason Rassi |