[SPARK-22065] Add DDL support to modify constraint state for a given constraint

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Sunitha Kambhampati
• Created: 19/Sep/17 19:39
• Updated: 29/Mar/20 02:36

Description

Add DDL support to modify constraint state for a given constraint

constraint_state:
:[ NOVALIDATE | VALIDATE ] [ RELY | NORELY]

ALTER TABLE table_name MODIFY CONSTRAINT constraint_name constraint_state

The high level details are in the spec attached in SPARK-19842 in Section 4.2.3 and Section 4.5