[CORE-230] SQL Server: Issue with non-clustered index on temp tables Created: 03/Oct/16 Updated: 17/Oct/16 Resolved: 17/Oct/16 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | CRC Cell |
| Affects Version/s: | 1.7.07 |
| Fix Version/s: | 1.7.08 |
| Type: | Bug | Priority: | Major |
| Reporter: | Janice Donahoe | Assignee: | Janice Donahoe |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| i2b2 Sponsored Project/s: |
i2b2 Core
|
| i2b2 Related Project/s: |
PCORI
|
| Affects Database/s: |
SQL Server
|
| Participant/s: |
| Description |
|
SQL Server temp tables included the temporal_start_date column even when the column is not used in the temporal query, which results in a database error.
Resolution: Check for inclusion of the temporal start date before adding to the index. Also add a check for the end date so that can also be included in the index. |
| Comments |
| Comment by Janice Donahoe [ 17/Oct/16 ] |
| This change was included in version 1.7.08, which was released on 10/07/2016. |