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

Wrong datatype defined for some date fields in PostgreSQL create script(s)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7.05
    • Fix Version/s: 1.7.07
    • Component/s: Data
    • Labels:
      None
    • Rank:
      0|i00233:
    • i2b2 Sponsored Project/s:
      i2b2 Core
    • Affects Database/s:
      PostgreSQL
    • Developer Notes:
      Hide
      Fixed the datatype associated to the following tables / columns:

      QUERY_GLOBAL_TEMP Table;
                START_DATE

      MASTER_QUERY_GLOBAL_TEMP Table;
                START_DATE
                TEMPORAL_START_DATE
                TEMPORAL_END_DATE

      The datatype has been updated to TIMESTAMP.
      Show
      Fixed the datatype associated to the following tables / columns: QUERY_GLOBAL_TEMP Table;           START_DATE MASTER_QUERY_GLOBAL_TEMP Table;           START_DATE           TEMPORAL_START_DATE           TEMPORAL_END_DATE The datatype has been updated to TIMESTAMP.
    • Testing Notes:
      Hide
      Bamboo Test

      Plan: i2b2 Install Linux Postgres 9.1
      Build #: 424
      Date Run: 08/04/2015

      Status: Passed
      Show
      Bamboo Test Plan: i2b2 Install Linux Postgres 9.1 Build #: 424 Date Run: 08/04/2015 Status: Passed

      Description

      In the crc_create_query_postgres.sql the wrong datatype is defined for several columns and as a result some date related queries are returning errors.

      Currently the datatype for the following tables / columns are defined as "DATE" and they need to be "TIMESTAMP".

      QUERY_GLOBAL_TEMP Table;
                START_DATE

      MASTER_QUERY_GLOBAL_TEMP Table;
                START_DATE
                TEMPORAL_START_DATE
                TEMPORAL_END_DATE

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code