Alejandro Fernandez created AMBARI-6393:
-------------------------------------------
Summary: 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)
