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 added a comment -
          All other postgreSQL data scripts will be checked to verify the correct dataype is defined for the date columns.
          jmd86 Janice Donahoe added a comment - All other postgreSQL data scripts will be checked to verify the correct dataype is defined for the date columns.
          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 added a comment - - edited
          On 01/22/2016, the 1.7.07 Release was made available at the following locations.

          https://www.i2b2.org/software/
           - zip files for release 1.7.07 are available on this site. This includes both the code and documentation.

          https://github.com/i2b2
           - source code has been tagged with v1.7.07.
          jmd86 Janice Donahoe added a comment - - edited On 01/22/2016, the 1.7.07 Release was made available at the following locations. https://www.i2b2.org/software/  - zip files for release 1.7.07 are available on this site. This includes both the code and documentation. https://github.com/i2b2  - source code has been tagged with v1.7.07.
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          conniez Connie Zabarovskaya added a comment - - edited
          Hello. I've reviewed the data scripts for v 1.7.07 for PostgreSQL, and it seems that no changes were made in crc_create_query_postgresql.sql script (in i2b2createdb-1707.zip). If the change was made on the application level (crc cell src scripts), could you please point us to the script on GitHub where the change was made. We just want to make sure our PostgreSQL database will see the effects of this bug-fix. Thank you!
          conniez Connie Zabarovskaya added a comment - - edited Hello. I've reviewed the data scripts for v 1.7.07 for PostgreSQL, and it seems that no changes were made in crc_create_query_postgresql.sql script (in i2b2createdb-1707.zip). If the change was made on the application level (crc cell src scripts), could you please point us to the script on GitHub where the change was made. We just want to make sure our PostgreSQL database will see the effects of this bug-fix. Thank you!

          People

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

            Dates

              Created:
              Updated:
              Resolved: