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.