[DERBY-3888] ALTER TABLE ... ADD COLUMN cannot add identity columns

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.4.2.0
• Fix Version/s: 10.12.1.1
• Component/s: SQL
• Labels: derby_triage10_10
• Urgency: Normal
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 30/Sep/08 08:01
• Updated: 23/Sep/14 08:24
• Resolved: 23/Sep/14 08:24

Description

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/[e-mail]%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.

Issue Links

• is related to: DERBY-6284 Improve test coverage of org.apache.derby.iapi.db.ConnectionInfo
• is related to: DERBY-6578 Assert failure when retrying failed ADD COLUMN statement
• relates to: DERBY-6414 Incorrect handling when using an UPDATE to SET an identity column to DEFAULT
• relates to: DERBY-6542 Improve the concurrency of identity columns by using SYS.SYSSEQUENCES