Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-174

concept_dimension.concept_cd is nullable in postgresql implementation

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.7.05
    • Component/s: Data
    • Labels:
      None
    • Rank:
      0|i001tj:
    • i2b2 Sponsored Project/s:
      i2b2 Core
    • Developer Notes:
      Hide
      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.

      Show
      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:
      Hide
      Tested via Bamboo on 04/15/2015

      Status: Passed

      Project: i2b2 Server
      Plan: i2b2 Install Linux Oracle 11g
      Build: #831
      Revisions: Data 5327
      Show
      Tested via Bamboo on 04/15/2015 Status: Passed Project: i2b2 Server Plan: i2b2 Install Linux Oracle 11g Build: #831 Revisions: Data 5327

      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.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code