You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-commits@db.apache.org by mc...@apache.org on 2005/05/04 00:10:14 UTC
svn commit: r168004 - in /incubator/jdo/trunk/tck20/test:
jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo
jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo
orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm
sql/derby/schema1.sql
Author: mcaisse
Date: Tue May 3 15:10:13 2005
New Revision: 168004
URL: http://svn.apache.org/viewcvs?rev=168004&view=rev
Log:
JDO-35; JDO-8 interim check-in
Added:
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm (with props)
Modified:
incubator/jdo/trunk/tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo
incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo
incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql
Modified: incubator/jdo/trunk/tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo?rev=168004&r1=168003&r2=168004&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo (original)
+++ incubator/jdo/trunk/tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo Tue May 3 15:10:13 2005
@@ -1,10 +1,11 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jdo PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN" "http://java.sun.com/dtd/jdo_2_0.dtd">
<jdo>
-<package name="org.apache.jdo.tck.pc.fieldtypes">
-<class name="SimpleClass" identity-type="application"
- objectid-class="org.apache.jdo.tck.pc.fieldtypes.SimpleClass$Oid">
-<field name="id" primary-key="true"/>
-</class>
-</package>
+ <package name="org.apache.jdo.tck.pc.fieldtypes">
+ <class name="SimpleClass" identity-type="application"
+ objectid-class="org.apache.jdo.tck.pc.fieldtypes.SimpleClass$Oid">
+ <implements name="SimpleInterface"/>
+ <field name="id" primary-key="true"/>
+ </class>
+ </package>
</jdo>
Modified: incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo?rev=168004&r1=168003&r2=168004&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo (original)
+++ incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo Tue May 3 15:10:13 2005
@@ -1,8 +1,9 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jdo PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN" "http://java.sun.com/dtd/jdo_2_0.dtd">
<jdo>
-<package name="org.apache.jdo.tck.pc.fieldtypes">
-<class name="SimpleClass" identity-type="datastore">
-</class>
-</package>
+ <package name="org.apache.jdo.tck.pc.fieldtypes">
+ <class name="SimpleClass" identity-type="datastore">
+ <implements name="SimpleInteface"/>
+ </class>
+ </package>
</jdo>
Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm?rev=168004&view=auto
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm (added)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm Tue May 3 15:10:13 2005
@@ -0,0 +1,177 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!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="CollectionCollections" table="COLLECTION_COLLECTIONS">
+ <field name="identifier" column="IDENTIFIER" primary-key="true"/>
+ <field name="CollectionOfObject0" table="COLLECTION_OF_OBJECT0">
+ <join column="IDENTIFIER"/>
+ <element column="OBJVAL"/>
+ </field>
+ <field name="CollectionOfObject1" table="COLLECTION_OF_OBJECT1">
+ <join column="IDENTIFIER"/>
+ <element column="OBJVAL"/>
+ </field>
+ <field name="CollectionOfObject2" table="COLLECTION_OF_OBJECT2">
+ <join column="IDENTIFIER"/>
+ <element column="OBJVAL"/>
+ </field>
+ <field name="CollectionOfSimpleClass3" table="COLLECTION_OF_SIMPLE_CLASS3">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTVAL"/>
+ </field>
+ <field name="CollectionOfSimpleClass4" table="COLLECTION_OF_SIMPLE_CLASS4">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTVAL"/>
+ </field>
+ <field name="CollectionOfSimpleClass5" table="COLLECTION_OF_SIMPLE_CLASS5">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTVAL"/>
+ </field>
+ <field name="CollectionOfSimpleInterface6" table="COLLECTION_OF_SIMPLE_INTERFACE6">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTVAL"/>
+ </field>
+ <field name="CollectionOfSimpleInterface7" table="COLLECTION_OF_SIMPLE_INTERFACE7">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTVAL"/>
+ </field>
+ <field name="CollectionOfSimpleInterface8" table="COLLECTION_OF_SIMPLE_INTERFACE8">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTVAL"/>
+ </field>
+ <field name="CollectionOfString9" table="COLLECTION_OF_STRING9">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ </field>
+ <field name="CollectionOfString10" table="COLLECTION_OF_STRING10">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ </field>
+ <field name="CollectionOfString11" table="COLLECTION_OF_STRING11">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ </field>
+ <field name="CollectionOfDate12" table="COLLECTION_OF_DATE12">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ </field>
+ <field name="CollectionOfDate13" table="COLLECTION_OF_DATE13">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ </field>
+ <field name="CollectionOfDate14" table="COLLECTION_OF_DATE14">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ </field>
+ <field name="CollectionOfLocale15" table="COLLECTION_OF_LOCALE15">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ </field>
+ <field name="CollectionOfLocale16" table="COLLECTION_OF_LOCALE16">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ </field>
+ <field name="CollectionOfLocale17" table="COLLECTION_OF_LOCALE17">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ </field>
+ <field name="CollectionOfBigDecimal18" table="COLLECTION_OF_BIG_DECIMAL18">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ </field>
+ <field name="CollectionOfBigDecimal19" table="COLLECTION_OF_BIG_DECIMAL19">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ </field>
+ <field name="CollectionOfBigDecimal20" table="COLLECTION_OF_BIG_DECIMAL20">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ </field>
+ <field name="CollectionOfBigInteger21" table="COLLECTION_OF_BIG_INTEGER21">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ </field>
+ <field name="CollectionOfBigInteger22" table="COLLECTION_OF_BIG_INTEGER22">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ </field>
+ <field name="CollectionOfBigInteger23" table="COLLECTION_OF_BIG_INTEGER23">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ </field>
+ <field name="CollectionOfByte24" table="COLLECTION_OF_BYTE24">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ </field>
+ <field name="CollectionOfByte25" table="COLLECTION_OF_BYTE25">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ </field>
+ <field name="CollectionOfByte26" table="COLLECTION_OF_BYTE27">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ </field>
+ <field name="CollectionOfDouble27" table="COLLECTION_OF_DOUBLE27">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ </field>
+ <field name="CollectionOfDouble28" table="COLLECTION_OF_DOUBLE28">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ </field>
+ <field name="CollectionOfDouble29" table="COLLECTION_OF_DOUBLE29">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ </field>
+ <field name="CollectionOfFloat30" table="COLLECTION_OF_FLOAT30">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ </field>
+ <field name="CollectionOfFloat31" table="COLLECTION_OF_FLOAT31">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ </field>
+ <field name="CollectionOfFloat32" table="COLLECTION_OF_FLOAT32">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ </field>
+ <field name="CollectionOfInteger33" table="COLLECTION_OF_INTEGER33">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ </field>
+ <field name="CollectionOfInteger34" table="COLLECTION_OF_INTEGER34">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ </field>
+ <field name="CollectionOfInteger35" table="COLLECTION_OF_INTEGER35">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ </field>
+ <field name="CollectionOfLong36" table="COLLECTION_OF_LONG36">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ </field>
+ <field name="CollectionOfLong37" table="COLLECTION_OF_LONG37">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ </field>
+ <field name="CollectionOfLong38" table="COLLECTION_OF_LONG38">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ </field>
+ <field name="CollectionOfShort39" table="COLLECTION_OF_SHORT39">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ </field>
+ <field name="CollectionOfShort40" table="COLLECTION_OF_SHORT40">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ </field>
+ <field name="CollectionOfShort41" table="COLLECTION_OF_SHORT41">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ </field>
+ </class>
+ </package>
+</orm>
Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm
------------------------------------------------------------------------------
svn:executable = *
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=168004&r1=168003&r2=168004&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Tue May 3 15:10:13 2005
@@ -179,6 +179,36 @@
DROP TABLE FIELDSOFPRIMITIVESHORT;
DROP TABLE FIELDSOFSHORT;
DROP TABLE FIELDSOFSTRING;
+DROP TABLE ARRAY_COLLECTIONS;
+DROP TABLE ARRAY_OF_BIG_DECIMAL12;
+DROP TABLE ARRAY_OF_BIG_DECIMAL13;
+DROP TABLE ARRAY_OF_BIG_INTEGER14;
+DROP TABLE ARRAY_OF_BIG_INTEGER15;
+DROP TABLE ARRAY_OF_BYTE16;
+DROP TABLE ARRAY_OF_BYTE17;
+DROP TABLE ARRAY_OF_DATE8;
+DROP TABLE ARRAY_OF_DATE9;
+DROP TABLE ARRAY_OF_DOUBLE18;
+DROP TABLE ARRAY_OF_DOUBLE19;
+DROP TABLE ARRAY_OF_FLOAT20;
+DROP TABLE ARRAY_OF_FLOAT21;
+DROP TABLE ARRAY_OF_INTEGER22;
+DROP TABLE ARRAY_OF_INTEGER23;
+DROP TABLE ARRAY_OF_LOCALE10;
+DROP TABLE ARRAY_OF_LOCALE11;
+DROP TABLE ARRAY_OF_LONG24;
+DROP TABLE ARRAY_OF_LONG25;
+DROP TABLE ARRAY_OF_OBJECT0;
+DROP TABLE ARRAY_OF_OBJECT1;
+DROP TABLE ARRAY_OF_SHORT26;
+DROP TABLE ARRAY_OF_SHORT27;
+DROP TABLE ARRAY_OF_SIMPLE_CLASS2;
+DROP TABLE ARRAY_OF_SIMPLE_CLASS3;
+DROP TABLE ARRAY_OF_SIMPLE_INTERFACE4;
+DROP TABLE ARRAY_OF_SIMPLE_INTERFACE5;
+DROP TABLE ARRAY_OF_STRING6;
+DROP TABLE ARRAY_OF_STRING7;
+DROP TABLE ARRAYLISTCOLLECTIONS;
CREATE TABLE FIELDSOFBIGDECIMAL
(
@@ -1909,75 +1939,6 @@
CONSTRAINT FieldsOfByte_PK PRIMARY KEY (IDENTIFIER)
);
--------------------------
---inheritance
--------------------------
-
-DROP TABLE AllPersist;
-DROP TABLE TopNonPersistB;
-DROP TABLE TopPersist;
-DROP TABLE FieldSameName;
-
-CREATE TABLE AllPersist (
- KEY_VALUE INTEGER NOT NULL,
- DOUBLE_B DOUBLE,
- INT_B INTEGER,
- FLOAT_E FLOAT,
- SHORT_F SMALLINT,
- SECOND_OBJ INTEGER,
- THIRD_OBJ INTEGER,
- INT_H INTEGER,
- DISCRIMINATOR varchar(64) NOT NULL,
- CONSTRAINT AllPersist_PK PRIMARY KEY (KEY_VALUE),
- FOREIGN KEY (SECOND_OBJ) REFERENCES AllPersist (KEY_VALUE),
- FOREIGN KEY (THIRD_OBJ) REFERENCES AllPersist (KEY_VALUE)
-);
-
-CREATE TABLE TopNonPersistB (
- KEY_VALUE INTEGER NOT NULL,
- DOUBLE_B DOUBLE,
- INT_B INTEGER,
- FLOAT_E FLOAT,
- SHORT_F SMALLINT,
- SECOND_OBJ INTEGER,
- THIRD_OBJ INTEGER,
- INT_H INTEGER,
- DISCRIMINATOR varchar(64) NOT NULL,
- CONSTRAINT TopNonPersistB_PK PRIMARY KEY (KEY_VALUE),
- FOREIGN KEY (SECOND_OBJ) REFERENCES TopNonPersistB (KEY_VALUE),
- FOREIGN KEY (THIRD_OBJ) REFERENCES TopNonPersistB (KEY_VALUE)
-);
-
-CREATE TABLE TopPersist (
- KEY_VALUE INTEGER NOT NULL,
- DOUBLE_B DOUBLE,
- INT_B INTEGER,
- FLOAT_E FLOAT,
- SHORT_F SMALLINT,
- SECOND_OBJ INTEGER,
- THIRD_OBJ INTEGER,
- INT_H INTEGER,
- DISCRIMINATOR varchar(64) NOT NULL,
- CONSTRAINT TopPersist_PK PRIMARY KEY (KEY_VALUE),
- FOREIGN KEY (SECOND_OBJ) REFERENCES TopPersist (KEY_VALUE),
- FOREIGN KEY (THIRD_OBJ) REFERENCES TopPersist (KEY_VALUE)
-);
-
-CREATE TABLE FieldSameName (
- KEY_VALUE INTEGER NOT NULL,
- N2 DOUBLE,
- N3 INTEGER,
- FSN2_N3 FLOAT,
- FSN3_N1 SMALLINT,
- FSN3_N2 INTEGER,
- FSN3_N3 INTEGER,
- FSN4_N3 INTEGER,
- DISCRIMINATOR varchar(64) NOT NULL,
- CONSTRAINT FieldSameName_PK PRIMARY KEY (KEY_VALUE),
- FOREIGN KEY (FSN3_N2) REFERENCES FieldSameName (KEY_VALUE),
- FOREIGN KEY (FSN3_N3) REFERENCES FieldSameName (KEY_VALUE)
-);
-
CREATE TABLE ARRAY_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
@@ -2211,6 +2172,280 @@
CREATE TABLE ARRAYLISTCOLLECTIONS
(
IDENTIFIER INTEGER NOT NULL
+);
+
+--CollectionCollections
+
+
+CREATE TABLE COLLECTION_COLLECTIONS
+(
+ IDENTIFIER INTEGER NOT NULL,
+ CONSTRAINT AK12_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_OBJECT0
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ OBJVAL BLOB,
+ CONSTRAINT OB0_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_OBJECT1
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ OBJVAL BLOB,
+ CONSTRAINT OB1_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_SIMPLE_CLASS2
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ SIMPINTERFVAL BLOB,
+ CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_SIMPLE_CLASS3
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ SIMPINTERFVAL BLOB,
+ CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_SIMPLE_INTERFACE4
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ SIMPINTERFVAL BLOB,
+ CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_SIMPLE_INTERFACE5
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ SIMPINTERFVAL BLOB,
+ CONSTRAINT SI5_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_STRING6
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ CONSTRAINT ST6_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_STRING7
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ CONSTRAINT ST7_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_DATE8
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ CONSTRAINT BY8_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_DATE9
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ CONSTRAINT BY9_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_LOCALE10
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ CONSTRAINT LOC10 PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_LOCALE11
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ CONSTRAINT LOC11 PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_BIG_DECIMAL12
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ CONSTRAINT BD12_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_BIG_DECIMAL13
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ CONSTRAINT BD13_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_BIG_INTEGER14
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ CONSTRAINT BI14_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_BIG_INTEGER15
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ CONSTRAINT BI15_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_BYTE16
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ CONSTRAINT BY16_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_BYTE17
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ CONSTRAINT BY17_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_DOUBLE18
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ CONSTRAINT DO18_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_DOUBLE19
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ CONSTRAINT DO19_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_FLOAT20
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ CONSTRAINT FL20 PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_FLOAT21
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ CONSTRAINT FL21 PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_INTEGER22
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ CONSTRAINT IN22 PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_INTEGER23
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ CONSTRAINT IN23 PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_LONG24
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ CONSTRAINT BI24_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_LONG25
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ CONSTRAINT BI25_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_SHORT26
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ CONSTRAINT SM26_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_SHORT27
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ CONSTRAINT SM27_PK PRIMARY KEY (IDENTIFIER)
+);
+
+-------------------------
+--inheritance
+-------------------------
+
+DROP TABLE AllPersist;
+DROP TABLE TopNonPersistB;
+DROP TABLE TopPersist;
+DROP TABLE FieldSameName;
+
+CREATE TABLE AllPersist (
+ KEY_VALUE INTEGER NOT NULL,
+ DOUBLE_B DOUBLE,
+ INT_B INTEGER,
+ FLOAT_E FLOAT,
+ SHORT_F SMALLINT,
+ SECOND_OBJ INTEGER,
+ THIRD_OBJ INTEGER,
+ INT_H INTEGER,
+ DISCRIMINATOR varchar(64) NOT NULL,
+ CONSTRAINT AllPersist_PK PRIMARY KEY (KEY_VALUE),
+ FOREIGN KEY (SECOND_OBJ) REFERENCES AllPersist (KEY_VALUE),
+ FOREIGN KEY (THIRD_OBJ) REFERENCES AllPersist (KEY_VALUE)
+);
+
+CREATE TABLE TopNonPersistB (
+ KEY_VALUE INTEGER NOT NULL,
+ DOUBLE_B DOUBLE,
+ INT_B INTEGER,
+ FLOAT_E FLOAT,
+ SHORT_F SMALLINT,
+ SECOND_OBJ INTEGER,
+ THIRD_OBJ INTEGER,
+ INT_H INTEGER,
+ DISCRIMINATOR varchar(64) NOT NULL,
+ CONSTRAINT TopNonPersistB_PK PRIMARY KEY (KEY_VALUE),
+ FOREIGN KEY (SECOND_OBJ) REFERENCES TopNonPersistB (KEY_VALUE),
+ FOREIGN KEY (THIRD_OBJ) REFERENCES TopNonPersistB (KEY_VALUE)
+);
+
+CREATE TABLE TopPersist (
+ KEY_VALUE INTEGER NOT NULL,
+ DOUBLE_B DOUBLE,
+ INT_B INTEGER,
+ FLOAT_E FLOAT,
+ SHORT_F SMALLINT,
+ SECOND_OBJ INTEGER,
+ THIRD_OBJ INTEGER,
+ INT_H INTEGER,
+ DISCRIMINATOR varchar(64) NOT NULL,
+ CONSTRAINT TopPersist_PK PRIMARY KEY (KEY_VALUE),
+ FOREIGN KEY (SECOND_OBJ) REFERENCES TopPersist (KEY_VALUE),
+ FOREIGN KEY (THIRD_OBJ) REFERENCES TopPersist (KEY_VALUE)
+);
+
+CREATE TABLE FieldSameName (
+ KEY_VALUE INTEGER NOT NULL,
+ N2 DOUBLE,
+ N3 INTEGER,
+ FSN2_N3 FLOAT,
+ FSN3_N1 SMALLINT,
+ FSN3_N2 INTEGER,
+ FSN3_N3 INTEGER,
+ FSN4_N3 INTEGER,
+ DISCRIMINATOR varchar(64) NOT NULL,
+ CONSTRAINT FieldSameName_PK PRIMARY KEY (KEY_VALUE),
+ FOREIGN KEY (FSN3_N2) REFERENCES FieldSameName (KEY_VALUE),
+ FOREIGN KEY (FSN3_N3) REFERENCES FieldSameName (KEY_VALUE)
);
-------------------------