[ https://issues.apache.org/jira/browse/TRAFODION-2267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall resolved TRAFODION-2267. --------------------------------------------- Resolution: Fixed Fix Version/s: 2.1-incubating > ALTER TABLE RENAME .. CASCADE option not supported > -------------------------------------------------- > > Key: TRAFODION-2267 > URL: https://issues.apache.org/jira/browse/TRAFODION-2267 > Project: Apache Trafodion > Issue Type: Documentation > Components: documentation > Affects Versions: 2.0-incubating > Reporter: Atanu Mishra > Assignee: David Wayne Birdsall > Priority: Minor > Fix For: 2.1-incubating > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)