[SERVER-6293] Index only query fills in missing values with null Created: 03/Jul/12 Updated: 06/Dec/22 Resolved: 24/Jun/19 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Mathias Stearn | Assignee: | Backlog - Query Team (Inactive) |
| Resolution: | Duplicate | Votes: | 1 |
| Labels: | query_triage | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||||||||||||||||||||||||||||||||||
| Issue Links: |
|
||||||||||||||||||||||||||||||||||||
| Assigned Teams: |
Query
|
||||||||||||||||||||||||||||||||||||
| Operating System: | ALL | ||||||||||||||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||||||||||||||
| Description |
|
| Comments |
| Comment by Asya Kamsky [ 27/Dec/16 ] | |||||||||||||||
|
Trivial way to reproduce the same behavior in current version without hint:
| |||||||||||||||
| Comment by Benety Goh [ 16/Dec/13 ] | |||||||||||||||
|
added test script which uses hint to force use of index. This test script passes - no nulls are inserted into the results. redbeard0531, can you pull from master and see if this works for you? | |||||||||||||||
| Comment by Mathias Stearn [ 06/Dec/13 ] | |||||||||||||||
|
This is only fixed because it isn't indexOnly any more:
| |||||||||||||||
| Comment by Benety Goh [ 04/Dec/13 ] | |||||||||||||||
|
redbeard0531, this is no longer happening in 2.5 (you can use the attached test script). Can we resolve this? |