Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6904 Enhance ALTER TABLE to allow CYCLE option to be changed.
  3. DERBY-6906

Allow a GENERATED column to explicitly specify NO CYCLE

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 10.13.1.0
    • 10.14.1.0
    • SQL
    • None

    Description

      DERBY-6852 added the ability for a GENERATED IDENTITY column
      to specify that it should have CYCLE behavior, utilizing the underlying
      CYCLE behavior of the SEQUENCE object.

      A column which does not wish to have CYCLE behavior is specified
      by omitting the the CYCLE keyword.

      It would be nice to allow a GENERATED IDENTITY column to
      explicitly specify that it should have NO CYCLE behavior.

      Attachments

        Activity

          People

            harshvardhan145 Harshvardhan Gupta
            bryanpendleton Bryan Pendleton
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: