[jira] [Created] (HIVE-18853) Alter table change column shouldn't let define same constraint on a column with existing constraint

["Vineet Garg (JIRA)" <ji...@apache.org>]

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)