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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.07
    • 1.7.08
    • CRC Cell
    • None
    • Rank:
      0|i0032f:
    • 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

          People

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

            Dates

              Created:
              Updated:
              Resolved: