[ 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)