You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Laurent ROCHE (JIRA)" <ji...@apache.org> on 2006/11/27 12:54:21 UTC
[jira] Created: (DDLUTILS-134) Bad start value when importing
identity in Derby
Bad start value when importing identity in Derby
------------------------------------------------
Key: DDLUTILS-134
URL: http://issues.apache.org/jira/browse/DDLUTILS-134
Project: DdlUtils
Issue Type: Bug
Affects Versions: 1.1
Environment: PostgreSQL 8.1.4; Derby 10.2.1
Reporter: Laurent ROCHE
Assigned To: Thomas Dudziak
I am transfering a DB from PostgreSQL to Derby using DDL-Utils Ant program.
I have columns defines as SERIAL and with data in PostgreSQL and when transfered the start value for the serial colum is ONE (in Derby) when I would expect it to be the same as in Postgres (the increment value seems strange too).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DDLUTILS-134) Bad start value when importing
identity in Derby
Posted by "Laurent ROCHE (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-134?page=all ]
Laurent ROCHE updated DDLUTILS-134:
-----------------------------------
Attachment: Ddlutils-test.zip
In case, somebody interested (in fixing this) does not have access to a Postgres server, here are the files produced on export (see the buil.xml file).
> Bad start value when importing identity in Derby
> ------------------------------------------------
>
> Key: DDLUTILS-134
> URL: http://issues.apache.org/jira/browse/DDLUTILS-134
> Project: DdlUtils
> Issue Type: Bug
> Affects Versions: 1.1
> Environment: PostgreSQL 8.1.4; Derby 10.2.1
> Reporter: Laurent ROCHE
> Assigned To: Thomas Dudziak
> Attachments: Ddlutils-test.zip, my_build.xml, test_derby.sql
>
>
> I am transfering a DB from PostgreSQL to Derby using DDL-Utils Ant program.
> I have columns defines as SERIAL and with data in PostgreSQL and when transfered the start value for the serial colum is ONE (in Derby) when I would expect it to be the same as in Postgres (the increment value seems strange too).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DDLUTILS-134) Bad start value when importing
identity in Derby
Posted by "Laurent ROCHE (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DDLUTILS-134?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12468221 ]
Laurent ROCHE commented on DDLUTILS-134:
----------------------------------------
I understand your point of view, but it will be nice to have the choice (via an option) particularly when using option 1 (inserting rows with the data ids).
If I find some time (in Summer, may be), I will see if I can work on this.
> Bad start value when importing identity in Derby
> ------------------------------------------------
>
> Key: DDLUTILS-134
> URL: https://issues.apache.org/jira/browse/DDLUTILS-134
> Project: DdlUtils
> Issue Type: Bug
> Affects Versions: 1.1
> Environment: PostgreSQL 8.1.4; Derby 10.2.1
> Reporter: Laurent ROCHE
> Assigned To: Thomas Dudziak
> Attachments: Ddlutils-test.zip, my_build.xml, test_derby.sql
>
>
> I am transfering a DB from PostgreSQL to Derby using DDL-Utils Ant program.
> I have columns defines as SERIAL and with data in PostgreSQL and when transfered the start value for the serial colum is ONE (in Derby) when I would expect it to be the same as in Postgres (the increment value seems strange too).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DDLUTILS-134) Bad start value when importing
identity in Derby
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DDLUTILS-134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Dudziak resolved DDLUTILS-134.
-------------------------------------
Resolution: Invalid
DdlUtils can insert data into auto-increment columns in two ways:
* using the value defined in the row to insert thereby effectively overriding the auto-increment value
* using the auto-increment value which ignoresany value in the row
The latter is the default as the first option won't change the auto-increment sequence (whether internal or DdlUtils-created) and hence a later insertion of data using the second option might lead to conflicts if unique values are required.
In order to use option 1 via the Ant tasks, one has to set the useExplicitIdentityValues parameter to true (http://db.apache.org/ddlutils/ant/org.apache.ddlutils.task.WriteDataToDatabaseCommand.html#parameter-useexplicitidentityvalues).
> Bad start value when importing identity in Derby
> ------------------------------------------------
>
> Key: DDLUTILS-134
> URL: https://issues.apache.org/jira/browse/DDLUTILS-134
> Project: DdlUtils
> Issue Type: Bug
> Affects Versions: 1.1
> Environment: PostgreSQL 8.1.4; Derby 10.2.1
> Reporter: Laurent ROCHE
> Assigned To: Thomas Dudziak
> Attachments: Ddlutils-test.zip, my_build.xml, test_derby.sql
>
>
> I am transfering a DB from PostgreSQL to Derby using DDL-Utils Ant program.
> I have columns defines as SERIAL and with data in PostgreSQL and when transfered the start value for the serial colum is ONE (in Derby) when I would expect it to be the same as in Postgres (the increment value seems strange too).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DDLUTILS-134) Bad start value when importing
identity in Derby
Posted by "Laurent ROCHE (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-134?page=all ]
Laurent ROCHE updated DDLUTILS-134:
-----------------------------------
Attachment: test_derby.sql
Here is a postgreSQL script which is an example of the table exported
> Bad start value when importing identity in Derby
> ------------------------------------------------
>
> Key: DDLUTILS-134
> URL: http://issues.apache.org/jira/browse/DDLUTILS-134
> Project: DdlUtils
> Issue Type: Bug
> Affects Versions: 1.1
> Environment: PostgreSQL 8.1.4; Derby 10.2.1
> Reporter: Laurent ROCHE
> Assigned To: Thomas Dudziak
> Attachments: test_derby.sql
>
>
> I am transfering a DB from PostgreSQL to Derby using DDL-Utils Ant program.
> I have columns defines as SERIAL and with data in PostgreSQL and when transfered the start value for the serial colum is ONE (in Derby) when I would expect it to be the same as in Postgres (the increment value seems strange too).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DDLUTILS-134) Bad start value when importing
identity in Derby
Posted by "Laurent ROCHE (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-134?page=all ]
Laurent ROCHE updated DDLUTILS-134:
-----------------------------------
Attachment: my_build.xml
This is the build file used to export (from PostgreSQL) and import (into Derby).
> Bad start value when importing identity in Derby
> ------------------------------------------------
>
> Key: DDLUTILS-134
> URL: http://issues.apache.org/jira/browse/DDLUTILS-134
> Project: DdlUtils
> Issue Type: Bug
> Affects Versions: 1.1
> Environment: PostgreSQL 8.1.4; Derby 10.2.1
> Reporter: Laurent ROCHE
> Assigned To: Thomas Dudziak
> Attachments: my_build.xml, test_derby.sql
>
>
> I am transfering a DB from PostgreSQL to Derby using DDL-Utils Ant program.
> I have columns defines as SERIAL and with data in PostgreSQL and when transfered the start value for the serial colum is ONE (in Derby) when I would expect it to be the same as in Postgres (the increment value seems strange too).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira