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

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.05
    • 1.7.07
    • Data
    • None
    • i2b2 Core
    • PostgreSQL
    • 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.
    • 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

          Ascending order - Click to sort in descending order
          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Fix Version/s 1.7.07 [ 10201 ]
          Assignee Janice Donahoe [ jmd86 ]
          i2b2 Sponsored Project/s i2b2 Core [ 10196 ]
          Status New [ 10000 ] Open [ 1 ]
          jmd86 Janice Donahoe made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          jmd86 Janice Donahoe made changes -
          Developer Notes 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.
          Status In Progress [ 3 ] In Progress [ 3 ]
          jmd86 Janice Donahoe made changes -
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Testing Notes Bamboo Test

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

          Status:
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Testing Notes Bamboo Test

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

          Status:           		Bamboo Test

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

          Status: Passed
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

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

            Dates

              Created:
              Updated:
              Resolved: