Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-230

SQL Server: Issue with non-clustered index on temp tables

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.07
    • 1.7.08
    • CRC Cell
    • None
    • i2b2 Core
    • PCORI
    • SQL Server

    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.

      Attachments

        Activity

          No work has yet been logged on this issue.

          People

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: