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

          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Assignee Janice Donahoe [ jmd86 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.08 [ 10204 ]
          i2b2 Related Project/s PCORI [ 10201 ]
          i2b2 Sponsored Project/s i2b2 Core [ 10196 ]
          Status New [ 10000 ] Open [ 1 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          This change was included in version 1.7.08, which was released on 10/07/2016.
          jmd86 Janice Donahoe added a comment - This change was included in version 1.7.08, which was released on 10/07/2016.
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

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

            Dates

              Created:
              Updated:
              Resolved: