You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2016/10/08 02:20:20 UTC
[jira] [Created] (TRAFODION-2267) ALTER TABLE RENAME .. CASCADE
option not supported
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)