[TRAFODION-2267] ALTER TABLE RENAME .. CASCADE option not supported

• Type: Documentation
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.0-incubating
• Fix Version/s: 2.1-incubating
• Component/s: documentation
• Assignee: Dave Birdsall
• Reporter: Atanu Mishra
• Created: 08/Oct/16 02:20
• Updated: 26/Mar/18 17:47
• Resolved: 13/Oct/16 16:29

Description

Alter table rename ... cascade' is listed in the SQL Reference Manual version 2.0.0 on http://trafodion.incubator.apache.org/ [^] as a supported statement. It has the following to say about the cascade option:

cascade:

specifies that indexes and constraints on the renamed object will be renamed.

However, the cascade option is no longer supported. It now returns a 1427 error like the following:

>>alter table t1 rename to t2 cascade;

• • • ERROR[1427] Table cannot be renamed. Reason: Cascade option not supported.

— SQL operation failed with errors.

Issue Links

• links to: GitHub Pull Request #760