[CORE-174] concept_dimension.concept_cd is nullable in postgresql implementation Created: 07/Apr/15 Updated: 12/May/15 Resolved: 16/Apr/15 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | Data |
| Affects Version/s: | None |
| Fix Version/s: | 1.7.05 |
| Type: | Bug | Priority: | Major |
| Reporter: | Kevin Murphy | Assignee: | Janice Donahoe |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| i2b2 Sponsored Project/s: |
i2b2 Core
|
| Developer Notes: | The reported problem is with the oracle script in that it is not allowing CONCEPT_DIMENSION.CONCEPT_CD to be null. The oracle script (crc_create_datamart_oracle.sql) has been updated to allow nulls.
|
| Testing Notes: | Tested via Bamboo on 04/15/2015
Status: Passed Project: i2b2 Server Plan: i2b2 Install Linux Oracle 11g Build: #831 Revisions: Data 5327 |
| Participant/s: |
| Description |
|
I only checked Oracle and PostgreSQL, but the Oracle DDL requires concept_cd to be NOT NULL, while PostgreSQL allows it to be NULL.
I'm looking at the current 1-7 source code that I just downloaded a couple days ago. |
| Comments |
| Comment by Janice Donahoe [ 12/May/15 ] |
| Version 1.7.05 of the i2b2 Software has been released and is available for download on the i2b2 website (http://www.i2b2.org/software). |