[
https://issues.apache.org/jira/browse/DERBY-4693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bryan Pendleton resolved DERBY-4693.
------------------------------------
Fix Version/s: 10.6.1.1
10.7.0.0
Resolution: Fixed
Merged the fix to the 10.6 branch as revision 954684, and marked as resolved.
> 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
> Fix For: 10.6.1.1, 10.7.0.0
>
> 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.
