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

Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column

Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

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

    Description

      DERBY-6542 changed IDENTITY columns to build upon the underlying
      SEQUENCE objects. SEQUENCE objects can have a CYCLE option
      set for them, and as of DERBY-6852, the CYCLE option controls the
      behavior of the IDENTITY column that uses that SEQUENCE.

      It would be nice if SYS.SYSCOLUMNS would report the CYCLE option
      that is in effect for a IDENTITY column in that column's row in SYSCOLUMNS.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment