[ https://issues.apache.org/jira/browse/DERBY-6903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16045543#comment-16045543 ]
Bryan Pendleton commented on DERBY-6903: ---------------------------------------- We've completed all our planned work for this item. > ALTER TABLE ALTER COLUMN resets CYCLE option of IDENTITY column > --------------------------------------------------------------- > > Key: DERBY-6903 > URL: https://issues.apache.org/jira/browse/DERBY-6903 > Project: Derby > Issue Type: Sub-task > Components: SQL > Affects Versions: 10.13.1.0 > Reporter: Bryan Pendleton > Assignee: Harshvardhan Gupta > Priority: Minor > Fix For: 10.14.0.0 > > > Using ALTER TABLE with the SET INCREMENT BY or SET RESTART WITH > options to make a change to a GENERATED ... BY IDENTITY column resets the > CYCLE option of that column to "off". > Some test cases demonstrating this behavior were added as part of > the DERBY-6852 change revision 1756287 > The problem occurs when the ALTER TABLE code drops and recreates > the underlying SEQUENCE object, and does not preserve the CYCLE > option of the underlying SEQUENCE object. > I believe the correct behavior would be for the ALTER TABLE code > to read the current CYCLE option of the underlying SEQUENCE object > first, and then create the new SEQUENCE object with the same value > for the CYCLE option. -- This message was sent by Atlassian JIRA (v6.3.15#6346)