Vineet Garg created HIVE-18853: ---------------------------------- Summary: Alter table change column shouldn't let define same constraint on a column with existing constraint Key: HIVE-18853 URL: https://issues.apache.org/jira/browse/HIVE-18853 Project: Hive Issue Type: Bug Reporter: Vineet Garg Assignee: Vineet Garg Fix For: 3.0.0
{code:sql} create table ttest(i int constraint nn1 not null enable); alter table ttest change i j int constraint nn2 not null enable); {code} The above statements will end up creating multiple not null constraints on column i/j. {code:sql} desc formatted ttest; # Not Null Constraints Table: constraints.ttest Constraint Name: nn1 Column Name: null Constraint Name: nn2 Column Name: j {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)