[
https://issues.apache.org/jira/browse/TRAFODION-2267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15569517#comment-15569517
]
ASF GitHub Bot commented on TRAFODION-2267:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/760#discussion_r83070340
--- 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]]
+== 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
resubmit.
+
+[[SQL-1421]]
+== 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]]
+== 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 --
Correct.
> 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)
