[DERBY-6904] Enhance ALTER TABLE to allow CYCLE option to be changed.

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.13.1.0
• Fix Version/s: 10.14.1.0
• Component/s: SQL
• Assignee: Harshvardhan Gupta
• Reporter: Bryan Pendleton
• Created: 14/Aug/16 00:06
• Updated: 30/Sep/17 18:06
• Resolved: 30/Sep/17 18:06

Description

It would be nice to have a variant of the ALTER TABLE statement,
similar to the SET INCREMENT BY or SET RESTART WITH variants,
that allowed a user to change the CYCLE option on an IDENTITY column.

I think that the code flow for this could be closely modelled on the
code flow for the SET INCREMENT BY variant: after the statement
is parsed, we simply need to drop and recreate the underlying SEQUENCE
object with the desired CYCLE option (and preserving all the other
aspects of the underlying SEQUENCE object.

Issue Links

• is blocked by: DERBY-6961 SET CYCLE fails to let an identity column cycle if the range is already exhausted
• is blocked by: DERBY-6962 Forbid ALTER TABLE ... SET CYCLE on identity columns in pre-10.11 databases
• is related to: DERBY-6959 Require the Standard SET keyword in the syntax for changing the cycle behavior of identity columns

Sub-Tasks

• ALTER TABLE ALTER COLUMN resets CYCLE option of IDENTITY column: Resolved
• Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column: Resolved
• Allow a GENERATED column to explicitly specify NO CYCLE: Resolved
• Test Coverage for added features.: Resolved
• Documentation for changes made as part of DERBY-6904: Resolved