[jira] [Created] (TRAFODION-251) LP Bug: 1317301 - Unsupported column-level constraints should return errors instead of being ignored

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-251:
------------------------------------

             Summary: LP Bug: 1317301 - Unsupported column-level constraints should return errors instead of being ignored
                 Key: TRAFODION-251
                 URL: https://issues.apache.org/jira/browse/TRAFODION-251
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Weishiun Tsai
            Assignee: Anoop Sharma
            Priority: Critical


Trafodion does not support column-level constraints right now, but they are ignored as opposed to return an error.  All of the following examples are meant to see one error or another, but they now just return SQL operation complete.  They should return errors indicating that the feature is not supported.

>>create table a12tab1 (int1 int not null not droppable, vch2 varchar(3), primary key (int1) not droppable);

--- SQL operation complete.
>>
>>create table a12tab2 (int1 int not null, vch2 varchar(3)) store by (int1);

--- SQL operation complete.
>>
>>-- SQ sees ERROR 4041 Type <a> cannot be compared with type <b>
>>alter table a12tab1 add c7 interval second check (c7 > '100');

--- SQL operation complete.
>>
>>-- SQ sees error 1044 Constraint could not be created because the
>>-- referenced columns in the referenced table are not part of a
>>-- unique constraint.
>>alter table a12tab1 add c90 pic x(3) references a12tab2 (vch2);

--- SQL operation complete.
>>
>>-- SQ sees error 1044 Constraint could not be created because the
>>-- referenced columns in the referenced table are not part of a
>>-- unique constraint.
>>alter table a12tab1 add c91 int references a12tab2(int1);

--- SQL operation complete.
>>
>>-- SQ sees error 1042 All PRIMARY KEY or UNIQUE constraint columns
>>-- must be NOT NULL
>>alter table a12tab1 add c92 int unique references a12tab2 (int1);

--- SQL operation complete.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)