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

qt_privilege primary key

          Details

          • Type: Bug
          • Status: Closed
          • Priority: Minor
          • Resolution: Fixed
          • Affects Version/s: 1.7.07
          • Fix Version/s: 1.7.08
          • Component/s: Data
          • Labels:
            None
          • Rank:
            0|i002t3:
          • i2b2 Sponsored Project/s:
            i2b2 Core
          • Affects Database/s:
            PostgreSQL
          • Developer Notes:
            This was fixed for both PostgreSQL and SQL Server scripts. The oracle script already had the PROTECTION_LABEL_CD defined as the primary key.
          • Testing Notes:
            Hide
            Verified via Bamboo that the following scripts ran without errors and the primary key was set correctly.

                     crc_create_query_oracle.sql
                     crc_create_query_postgresql.sql
                     crc_create_query_sqlserver.sql


            Show
            Verified via Bamboo that the following scripts ran without errors and the primary key was set correctly.          crc_create_query_oracle.sql          crc_create_query_postgresql.sql          crc_create_query_sqlserver.sql

            Description

            The table qt_privilege in the crc schema doesn’t have primary key. However, in the document, it’s asserted that the ‘PROTECTION_LABEL_CD’ is the primary key. It’s a little error, but it could give some hard times (when the ant command is used too many time, duplicate appears, and error pops up in the webclient). Not a big issue, but worth being noted

              Attachments

                Activity

                  People

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

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Git Source Code