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] [Updated] (DERBY-3888) ALTER TABLE ... ADD COLUMN cannot add identity columns
Date Mon, 22 Sep 2014 08:26:33 GMT

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

Knut Anders Hatlen updated DERBY-3888:
    Attachment: rrefsqlj81859.html

Attaching [^d3888-2a-refman.diff] which updates the "ALTER TABLE statement" topic of the reference
manual with the new syntax. [^rrefsqlj81859.html] shows what the topic looks like with the

After the code changes in this issue, the {{columnDefinition}} syntax is the same for ALTER
TABLE and CREATE TABLE. This patch therefore removes the description of {{columnDefinition}}
from the "ALTER TABLE statement" topic and points to the definition used by CREATE TABLE instead.

> ALTER TABLE ... ADD COLUMN cannot add identity columns
> ------------------------------------------------------
>                 Key: DERBY-3888
>                 URL: https://issues.apache.org/jira/browse/DERBY-3888
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions:
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>            Priority: Minor
>              Labels: derby_triage10_10
>         Attachments: d3888-1a.diff, d3888-2a-refman.diff, reenable-v2.diff, reenable-v3.diff,
reenable.diff, rrefsqlj81859.html
> ALTER TABLE .. ADD COLUMN cannot be used to add an identity column. There is code to
handle identity columns, but it is disabled in the parser. See this thread on derby-user:
> http://mail-archives.apache.org/mod_mbox/db-derby-user/200708.mbox/%3C46C5DAA9.8080507@sbcglobal.net%3E
> The code was disabled for DB2 compatibility. Since DB2 compatibility is not a goal for
Derby, we should see if we could re-enable it.

This message was sent by Atlassian JIRA

View raw message