[
https://issues.apache.org/jira/browse/AMBARI-6393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alejandro Fernandez resolved AMBARI-6393.
-----------------------------------------
Resolution: Cannot Reproduce
Cannot reproduce on the latest trunk version. Closing for now.
> Ambari Postgres Create scripts fails to create Constraints, No Failure
> reported
> -------------------------------------------------------------------------------
>
> Key: AMBARI-6393
> URL: https://issues.apache.org/jira/browse/AMBARI-6393
> Project: Ambari
> Issue Type: Bug
> Affects Versions: 1.5.1
> Reporter: Alejandro Fernandez
> Fix For: 1.7.0
>
>
> PROBLEM: Ambari Postgres Create scripts fails to create Constraints, No
> Failure reported.
> ACTUAL BEHAVIOR:
> ALTER TABLE viewparameter ADD CONSTRAINT FK_viewparam_view_name FOREIGN KEY
> (view_name) REFERENCES viewmain(view_name);
> ALTER TABLE viewresource ADD CONSTRAINT FK_viewres_view_name FOREIGN KEY
> (view_name) REFERENCES viewmain(view_name);
> ALTER TABLE viewinstance ADD CONSTRAINT FK_viewinst_view_name FOREIGN KEY
> (view_name) REFERENCES viewmain(view_name);
> ALTER TABLE viewinstanceproperty ADD CONSTRAINT FK_viewinstprop_view_name
> FOREIGN KEY (view_name, view_instance_name) REFERENCES
> viewinstance(view_name, name);
> ALTER TABLE viewinstancedata ADD CONSTRAINT FK_viewinstdata_view_name FOREIGN
> KEY (view_name, view_instance_name) REFERENCES viewinstance(view_name, name);
> EXPECTED BEHAVIOR:
> ALTER TABLE ambari.viewparameter ADD CONSTRAINT FK_viewparam_view_name
> FOREIGN KEY (view_name) REFERENCES ambari.viewmain(view_name);
> ALTER TABLE ambari.viewresource ADD CONSTRAINT FK_viewres_view_name FOREIGN
> KEY (view_name) REFERENCES ambari.viewmain(view_name);
> ALTER TABLE ambari.viewinstance ADD CONSTRAINT FK_viewinst_view_name FOREIGN
> KEY (view_name) REFERENCES ambari.viewmain(view_name);
> ALTER TABLE ambari.viewinstanceproperty ADD CONSTRAINT
> FK_viewinstprop_view_name FOREIGN KEY (view_name, view_instance_name)
> REFERENCES ambari.viewinstance(view_name, name);
> ALTER TABLE ambari.viewinstancedata ADD CONSTRAINT FK_viewinstdata_view_name
> FOREIGN KEY (view_name, view_instance_name) REFERENCES
> ambari.viewinstance(view_name, name);
--
This message was sent by Atlassian JIRA
(v6.2#6252)
