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 "Thomas Dudziak (JIRA)" <ji...@apache.org> on 2006/07/19 07:01:15 UTC
[jira] Resolved: (DDLUTILS-18) DB2 autoincrement
[ http://issues.apache.org/jira/browse/DDLUTILS-18?page=all ]
Thomas Dudziak resolved DDLUTILS-18.
------------------------------------
Resolution: Fixed
A table defined as
CREATE TABLE Test (
PK INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY,
PRIMARY KEY (PK)
)
is now returned as
<table name="TEST">
<column name="PK" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true"/>
</table>
The same applies to a table defined as
CREATE TABLE Test (
PK INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
PRIMARY KEY (PK)
)
though DdlUtils will not generate this form of identity.
> DB2 autoincrement
> -----------------
>
> Key: DDLUTILS-18
> URL: http://issues.apache.org/jira/browse/DDLUTILS-18
> Project: DdlUtils
> Issue Type: Bug
> Components: Core - DB2
> Environment: DB2 version 8
> Reporter: dan meany
> Assigned To: Thomas Dudziak
> Fix For: 1.0
>
>
> Reading table schema for an autoincrement column in DB2 v.8 produces:
> <column name="SEQ_NO" primaryKey="true" required="true" type="INTEGER" size="10" default="IDENTITY GENERATED BY DEFAULT" autoIncrement="false"/>
> Should be autoIncrement="true"
--
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