[ https://issues.apache.org/jira/browse/TRAFODION-2267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15572310#comment-15572310 ]
ASF GitHub Bot commented on TRAFODION-2267: ------------------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/760 > 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 > > 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)