[SERVER-30075] Document within the domain of an index is not returned by query Created: 10/Jul/17 Updated: 03/Aug/17 Resolved: 11/Jul/17 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Elyes Gherib | Assignee: | Kelsey Schubert |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
MongoDB Atlas 3-nodes replica set |
||
| Operating System: | ALL |
| Participants: |
| Description |
|
I have a document that should be returned by a query but isn't. Query:
Index (not sparse, not background):
Document:
When I insert a document with a new ID and the same exact field values, it doesn't get returned either. When I insert a document with the same field values but a different value for the date field, the document is returned. I am available for a live demo. |
| Comments |
| Comment by Kelsey Schubert [ 11/Jul/17 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||
|
Hi technical@tootsweet-app.com, The document in question specifies latitude before longitude within the embedded document. Therefore, the document is not being returned by the query. For additional information regarding this restriction, please review our documentation on legacy coordinate pairs. Correcting the order should resolve the issue. For example,
Please note that SERVER project is for reporting bugs or feature suggestions for the MongoDB server. For MongoDB-related support discussion please post on the mongodb-user group or Stack Overflow with the mongodb tag. A question like this would be best posted on the mongodb-users group. Kind regards, | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Elyes Gherib [ 10/Jul/17 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||
|
Sorry for the horrible formatting, here it is: Query:
Index (not sparse, not background):
Document:
|