Derby
  1. Derby
  2. DERBY-167

Inserting values in an identity column

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.1.0
    • Fix Version/s: 10.2.1.6
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      SQL

      Description

      It is not possible to insert a specific value in a column defined as identity. This makes it very hard to migrate from other RDBMSs or to import data dumped from other databases.

      For example, an autoincrement column in MySQL should be an identity column. The problem is that when the data is dumped from MySQL to a file, it generates inserts with values. These values cant be inserted in the Derby table.

      Posible solutions: 1. being able to "generate by default as identity" 2. being able to disable the "identity" feature for a column 3. being able to generate a column as non identity and after data is populated, alter table to add the "identity" to the column.

      1. DERBY-167_7.patch
        28 kB
        Tomohito Nakayama

        Activity

        Christian Rodriguez created issue -
        Tomohito Nakayama made changes -
        Field Original Value New Value
        Assignee Tomohito Nakayama [ naka ]
        Tomohito Nakayama made changes -
        Attachment DERBY-167_7.patch [ 20192 ]
        Tomohito Nakayama made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Andrew McIntyre made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Kathey Marsden made changes -
        Fix Version/s 10.2.1.6 [ 11187 ]
        Gavin made changes -
        Workflow jira [ 40695 ] Default workflow, editable Closed status [ 12801280 ]

          People

          • Assignee:
            Tomohito Nakayama
            Reporter:
            Christian Rodriguez
          • Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development