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

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 2.0-incubating
• Component/s: sql-cmu
• External issue URL: https://bugs.launchpad.net/bugs/1461134
• Assignee: Anoop Sharma
• Reporter: Cliff Gray
• Created: 22/Jul/15 18:20
• Updated: 15/Sep/18 07:32
• Resolved: 19/May/16 15:34

Description

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.