db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-6010) Reference Manual should clarify what ALTER TABLE ADD COLUMN does
Date Fri, 07 Dec 2012 23:05:20 GMT

     [ https://issues.apache.org/jira/browse/DERBY-6010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kim Haase updated DERBY-6010:
-----------------------------

    Attachment: rrefsqlj81859.html
                DERBY-6010.diff

Attaching DERBY-6010.diff and rrefsqlj81859.html, adding a paragraph to the ALTER TABLE topic.
I hope this is sufficient.

M       src/ref/rrefsqlj81859.dita

I should mention that this doc issue results from the same discussion on the derby-user list
that led to the creation of DERBY-6006, although the relationship of this issue to that one
may not be obvious.

Thanks in advance for any comments.
                
> Reference Manual should clarify what ALTER TABLE ADD COLUMN does
> ----------------------------------------------------------------
>
>                 Key: DERBY-6010
>                 URL: https://issues.apache.org/jira/browse/DERBY-6010
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.10.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>            Priority: Minor
>         Attachments: DERBY-6010.diff, rrefsqlj81859.html
>
>
> The documentation should state explicitly that ALTER TABLE ADD COLUMN adds the new column
at the end of the table row. If you need to change a column (for example, to change its data
type), the only way to do so is to drop the column and add a new one, and this changes the
ordering of the columns.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message