[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

Rank: 0|i001tj:
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).
Generated at Fri Mar 29 09:23:08 UTC 2024 using Jira 8.20.11#820011-sha1:0629dd8d260e3954ece49053e565d01dabe11609.