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

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah updated TRAFODION-1256:
--------------------------------------
    Assignee: Anoop Sharma

> 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
>            Assignee: Anoop Sharma
>            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)