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

Enhance ALTER TABLE to allow CYCLE option to be changed.

    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. compareDbName
          8 kB
          Harshvardhan Gupta
        2. columnMismatch
          15 kB
          Harshvardhan Gupta
        3. 6904.diff
          21 kB
          Harshvardhan Gupta
        4. 6904_4.diff
          36 kB
          Harshvardhan Gupta
        5. 6904_3.diff
          31 kB
          Harshvardhan Gupta
        6. 6904_2.diff
          29 kB
          Harshvardhan Gupta

        Issue Links

          There are no Sub-Tasks for this issue.

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: