Atanu Mishra created TRAFODION-2267:
---------------------------------------
Summary: 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)
