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

concept_dimension.concept_cd is nullable in postgresql implementation

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.7.05
    • Data
    • None
    • i2b2 Core
    • 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.
    • 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

          Ascending order - Click to sort in descending order
          murphyke Kevin Murphy created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Component/s Data [ 10050 ]
          Fix Version/s 1.7.05 [ 10164 ]
          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 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.

          SVN Revision Number REV 5327
          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 Tested via Bamboo on 04/15/2015

          Status: Passed

          Project: i2b2 Server
          Plan: i2b2 Install Linux Oracle 11g
          Build: #831
          Revisions: Data 5327
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe added a comment -
          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).
          jmd86 Janice Donahoe added a comment - 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 ).
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

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

            Dates

              Created:
              Updated:
              Resolved: