Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-5391

Foreign key constraint missing from Oracle upgrade DDL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Minor
    • None
    • None
    • None
    • None

    Description

      https://github.com/Internet2/grouper/blob/GROUPER_5_BRANCH/grouper/conf/ddl/GrouperDdl_Grouper_45_upgradeTo_46_oracle.sql is missing this command:

       

      ALTER TABLE grouper_sql_cache_group ADD CONSTRAINT grouper_sql_cache_group1_fk FOREIGN KEY (field_internal_id) REFERENCES grouper_fields(internal_id);

       

      which is present at line 2262 in https://github.com/Internet2/grouper/blob/GROUPER_5_BRANCH/grouper/conf/ddl/GrouperDdl_Grouper_install_oracle.sql

       

      We noticed this when upgrading from 4.8.2 to 5.8.2 and running "./gsh.sh -registry -check -deep" as part of our post upgrade testing and validation.

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            bruce.timberlake@at.internet2.edu Bruce Timberlake
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: