[ https://issues.apache.org/jira/browse/HIVE-13350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279333#comment-15279333 ]
Ashutosh Chauhan commented on HIVE-13350: ----------------------------------------- Patch looks good. Is adding constraint with different name allowed (keeping its other properties intact) ? If not can you add -ve test cases for it. i.e., Adding duplicate constraints (with different name) but on same column. Can you also add -ve test cases for adding a constraint on non-existent column of table for both PK/FK and adding a FK constraint on non-existent table? > Support Alter commands for Rely/NoRely novalidate for PK/FK constraints > ------------------------------------------------------------------------ > > Key: HIVE-13350 > URL: https://issues.apache.org/jira/browse/HIVE-13350 > Project: Hive > Issue Type: Sub-task > Components: CBO, Logical Optimizer > Reporter: Hari Sankar Sivarama Subramaniyan > Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-13350.1.patch > > > Support commands like : > ALTER TABLE table2 ADD CONSTRAINT pkt2 primary key (a) disable novalidate; > ALTER TABLE table3 ADD CONSTRAINT fk1 FOREIGN KEY ( x ) REFERENCES table2(a) > DISABLE NOVALIDATE RELY; > ALTER TABLE table6 ADD CONSTRAINT fk4 FOREIGN KEY ( y ) REFERENCES table1(a) > DISABLE NOVALIDATE; -- This message was sent by Atlassian JIRA (v6.3.4#6332)