[SERVER-16783] Indexes not updated when types change but values compare equally Created: 08/Jan/15 Updated: 06/Dec/22 Resolved: 12/Dec/17 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance, Write Ops |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Mathias Stearn | Assignee: | Backlog - Storage Execution Team |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Storage Execution
|
||||||||
| Operating System: | ALL | ||||||||
| Participants: | |||||||||
| Description |
|
The AccessMethod code above the indexes groups values into added, removed, and unchanged based on value comparisons. Since this doesn't consider types, all values where only the type changed are considered "unchanged" and the index is not notified of the change.
|
| Comments |
| Comment by Asya Kamsky [ 01/Sep/16 ] | |||||||||||||||||||||||||
|
This works correctly on 3.3.12:
Fixed as part of In distinct example only one value is returned in middle case (also correctly). Recommend fixing this as fixed or duplicate of fixed. | |||||||||||||||||||||||||
| Comment by Mathias Stearn [ 08/Jan/15 ] | |||||||||||||||||||||||||
|
Actually, this may be unsolvable. Using distinct since we don't do normal covered queries with multikey indexes.
I really don't think we want two entries in the middle case. | |||||||||||||||||||||||||
| Comment by J Rassi [ 08/Jan/15 ] | |||||||||||||||||||||||||
|
Reproduces on 2.2/2.4/2.6/master. |