[jira] [Created] (TRAFODION-1256) LP Bug: 1461134 - ALTER TABLE DROP COLUMN does not check for dependent objects

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

Alice Chen created TRAFODION-1256:
-------------------------------------

             Summary: LP Bug: 1461134 - ALTER TABLE DROP COLUMN does not check for dependent objects
                 Key: TRAFODION-1256
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1256
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmu
            Reporter: Cliff Gray
            Priority: Critical
             Fix For: 2.0-incubating


Before dropping a column, a check should be made for objects that depend on the column.  

Example:

CREATE TABLE T1 (A INT NOT NULL PRIMARY KEY, B INT);
CREATE VIEW V1 AS SELECT B FROM T1;
ALTER TABLE T1 DROP COLUMN B;  -- should fail

At a minimum RESTRICT behavior should be supported.  Ideally, CASCADE would be supported as well.



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