[CORE-182] Wrong datatype defined for some date fields in PostgreSQL create script(s) - i2b2 JIRA

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

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

Ascending order - Click to sort in descending order

Janice Donahoe added a comment - 04/Aug/15 8:40 AM

All other postgreSQL data scripts will be checked to verify the correct dataype is defined for the date columns.

Janice Donahoe added a comment - 04/Aug/15 8:40 AM All other postgreSQL data scripts will be checked to verify the correct dataype is defined for the date columns.

Janice Donahoe added a comment - 25/Jan/16 11:19 AM - 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.

Janice Donahoe added a comment - 25/Jan/16 11:19 AM - 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.

Connie Zabarovskaya added a comment - 13/May/16 10:34 AM - 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!

Connie Zabarovskaya added a comment - 13/May/16 10:34 AM - 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

Assignee:: Janice Donahoe

Reporter:: Janice Donahoe

Participant/s:: Connie Zabarovskaya, Janice Donahoe

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 04/Aug/15 8:37 AM

Updated:: 24/May/16 10:53 AM

Resolved:: 07/Dec/15 1:19 PM

i2b2 Core Software