db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject Re: [jira] Created: (DERBY-167) Inserting values in an identity column
Date Tue, 08 Mar 2005 23:12:25 GMT
Hello Derby Development Community,

I think that this is one of  those  great opportunities for a developer
new to  the Derby project to add real value to product and learn a bit
about Derby without taking on a huge project.* Is there anyone out there
willing to volunteer to propose and implement a solution? * I would be
willing to offer as much support as I can,  answer questions that are
posted, vote on proposals, review submissions, etc.

Please volunteer!



Christian Rodriguez (JIRA) wrote:

>Inserting values in an identity column
>         Key: DERBY-167
>         URL: http://issues.apache.org/jira/browse/DERBY-167
>     Project: Derby
>        Type: Improvement
>  Components: SQL  
>    Versions:    
> Environment: SQL
>    Reporter: Christian Rodriguez
>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.

View raw message