db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2042) Provide documentation for new RENAME COLUMN statement
Date Mon, 06 Nov 2006 18:51:38 GMT
    [ http://issues.apache.org/jira/browse/DERBY-2042?page=comments#action_12447499 ] 
Knut Anders Hatlen commented on DERBY-2042:

Hi Bryan,
I had a look at the HTML page. I haven't tested how RENAME COLUMN actually works, nor have
I looked at the code, so please forgive my ignorance. Here are my comments:

1. The documentation says that you can "rename an existing column in an existing table in
any schema", but it doesn't say how you can specify the schema. The syntax only says table-Name.column,
not [schema-Name.]table-Name.column. Or is the current schema always used?

2. It is not quite clear to me what function this statement has: "RENAME COLUMN EMPLOYEE.MANAGER
TO SUPERVISOR". Is it an example of how to use RENAME COLUMN, or is it an example of a statement
that causes the error described in the preceding paragraph?

3. In the paragraph with "Note that you can combine these tools to...", the first sentence
says "you" and the second says "I". I think it would be better to use "you" in both sentences.
I think I also would have dropped "as follows".

4. "to new datatype" should have "data type" in two words, and perhaps "a" or "the" before

5. Is the following statement correct? "If there is an index defined on the column, the column
can be renamed." Should it have been "cannot"?

> Provide documentation for new RENAME COLUMN statement
> -----------------------------------------------------
>                 Key: DERBY-2042
>                 URL: http://issues.apache.org/jira/browse/DERBY-2042
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions:
>            Reporter: Bryan Pendleton
>         Assigned To: Bryan Pendleton
>            Priority: Minor
>         Attachments: renameColumnDoc_v1.diff, rrefsqljrenamecolumnstatement.html
> DERBY-1490 proposes to add a new RENAME COLUMN statement. Assuming that such a statement
is added, we need to update the documentation to describe this new statement. DERBY-1490 describes
the behavior of the statement in detail; this issue is just to track the documentation, which
I intend to address separately after the DERBY-1490 changes are committed.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message