[
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)
