db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject 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
Date Tue, 03 May 2005 22:10:14 GMT
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)
 );
 
 -------------------------



Mime
View raw message