[ https://issues.apache.org/jira/browse/TRAFODION-1256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anoop Sharma resolved TRAFODION-1256. ------------------------------------- Resolution: Fixed > 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)