[
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
d3888-2a-refman.diff
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 changes.
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: 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)
