[ 
https://issues.apache.org/jira/browse/TRAFODION-2267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15569518#comment-15569518
 ] 

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_r83070370
  
    --- 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.
    +
    +*Effect:* The operation fails.
    +
    +*Recovery:* Correct the name and resubmit.
    +
    +<<<
    +[[SQL-1423]]
    +== SQL 1423
    +
    +```
    +Insert into metadata table <table-name> failed.
    +```
    +
    +*Cause:* During an INITIALIZE TRAFODION, UPGRADE operation, a write to 
metadata table <table-name> failed. There may 
    +be additional messages giving details of the failure.
    +
    +*Effect:* The upgrade operation fails.
    +
    +*Recovery:* None. Contact the {project-name} User Distribution List. 
Include any additional messages.
    +
    +[[SQL-1424]]
    +== SQL 1424 
    +
    +```
    +Column <column-name> cannot be dropped as that would leave the table with 
no user defined columns.
    +```
    +
    +*Cause:* You attempted to drop the only remaining user-defined column in 
the table.
    +
    +*Effect:* The operation fails.
    +
    +*Recovery:* If the table is no longer needed, simply drop the table.
    +
    +[[SQL-1425]]
    +== SQL 1425 
    +
    +```
    +This operation could not be performed on <table-name>. <reason>
    +```
    +
    +*Cause:* You attempted an operation on table <table-name> but the 
operation could not
    +be performed. <reason> gives more details.
    +
    +*Effect:* The operation fails.
    +
    +*Recovery:* Correct any issues indicated by <reason> as appropriate and 
resubmit.
    +
    +<<<
    +[[SQL-1426]]
    +== SQL 1426
    +
    +```
    +An invalid HBase column name <column-name> was specified. A valid name 
must be of the format:   <ColumnFamily>:<ColumnName>
    +```
    +
    +*Cause:* When accessing an external HBase table (for example, using _ROW_ 
format), you specified
    +an invalid HBase column name.
    +
    +*Effect:* The operation fails.
    +
    +*Recovery:* Correct the column name and resubmit.
    +
    +[[SQL-1427]]
    +== SQL 1427 
    +
    +```
    +Table cannot be renamed. <reason>
    +```
    +
    +*Cause:* You attempted to perform ALTER TABLE RENAME but the rename could 
not be performed.
    +The <reason> explains why.
    +
    +*Effect:* The operation fails.
    +
    +*Recovery:* Perform the operations suggested by <reason> and resubmit.
    +
    +[[SQL-1428]]
    +== SQL 1428 
    +
    +```
    +Metadata definitions could not be created and preloaded in global 
MDdescInfo struct. Make sure that metadata table definition syntax is correct.
    +```
    +
    +*Cause:* This is a {project-name} internal error. It is highly unlikely 
that you will 
    +encounter this error unless you are making code changes to {project-name} 
yourself.
    +
    +*Effect:* The operation fails.
    +
    +*Recovery:* None. Contact the {project-name} Developer Distribution List.
    +
    +<<<
    +[[SQL-1429]]
    +== SQL 1429
    +
    +```
    +Inserts into _ROW_ format external hbase tables can only use the VALUES 
clause and must use the column_create function to create values.
    +```
    --- End diff --
    
    Oops... I'll fix this.


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

Reply via email to