db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r170844 - in /incubator/jdo/trunk/tck20/test: jdo/datastoreidentity/org/apache/jdo/tck/pc/company/ orm/applicationidentity/org/apache/jdo/tck/pc/company/ orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ orm/datastoreidentity/org/apache/jdo/tck/pc/company/ orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ sql/derby/
Date Thu, 19 May 2005 00:23:20 GMT
Author: mcaisse
Date: Wed May 18 17:23:19 2005
New Revision: 170844

URL: http://svn.apache.org/viewcvs?rev=170844&view=rev
Log:
Fix various problems with schema, metadata

Modified:
    incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/company/package.jdo
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/HashMapStringKeyCollections-derby.orm
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/HashtableStringKeyCollections-derby.orm
    incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/company/package-derby.orm
    incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
    incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/HashtableStringKeyCollections-derby.orm
    incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql
    incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql

Modified: incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/company/package.jdo
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/company/package.jdo?rev=170844&r1=170843&r2=170844&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/company/package.jdo
(original)
+++ incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/company/package.jdo
Wed May 18 17:23:19 2005
@@ -12,6 +12,7 @@
         </class>
 
         <class name="Company" identity-type="datastore">
+            <field name="companyid" persistence-modifier="none"/>
             <field name="address"
                    persistence-modifier="persistent"/>
             <field name="departments" persistence-modifier="persistent">

Modified: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm?rev=170844&r1=170843&r2=170844&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm
(original)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm
Wed May 18 17:23:19 2005
@@ -96,7 +96,7 @@
                 </embedded>
             </field>
             <field name="phoneNumbers" table="employee_phoneno_type" >
-                <join column="PERSONID"/>
+                <join column="EMPID"/>
                 <key column="TYPE"/>
                 <value column="PHONENO"/>
             </field>

Modified: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm?rev=170844&r1=170843&r2=170844&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
(original)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
Wed May 18 17:23:19 2005
@@ -24,7 +24,7 @@
             <field name="fld_Locale" column="LOCALEVAL"/>
             <field name="fld_Date" column="DATEVAL"/>
             <field name="fld_BigDecimal">
-                <column name="BIGDECIMALVAL" jdbc-type="DECIMAL" length="11" scale="4"/>
+                <column name="BIGDECIMALVAL" jdbc-type="DECIMAL" length="25" scale="10"/>
             </field>
             <field name="fld_BigInteger" column="BIGINTEGERVAL"/>
         </class>

Modified: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/HashMapStringKeyCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/HashMapStringKeyCollections-derby.orm?rev=170844&r1=170843&r2=170844&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/HashMapStringKeyCollections-derby.orm
(original)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/HashMapStringKeyCollections-derby.orm
Wed May 18 17:23:19 2005
@@ -2,7 +2,7 @@
 <!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata
2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
 <orm>
     <package name="org.apache.jdo.tck.pc.fieldtypes">
-        <class name="HashMapStringKeyCollections" table="HASHMAPSTRINGKEY_COLLEC
+        <class name="HashMapStringKeyCollections" table="HASHMAPSTRINGKEY_COLLECTIONS">
             <field name="identifier" column="IDENTIFIER" primary-key="true"/>
             <field name="HashMapOfString_Object0" table="HASHMAP_STR_OBJECT0">
                 <join column="IDENTIFIER"/>

Modified: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/HashtableStringKeyCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/HashtableStringKeyCollections-derby.orm?rev=170844&r1=170843&r2=170844&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/HashtableStringKeyCollections-derby.orm
(original)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/HashtableStringKeyCollections-derby.orm
Wed May 18 17:23:19 2005
@@ -1,8 +1,8 @@
 <?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects tableping Metadata
2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata
2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
 <orm>
     <package name="org.apache.jdo.tck.pc.fieldtypes">
-        <class name="HashtableStringKeyCollections" table="HASHTABLESTRINGKEY_COLLEC
+        <class name="HashtableStringKeyCollections" table="HASHTABLESTRINGKEY_COLLECTIONS">
             <field name="identifier" column="IDENTIFIER" primary-key="true"/>
             <field name="HashtableOfString_Object0" table="HASHTBL_OF_STR_OBJECT0">
                 <join column="IDENTIFIER"/>

Modified: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/company/package-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/company/package-derby.orm?rev=170844&r1=170843&r2=170844&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/company/package-derby.orm
(original)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/company/package-derby.orm
Wed May 18 17:23:19 2005
@@ -96,13 +96,14 @@
                 </embedded>
             </field>
             <field name="phoneNumbers" table="employee_phoneno_type" >
-                <join column="PERSONID"/>
+                <join column="EMPID"/>
                 <key column="TYPE"/>
                 <value column="PHONENO"/>
             </field>
         </class>
 
         <class name="Insurance" table="insuranceplans">
+            <datastore-identity strategy="identity" column="INSID"/>
             <inheritance strategy="new-table">
                 <discriminator strategy="class-name" column="DISCRIMINATOR"/>
             </inheritance>

Modified: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm?rev=170844&r1=170843&r2=170844&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
(original)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
Wed May 18 17:23:19 2005
@@ -24,7 +24,7 @@
             <field name="fld_Locale" column="LOCALEVAL"/>
             <field name="fld_Date" column="DATEVAL"/>
             <field name="fld_BigDecimal">
-                <column name="BIGDECIMALVAL" jdbc-type="DECIMAL" length="11" scale="4"/>
+                <column name="BIGDECIMALVAL" jdbc-type="DECIMAL" length="25" scale="10"/>
             </field>
             <field name="fld_BigInteger" column="BIGINTEGERVAL"/>
         </class>

Modified: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/HashtableStringKeyCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/HashtableStringKeyCollections-derby.orm?rev=170844&r1=170843&r2=170844&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/HashtableStringKeyCollections-derby.orm
(original)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/HashtableStringKeyCollections-derby.orm
Wed May 18 17:23:19 2005
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects tableping Metadata
2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata
2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
 <orm>
     <package name="org.apache.jdo.tck.pc.fieldtypes">
         <class name="HashtableStringKeyCollections" table="HASHTABLESTRINGKEY_COLLECTIONS">

Modified: incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql?rev=170844&r1=170843&r2=170844&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Wed May 18 17:23:19 2005
@@ -34,24 +34,24 @@
 
 CREATE TABLE PrimitiveTypes (
     ID BIGINT NOT NULL,
-    booleanNotNull CHAR FOR BIT DATA NOT NULL,
-    booleanNull CHAR FOR BIT DATA NOT NULL,
+    booleanNotNull CHAR(1) NOT NULL CHECK (booleanNotNull IN ('Y','N')),
+    booleanNull CHAR(1) CHECK (booleanNull IN ('Y','N')),
     byteNotNull SMALLINT NOT NULL,
-    byteNull SMALLINT NOT NULL,
+    byteNull SMALLINT,
     shortNotNull SMALLINT NOT NULL,
     shortNull SMALLINT NOT NULL,
-    intNotNull INTEGER NOT NULL,
-    intNull INTEGER NOT NULL,
+    intNotNull INTEGER,
+    intNull INTEGER,
     longNotNull INTEGER NOT NULL,
-    longNull INTEGER NOT NULL,
+    longNull INTEGER,
     floatNotNull FLOAT NOT NULL,
-    floatNull FLOAT NOT NULL,
+    floatNull FLOAT,
     doubleNotNull FLOAT NOT NULL,
-    doubleNull FLOAT NOT NULL,
+    doubleNull FLOAT,
     charNotNull CHAR NOT NULL,
-    charNull CHAR NOT NULL,
-    dateNull DATE NOT NULL,
-    stringNull VARCHAR (256) NOT NULL,
+    charNull CHAR,
+    dateNull DATE,
+    stringNull VARCHAR (256),
     bigDecimal DECIMAL NOT NULL,
     bigInteger INTEGER NOT NULL,
     PrimitiveTypes INTEGER NOT NULL,
@@ -660,26 +660,26 @@
 CREATE TABLE ALLTYPES
 (
     ID INTEGER NOT NULL,
-    PRIMITIVEBOOLEAN CHAR(1) NOT NULL CHECK (PRIMITIVEBOOLEAN IN ('Y','N')),
-    PRIMITIVEBYTE SMALLINT NOT NULL,
-    PRIMITIVECHAR INTEGER NOT NULL,
-    PRIMITIVEDOUBLE DOUBLE NOT NULL,
-    PRIMITIVEFLOAT FLOAT NOT NULL,
-    PRIMITIVEINT INTEGER NOT NULL,
-    PRIMITIVELONG BIGINT NOT NULL,
-    PRIMITIVESHORT SMALLINT NOT NULL,
-    BOOLEANVAL CHAR(1) NOT NULL CHECK (BOOLEANVAL IN ('Y','N')),
-    BYTEVAL SMALLINT NOT NULL,
-    CHARACTERVAL CHAR(1) NOT NULL,
-    DOUBLEVAL DOUBLE NOT NULL,
-    FLOATVAL FLOAT NOT NULL,
-    INTEGERVAL INTEGER NOT NULL,
-    LONGVAL BIGINT NOT NULL,
-    SHORTVAL SMALLINT NOT NULL,
-    STRINGVAL VARCHAR(255) NOT NULL,
-    LOCALEVAL CHAR(20) NOT NULL,
-    DATEVAL DATE NOT NULL,
-    BIGDECIMALVAL DECIMAL(11,4)
+    PRIMITIVEBOOLEAN CHAR(1) CHECK (PRIMITIVEBOOLEAN IN ('Y','N')),
+    PRIMITIVEBYTE SMALLINT,
+    PRIMITIVECHAR INTEGER,
+    PRIMITIVEDOUBLE DOUBLE,
+    PRIMITIVEFLOAT FLOAT,
+    PRIMITIVEINT INTEGER,
+    PRIMITIVELONG BIGINT,
+    PRIMITIVESHORT SMALLINT,
+    BOOLEANVAL CHAR(1) CHECK (BOOLEANVAL IN ('Y','N')),
+    BYTEVAL SMALLINT,
+    CHARACTERVAL CHAR(1),
+    DOUBLEVAL DOUBLE,
+    FLOATVAL FLOAT,
+    INTEGERVAL INTEGER,
+    LONGVAL BIGINT,
+    SHORTVAL SMALLINT,
+    STRINGVAL VARCHAR(255),
+    LOCALEVAL CHAR(20),
+    DATEVAL DATE,
+    BIGDECIMALVAL DECIMAL(25,10),
     BIGINTEGERVAL BIGINT
 );
 

Modified: incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql?rev=170844&r1=170843&r2=170844&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql Wed May 18 17:23:19 2005
@@ -34,24 +34,24 @@
 
 CREATE TABLE PrimitiveTypes (
     ID BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY,
-    booleanNotNull CHAR FOR BIT DATA NOT NULL,
-    booleanNull CHAR FOR BIT DATA NOT NULL,
+    booleanNotNull CHAR(1) NOT NULL CHECK (booleanNotNull IN ('Y','N')),
+    booleanNull CHAR(1) CHECK (booleanNull IN ('Y','N')),
     byteNotNull SMALLINT NOT NULL,
-    byteNull SMALLINT NOT NULL,
+    byteNull SMALLINT,
     shortNotNull SMALLINT NOT NULL,
     shortNull SMALLINT NOT NULL,
-    intNotNull INTEGER NOT NULL,
-    intNull INTEGER NOT NULL,
+    intNotNull INTEGER,
+    intNull INTEGER,
     longNotNull INTEGER NOT NULL,
-    longNull INTEGER NOT NULL,
+    longNull INTEGER,
     floatNotNull FLOAT NOT NULL,
-    floatNull FLOAT NOT NULL,
+    floatNull FLOAT,
     doubleNotNull FLOAT NOT NULL,
-    doubleNull FLOAT NOT NULL,
+    doubleNull FLOAT,
     charNotNull CHAR NOT NULL,
-    charNull CHAR NOT NULL,
-    dateNull DATE NOT NULL,
-    stringNull VARCHAR (256) NOT NULL,
+    charNull CHAR,
+    dateNull DATE,
+    stringNull VARCHAR (256),
     bigDecimal DECIMAL NOT NULL,
     bigInteger INTEGER NOT NULL,
     PrimitiveTypes INTEGER NOT NULL,
@@ -93,7 +93,7 @@
 );
 
 CREATE TABLE persons (
-    PERSONID INTEGER NOT NULL,
+    PERSONID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
@@ -117,7 +117,7 @@
 );
 
 CREATE TABLE insuranceplans (
-    INSID INTEGER NOT NULL,
+    INSID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     CARRIER VARCHAR(64) NOT NULL,
     LIFETIME_ORTHO_BENEFIT DECIMAL,
     PLANTYPE VARCHAR(8),
@@ -127,7 +127,7 @@
 );
 
 CREATE TABLE projects (
-    PROJID INTEGER NOT NULL,
+    PROJID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     NAME VARCHAR(32) NOT NULL,
     BUDGET DECIMAL NOT NULL,
     CONSTRAINT PROJS_PK PRIMARY KEY (PROJID)
@@ -659,27 +659,27 @@
 
 CREATE TABLE ALLTYPES
 (
-    ID INTEGER NOT NULL,
-    PRIMITIVEBOOLEAN CHAR(1) NOT NULL CHECK (PRIMITIVEBOOLEAN IN ('Y','N')),
-    PRIMITIVEBYTE SMALLINT NOT NULL,
-    PRIMITIVECHAR INTEGER NOT NULL,
-    PRIMITIVEDOUBLE DOUBLE NOT NULL,
-    PRIMITIVEFLOAT FLOAT NOT NULL,
-    PRIMITIVEINT INTEGER NOT NULL,
-    PRIMITIVELONG BIGINT NOT NULL,
-    PRIMITIVESHORT SMALLINT NOT NULL,
-    BOOLEANVAL CHAR(1) NOT NULL CHECK (BOOLEANVAL IN ('Y','N')),
-    BYTEVAL SMALLINT NOT NULL,
-    CHARACTERVAL CHAR(1) NOT NULL,
-    DOUBLEVAL DOUBLE NOT NULL,
-    FLOATVAL FLOAT NOT NULL,
-    INTEGERVAL INTEGER NOT NULL,
-    LONGVAL BIGINT NOT NULL,
-    SHORTVAL SMALLINT NOT NULL,
-    STRINGVAL VARCHAR(255) NOT NULL,
-    LOCALEVAL CHAR(20) NOT NULL,
-    DATEVAL DATE NOT NULL,
-    BIGDECIMALVAL DECIMAL(11,4),
+    ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    PRIMITIVEBOOLEAN CHAR(1)CHECK (PRIMITIVEBOOLEAN IN ('Y','N')),
+    PRIMITIVEBYTE SMALLINT,
+    PRIMITIVECHAR INTEGER,
+    PRIMITIVEDOUBLE DOUBLE,
+    PRIMITIVEFLOAT FLOAT,
+    PRIMITIVEINT INTEGER,
+    PRIMITIVELONG BIGINT,
+    PRIMITIVESHORT SMALLINT,
+    BOOLEANVAL CHAR(1)CHECK (BOOLEANVAL IN ('Y','N')),
+    BYTEVAL SMALLINT,
+    CHARACTERVAL CHAR(1),
+    DOUBLEVAL DOUBLE,
+    FLOATVAL FLOAT,
+    INTEGERVAL INTEGER,
+    LONGVAL BIGINT,
+    SHORTVAL SMALLINT,
+    STRINGVAL VARCHAR(255),
+    LOCALEVAL CHAR(20),
+    DATEVAL DATE,
+    BIGDECIMALVAL DECIMAL(25,10),
     BIGINTEGERVAL BIGINT
 );
 
@@ -700,7 +700,7 @@
     BIG_DECIMAL112 DECIMAL(11,4),
     BIG_DECIMAL113 DECIMAL(11,4),
     BIG_DECIMAL114 DECIMAL(11,4),
-    BIG_DECIMAL111,4 DECIMAL(11,4),
+    BIG_DECIMAL111 DECIMAL(11,4),
     BIG_DECIMAL12 DECIMAL(11,4),
     BIG_DECIMAL120 DECIMAL(11,4),
     BIG_DECIMAL121 DECIMAL(11,4),
@@ -6963,7 +6963,7 @@
 DROP TABLE FieldSameName;
 
 CREATE TABLE AllPersist (
-    KEY_VALUE INTEGER NOT NULL,
+    KEY_VALUE INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     DOUBLE_B DOUBLE,
     INT_B INTEGER,
     FLOAT_E FLOAT,
@@ -6978,7 +6978,7 @@
 );
 
 CREATE TABLE TopNonPersistB (
-    KEY_VALUE INTEGER NOT NULL,
+    KEY_VALUE INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     DOUBLE_B DOUBLE,
     INT_B INTEGER,
     FLOAT_E FLOAT,
@@ -6993,7 +6993,7 @@
 );
 
 CREATE TABLE TopPersist (
-    KEY_VALUE INTEGER NOT NULL,
+    KEY_VALUE INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     DOUBLE_B DOUBLE,
     INT_B INTEGER,
     FLOAT_E FLOAT,
@@ -7008,7 +7008,7 @@
 );
 
 CREATE TABLE FieldSameName (
-    KEY_VALUE INTEGER NOT NULL,
+    KEY_VALUE INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     N2 DOUBLE,
     N3 INTEGER,
     FSN2_N3 FLOAT,
@@ -7030,7 +7030,7 @@
 DROP TABLE InstanceCallbacks;
 
 CREATE TABLE ICNonPersistFds (
-    ICKEY INTEGER NOT NULL,
+    ICKEY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     D DOUBLE,
     S SMALLINT,
     FLOATVAL FLOAT,
@@ -7039,7 +7039,7 @@
 );
 
 CREATE TABLE InstanceCallbacks (
-    ICKEY INTEGER NOT NULL,
+    ICKEY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     NAME VARCHAR(64),
     TIMEDATE TIMESTAMP,
     NEXTOBJ INTEGER,



Mime
View raw message