ASF GitHub Bot commented on TRAFODION-2267:

Github user DaveBirdsall commented on a diff in the pull request:

    --- Diff: docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc ---
    @@ -3044,3 +3044,146 @@ statement.
     *Recovery:* Remove the creation of triggers from the CREATE SCHEMA
     statement and resubmit. Create triggers in separate statements.
    +== SQL 1420
    +Column <column-name> cannot be dropped or altered as it is part of the 
table's primary key.
    +*Cause:* You attempted to drop a column that is a part of a primary key.
    +*Effect:* The operation fails.
    +*Recovery:* Correct the column name or table name as appropriate and 
    +== SQL 1421 
    +Column <column-name> cannot be dropped or altered as it is used in the 
secondary index <index-name>.
    +*Cause:* You attempted to drop a column, but that column is used by the 
secondary index named.
    +*Effect:* The operation fails.
    +*Recovery:* If the secondary index is no longer needed, drop it and 
resubmit. If the column
    +name or table name are incorrect, correct them and resubmit.
    +== SQL 1422 
    +An invalid HBase name was specified in this DDL statement. A valid name 
can only contain these characters: [a-zA-Z_0-9-.]
    +*Cause:* You attempted to use a name containing an invalid character for a 
{project-name} object that is
    +stored in HBase.
    --- End diff --

> 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

Reply via email to