[
https://issues.apache.org/jira/browse/DERBY-4693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12878458#action_12878458
]
Bryan Pendleton commented on DERBY-4693:
----------------------------------------
Committed to the trunk as revision 954344.
I'll investigate merging this fix back to the 10.6 branch.
> column rename looses 'identity' attribute.
> ------------------------------------------
>
> Key: DERBY-4693
> URL: https://issues.apache.org/jira/browse/DERBY-4693
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.3.1.4, 10.6.1.0
> Environment: ubuntu, java 1.5
> Reporter: Brett Sutton
> Assignee: Bryan Pendleton
> Priority: Minor
> Attachments: patch.diff
>
>
> renaming an identity column causes the column to loose its 'identity'
> attribute.
> you can reproduce the problem as follows:
> CREATE TABLE njr_version ( id INTEGER generated always as identity,
> databaseVersion INTEGER);
> insert into njr_version (databaseVersion) values (10);
> -- column inserted successfully.
> rename column njr_version.id to idVersion;
> insert into njr_version (databaseVersion) values (10);
> Error: Column 'IDVERSION' cannot accept a NULL value.
> To compound this problem there is no way to restore the renamed column's
> identity attribute as the alter command doesn't let you set an identity
> attribute. The only work around is to create a new table and copy the data
> across.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
