[
https://issues.apache.org/jira/browse/DERBY-3888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14144540#comment-14144540
]
ASF subversion and git services commented on DERBY-3888:
--------------------------------------------------------
Commit 1626963 from [~knutanders] in branch 'docs/trunk'
[ https://svn.apache.org/r1626963 ]
DERBY-3888: ALTER TABLE ... ADD COLUMN cannot add identity columns
Update the syntax description to show that adding identity columns
with ALTER TABLE is allowed.
> 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: 10.4.2.0
> 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/%[email protected]%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
(v6.3.4#6332)
