Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6904

Enhance ALTER TABLE to allow CYCLE option to be changed.

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 10.13.1.0
    • 10.14.1.0
    • SQL
    • None

    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.

      Attachments

        1. 6904_2.diff
          29 kB
          Harshvardhan Gupta
        2. 6904_3.diff
          31 kB
          Harshvardhan Gupta
        3. 6904_4.diff
          36 kB
          Harshvardhan Gupta
        4. 6904.diff
          21 kB
          Harshvardhan Gupta
        5. columnMismatch
          15 kB
          Harshvardhan Gupta
        6. compareDbName
          8 kB
          Harshvardhan Gupta

        Issue Links

        is blocked by

        Bug - A problem which impairs or prevents the functions of the product. DERBY-6961 SET CYCLE fails to let an identity column cycle if the range is already exhausted

        • Major - Major loss of function.
        • Resolved

        Bug - A problem which impairs or prevents the functions of the product. DERBY-6962 Forbid ALTER TABLE ... SET CYCLE on identity columns in pre-10.11 databases

        • Major - Major loss of function.
        • Closed
        is related to

        Bug - A problem which impairs or prevents the functions of the product. DERBY-6959 Require the Standard SET keyword in the syntax for changing the cycle behavior of identity columns

        • Major - Major loss of function.
        • Closed

        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:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment