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

ALTER TABLE ... ADD COLUMN cannot add identity columns

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.4.2.0
    • 10.12.1.1
    • SQL
    • Normal

    Description

      ALTER TABLE .. ADD COLUMN cannot be used to add an identity column. There is code to handle identity columns, but it is disabled in the parser. See this thread on derby-user:
      http://mail-archives.apache.org/mod_mbox/db-derby-user/200708.mbox/%3C46C5DAA9.8080507@sbcglobal.net%3E

      The code was disabled for DB2 compatibility. Since DB2 compatibility is not a goal for Derby, we should see if we could re-enable it.

      Attachments

        1. reenable.diff
          4 kB
          Knut Anders Hatlen
        2. reenable-v2.diff
          23 kB
          Knut Anders Hatlen
        3. reenable-v3.diff
          23 kB
          Knut Anders Hatlen
        4. d3888-1a.diff
          26 kB
          Knut Anders Hatlen
        5. d3888-2a-refman.diff
          3 kB
          Knut Anders Hatlen
        6. rrefsqlj81859.html
          18 kB
          Knut Anders Hatlen

        Issue Links

          is related to

          Sub-task - The sub-task of the issue DERBY-6284 Improve test coverage of org.apache.derby.iapi.db.ConnectionInfo

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6578 Assert failure when retrying failed ADD COLUMN statement

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6414 Incorrect handling when using an UPDATE to SET an identity column to DEFAULT

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-6542 Improve the concurrency of identity columns by using SYS.SYSSEQUENCES

          • Major - Major loss of function.
          • Closed

          Activity

            People

              knutanders Knut Anders Hatlen
              knutanders Knut Anders Hatlen
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: