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

Enhance ALTER TABLE to allow CYCLE option to be changed.

    XMLWordPrintableJSON

    Details

    • 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
    • Labels:
      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: