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

    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

        1. dblook_tests.diff
          37 kB
          Bryan Pendleton

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: