Author: mcaisse
Date: Thu May 5 10:49:08 2005
New Revision: 168361
URL: http://svn.apache.org/viewcvs?rev=168361&view=rev
Log:
JDO-8 interim check-in; JDO-37 work-around
Added:
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
(with props)
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
(with props)
Modified:
incubator/jdo/trunk/tck20/maven.xml
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql
Modified: incubator/jdo/trunk/tck20/maven.xml
URL:
http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/maven.xml?rev=168361&r1=168360&r2=168361&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/maven.xml (original)
+++ incubator/jdo/trunk/tck20/maven.xml Thu May 5 10:49:08 2005
@@ -409,7 +409,7 @@
<!-- ==== -->
<goal name="database">
- <delete dir="${jdo.tck.testdir}/database/${jdo.tck.database}"/>
+<!-- <delete dir="${jdo.tck.testdir}/database/${jdo.tck.database}"/> -->
<mkdir dir="${jdo.tck.testdir}/database/${jdo.tck.database}"/>
<copy todir="${jdo.tck.testdir}/database/${jdo.tck.database}">
<fileset dir="${basedir}/test/conf">
Added:
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
URL:
http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm?rev=168361&view=auto
==============================================================================
---
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
(added)
+++
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
Thu May 5 10:49:08 2005
@@ -0,0 +1,219 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects
Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd";>
+<orm>
+ <package name="org.apache.jdo.tck.pc.fieldtypes">
+ <class name="ListCollections" table="LIST_COLLECTIONS">
+ <field name="identifier" column="IDENTIFIER" primary-key="true"/>
+ <field name="ListOfObject0" table="LIST_OF_OBJECT0">
+ <join column="IDENTIFIER"/>
+ <element column="OBJREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfObject1" table="LIST_OF_OBJECT1">
+ <join column="IDENTIFIER"/>
+ <element column="OBJREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfObject2" table="LIST_OF_OBJECT2">
+ <join column="IDENTIFIER"/>
+ <element column="OBJREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfSimpleClass3" table="LIST_OF_SIMPLE_CLASS3">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPCLSREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfSimpleClass4" table="LIST_OF_SIMPLE_CLASS4">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPCLSREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfSimpleClass5" table="LIST_OF_SIMPLE_CLASS5">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPCLSREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfSimpleInterface6"
table="LIST_OF_SIMPLE_INTERFACE6">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfSimpleInterface7"
table="LIST_OF_SIMPLE_INTERFACE7">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfSimpleInterface8"
table="LIST_OF_SIMPLE_INTERFACE8">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfString9" table="LIST_OF_STRING9">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfString10" table="LIST_OF_STRING10">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfString11" table="LIST_OF_STRING11">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfDate12" table="LIST_OF_DATE12">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfDate13" table="LIST_OF_DATE13">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfDate14" table="LIST_OF_DATE14">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfLocale15" table="LIST_OF_LOCALE15">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfLocale16" table="LIST_OF_LOCALE16">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfLocale17" table="LIST_OF_LOCALE17">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfBigDecimal18" table="LIST_OF_BIG_DECIMAL18">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfBigDecimal19" table="LIST_OF_BIG_DECIMAL19">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfBigDecimal20" table="LIST_OF_BIG_DECIMAL20">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfBigInteger21" table="LIST_OF_BIG_INTEGER21">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfBigInteger22" table="LIST_OF_BIG_INTEGER22">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfBigInteger23" table="LIST_OF_BIG_INTEGER23">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfByte24" table="LIST_OF_BYTE24">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfByte25" table="LIST_OF_BYTE25">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfByte26" table="LIST_OF_BYTE27">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfDouble27" table="LIST_OF_DOUBLE27">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfDouble28" table="LIST_OF_DOUBLE28">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfDouble29" table="LIST_OF_DOUBLE29">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfFloat30" table="LIST_OF_FLOAT30">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfFloat31" table="LIST_OF_FLOAT31">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfFloat32" table="LIST_OF_FLOAT32">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfInteger33" table="LIST_OF_INTEGER33">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfInteger34" table="LIST_OF_INTEGER34">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfInteger35" table="LIST_OF_INTEGER35">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfLong36" table="LIST_OF_LONG36">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfLong37" table="LIST_OF_LONG37">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfLong38" table="LIST_OF_LONG38">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfShort39" table="LIST_OF_SHORT39">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfShort40" table="LIST_OF_SHORT40">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="ListOfShort41" table="LIST_OF_SHORT41">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ <order column="INDEX"/>
+ </field>
+ </class>
+ </package>
+</orm>
Propchange:
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
------------------------------------------------------------------------------
svn:executable = *
Added:
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
URL:
http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm?rev=168361&view=auto
==============================================================================
---
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
(added)
+++
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
Thu May 5 10:49:08 2005
@@ -0,0 +1,219 @@
+<?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="SetCollections" table="SET_COLLECTIONS">
+ <field name="identifier" column="IDENTIFIER" primary-key="true"/>
+ <field name="SetOfObject0" table="SET_OF_OBJECT0">
+ <join column="IDENTIFIER"/>
+ <element column="OBJREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfObject1" table="SET_OF_OBJECT1">
+ <join column="IDENTIFIER"/>
+ <element column="OBJREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfObject2" table="SET_OF_OBJECT2">
+ <join column="IDENTIFIER"/>
+ <element column="OBJREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfSimpleClass3" table="SET_OF_SIMPLE_CLASS3">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPCLSREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfSimpleClass4" table="SET_OF_SIMPLE_CLASS4">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPCLSREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfSimpleClass5" table="SET_OF_SIMPLE_CLASS5">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPCLSREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfSimpleInterface6"
table="SET_OF_SIMPLE_INTERFACE6">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfSimpleInterface7"
table="SET_OF_SIMPLE_INTERFACE7">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfSimpleInterface8"
table="SET_OF_SIMPLE_INTERFACE8">
+ <join column="IDENTIFIER"/>
+ <element column="SIMPINTREF"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfString9" table="SET_OF_STRING9">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfString10" table="SET_OF_STRING10">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfString11" table="SET_OF_STRING11">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfDate12" table="SET_OF_DATE12">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfDate13" table="SET_OF_DATE13">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfDate14" table="SET_OF_DATE14">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfLocale15" table="SET_OF_LOCALE15">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfLocale16" table="SET_OF_LOCALE16">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfLocale17" table="SET_OF_LOCALE17">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfBigDecimal18" table="SET_OF_BIG_DECIMAL18">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfBigDecimal19" table="SET_OF_BIG_DECIMAL19">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfBigDecimal20" table="SET_OF_BIG_DECIMAL20">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfBigInteger21" table="SET_OF_BIG_INTEGER21">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfBigInteger22" table="SET_OF_BIG_INTEGER22">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfBigInteger23" table="SET_OF_BIG_INTEGER23">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfByte24" table="SET_OF_BYTE24">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfByte25" table="SET_OF_BYTE25">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfByte26" table="SET_OF_BYTE27">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfDouble27" table="SET_OF_DOUBLE27">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfDouble28" table="SET_OF_DOUBLE28">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfDouble29" table="SET_OF_DOUBLE29">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfFloat30" table="SET_OF_FLOAT30">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfFloat31" table="SET_OF_FLOAT31">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfFloat32" table="SET_OF_FLOAT32">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfInteger33" table="SET_OF_INTEGER33">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfInteger34" table="SET_OF_INTEGER34">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfInteger35" table="SET_OF_INTEGER35">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfLong36" table="SET_OF_LONG36">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfLong37" table="SET_OF_LONG37">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfLong38" table="SET_OF_LONG38">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfShort39" table="SET_OF_SHORT39">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfShort40" table="SET_OF_SHORT40">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ <order column="INDEX"/>
+ </field>
+ <field name="SetOfShort41" table="SET_OF_SHORT41">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ <order column="INDEX"/>
+ </field>
+ </class>
+ </package>
+</orm>
Propchange:
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
------------------------------------------------------------------------------
svn:executable = *
Modified:
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
URL:
http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm?rev=168361&r1=168360&r2=168361&view=diff
==============================================================================
---
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
(original)
+++
incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
Thu May 5 10:49:08 2005
@@ -17,8 +17,12 @@
<class name="PCRect" table="PCRect">
<field name="id" column="ID" primary-key="true"/>
- <field name="lowerRight" column="LOWER_RIGHT" foreign-key="true"/>
- <field name="upperLeft" column="UPPER_LEFT" foreign-key="true"/>
+ <field name="lowerRight" column="LOWER_RIGHT">
+ <foreign-key/>
+ </field>
+ <field name="upperLeft" column="UPPER_LEFT">
+ <foreign-key/>
+ </field>
</class>
<class name="PrimitiveTypes" table="PrimitiveTypes">
Modified:
incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
URL:
http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm?rev=168361&r1=168360&r2=168361&view=diff
==============================================================================
---
incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
(original)
+++
incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
Thu May 5 10:49:08 2005
@@ -17,8 +17,12 @@
<class name="PCRect" table="PCRect">
<datastore-identity strategy="identity" column="ID"/>
- <field name="lowerRight" column="LOWER_RIGHT" foreign-key="true"/>
- <field name="upperLeft" column="UPPER_LEFT" foreign-key="true"/>
+ <field name="lowerRight" column="LOWER_RIGHT">
+ <foreign-key/>
+ </field>
+ <field name="upperLeft" column="UPPER_LEFT">
+ <foreign-key/>
+ </field>
</class>
<class name="PrimitiveTypes" table="PrimitiveTypes">
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=168361&r1=168360&r2=168361&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Thu May 5 10:49:08
2005
@@ -6,9 +6,9 @@
-- mylib
-------------------------
+DROP TABLE PCRect;
DROP TABLE PCPoint;
DROP TABLE PCPoint2;
-DROP TABLE PCRect;
DROP TABLE PrimitiveTypes;
CREATE TABLE PCPoint (
@@ -62,6 +62,7 @@
-- company
-------------------------
+ALTER TABLE departments DROP CONSTRAINT EMP_MO_FK;
DROP TABLE insuranceplans;
DROP TABLE project_reviewer;
DROP TABLE project_member;
@@ -157,32 +158,6 @@
--fieldtypes
-------------------------
-DROP TABLE SIMPLE_CLASS;
-DROP TABLE FIELDSOFSIMPLECLASS;
-DROP TABLE FieldsOfByte;
-DROP TABLE FIELDSOFBIGDECIMAL;
-DROP TABLE FIELDSOFBIGINTEGER;
-DROP TABLE FIELDSOFBOOLEAN;
-DROP TABLE FIELDSOFCHARACTER;
-DROP TABLE FIELDSOFDATE;
-DROP TABLE FIELDSOFDOUBLE;
-DROP TABLE FIELDSOFFLOAT;
-DROP TABLE FIELDSOFINTEGER;
-DROP TABLE FIELDSOFLOCALE;
-DROP TABLE FIELDSOFLONG;
-DROP TABLE FIELDSOFOBJECT;
-DROP TABLE FIELDSOFPRIMITIVEBOOLEAN;
-DROP TABLE FIELDSOFPRIMITIVEBYTE;
-DROP TABLE FIELDSOFPRIMITIVECHAR;
-DROP TABLE FIELDSOFPRIMITIVEDOUBLE;
-DROP TABLE FIELDSOFPRIMITIVEFLOAT;
-DROP TABLE FIELDSOFPRIMITIVEINT;
-DROP TABLE FIELDSOFPRIMITIVELONG;
-DROP TABLE FIELDSOFPRIMITIVESHORT;
-DROP TABLE FIELDSOFSHORT;
-DROP TABLE FIELDSOFSTRING;
-DROP TABLE ARRAY_COLLECTIONS;
-DROP TABLE COLLECTION_COLLECTIONS;
DROP TABLE COLLECTION_OF_OBJECT0;
DROP TABLE COLLECTION_OF_OBJECT1;
DROP TABLE COLLECTION_OF_SIMPLE_CLASS2;
@@ -211,7 +186,121 @@
DROP TABLE COLLECTION_OF_LONG25;
DROP TABLE COLLECTION_OF_SHORT26;
DROP TABLE COLLECTION_OF_SHORT27;
+DROP TABLE COLLECTION_COLLECTIONS;
+DROP TABLE LIST_OF_OBJECT0;
+DROP TABLE LIST_OF_OBJECT1;
+DROP TABLE LIST_OF_OBJECT2;
+DROP TABLE LIST_OF_SIMPLE_CLASS3;
+DROP TABLE LIST_OF_SIMPLE_CLASS4;
+DROP TABLE LIST_OF_SIMPLE_CLASS5;
+DROP TABLE LIST_OF_SIMPLE_INTERFACE6;
+DROP TABLE LIST_OF_SIMPLE_INTERFACE7;
+DROP TABLE LIST_OF_SIMPLE_INTERFACE8;
+DROP TABLE LIST_OF_STRING9;
+DROP TABLE LIST_OF_STRING10;
+DROP TABLE LIST_OF_STRING11;
+DROP TABLE LIST_OF_DATE12;
+DROP TABLE LIST_OF_DATE13;
+DROP TABLE LIST_OF_DATE14;
+DROP TABLE LIST_OF_LOCALE15;
+DROP TABLE LIST_OF_LOCALE16;
+DROP TABLE LIST_OF_LOCALE17;
+DROP TABLE LIST_OF_BIG_DECIMAL18;
+DROP TABLE LIST_OF_BIG_DECIMAL19;
+DROP TABLE LIST_OF_BIG_DECIMAL20;
+DROP TABLE LIST_OF_BIG_INTEGER21;
+DROP TABLE LIST_OF_BIG_INTEGER22;
+DROP TABLE LIST_OF_BIG_INTEGER23;
+DROP TABLE LIST_OF_BYTE24;
+DROP TABLE LIST_OF_BYTE25;
+DROP TABLE LIST_OF_BYTE26;
+DROP TABLE LIST_OF_DOUBLE27;
+DROP TABLE LIST_OF_DOUBLE28;
+DROP TABLE LIST_OF_DOUBLE29;
+DROP TABLE LIST_OF_FLOAT30;
+DROP TABLE LIST_OF_FLOAT31;
+DROP TABLE LIST_OF_FLOAT32;
+DROP TABLE LIST_OF_INTEGER33;
+DROP TABLE LIST_OF_INTEGER34;
+DROP TABLE LIST_OF_INTEGER35;
+DROP TABLE LIST_OF_LONG36;
+DROP TABLE LIST_OF_LONG37;
+DROP TABLE LIST_OF_LONG38;
+DROP TABLE LIST_OF_SHORT39;
+DROP TABLE LIST_OF_SHORT40;
+DROP TABLE LIST_OF_SHORT41;
+DROP TABLE LIST_COLLECTIONS;
+
+DROP TABLE SET_OF_OBJECT0;
+DROP TABLE SET_OF_OBJECT1;
+DROP TABLE SET_OF_OBJECT2;
+DROP TABLE SET_OF_SIMPLE_CLASS3;
+DROP TABLE SET_OF_SIMPLE_CLASS4;
+DROP TABLE SET_OF_SIMPLE_CLASS5;
+DROP TABLE SET_OF_SIMPLE_INTERFACE6;
+DROP TABLE SET_OF_SIMPLE_INTERFACE7;
+DROP TABLE SET_OF_SIMPLE_INTERFACE8;
+DROP TABLE SET_OF_STRING9;
+DROP TABLE SET_OF_STRING10;
+DROP TABLE SET_OF_STRING11;
+DROP TABLE SET_OF_DATE12;
+DROP TABLE SET_OF_DATE13;
+DROP TABLE SET_OF_DATE14;
+DROP TABLE SET_OF_LOCALE15;
+DROP TABLE SET_OF_LOCALE16;
+DROP TABLE SET_OF_LOCALE17;
+DROP TABLE SET_OF_BIG_DECIMAL18;
+DROP TABLE SET_OF_BIG_DECIMAL19;
+DROP TABLE SET_OF_BIG_DECIMAL20;
+DROP TABLE SET_OF_BIG_INTEGER21;
+DROP TABLE SET_OF_BIG_INTEGER22;
+DROP TABLE SET_OF_BIG_INTEGER23;
+DROP TABLE SET_OF_BYTE24;
+DROP TABLE SET_OF_BYTE25;
+DROP TABLE SET_OF_BYTE26;
+DROP TABLE SET_OF_DOUBLE27;
+DROP TABLE SET_OF_DOUBLE28;
+DROP TABLE SET_OF_DOUBLE29;
+DROP TABLE SET_OF_FLOAT30;
+DROP TABLE SET_OF_FLOAT31;
+DROP TABLE SET_OF_FLOAT32;
+DROP TABLE SET_OF_INTEGER33;
+DROP TABLE SET_OF_INTEGER34;
+DROP TABLE SET_OF_INTEGER35;
+DROP TABLE SET_OF_LONG36;
+DROP TABLE SET_OF_LONG37;
+DROP TABLE SET_OF_LONG38;
+DROP TABLE SET_OF_SHORT39;
+DROP TABLE SET_OF_SHORT40;
+DROP TABLE SET_OF_SHORT41;
+DROP TABLE SET_COLLECTIONS;
+
+DROP TABLE FIELDSOFSIMPLECLASS;
+DROP TABLE SIMPLE_CLASS;
+DROP TABLE FIELDSOFBYTE;
+DROP TABLE FIELDSOFBIGDECIMAL;
+DROP TABLE FIELDSOFBIGINTEGER;
+DROP TABLE FIELDSOFBOOLEAN;
+DROP TABLE FIELDSOFCHARACTER;
+DROP TABLE FIELDSOFDATE;
+DROP TABLE FIELDSOFDOUBLE;
+DROP TABLE FIELDSOFFLOAT;
+DROP TABLE FIELDSOFINTEGER;
+DROP TABLE FIELDSOFLOCALE;
+DROP TABLE FIELDSOFLONG;
+DROP TABLE FIELDSOFOBJECT;
+DROP TABLE FIELDSOFPRIMITIVEBOOLEAN;
+DROP TABLE FIELDSOFPRIMITIVEBYTE;
+DROP TABLE FIELDSOFPRIMITIVECHAR;
+DROP TABLE FIELDSOFPRIMITIVEDOUBLE;
+DROP TABLE FIELDSOFPRIMITIVEFLOAT;
+DROP TABLE FIELDSOFPRIMITIVEINT;
+DROP TABLE FIELDSOFPRIMITIVELONG;
+DROP TABLE FIELDSOFPRIMITIVESHORT;
+DROP TABLE FIELDSOFSHORT;
+DROP TABLE FIELDSOFSTRING;
+DROP TABLE ARRAY_COLLECTIONS;
CREATE TABLE FIELDSOFBIGDECIMAL
(
@@ -2092,7 +2181,6 @@
--CollectionCollections
-
CREATE TABLE COLLECTION_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
@@ -2265,6 +2353,610 @@
(
IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
SHORTVAL SMALLINT
+);
+
+--ListCollections
+
+
+CREATE TABLE LIST_COLLECTIONS
+(
+ IDENTIFIER INTEGER NOT NULL,
+ CONSTRAINT LC_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE LIST_OF_OBJECT0
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_OBJECT1
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_OBJECT2
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_CLASS3
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_CLASS4
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_CLASS5
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_INTERFACE6
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_INTERFACE7
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_INTERFACE8
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_STRING9
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_STRING10
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_STRING11
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DATE12
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DATE13
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DATE14
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LOCALE15
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LOCALE16
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LOCALE17
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_DECIMAL18
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_DECIMAL19
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_DECIMAL20
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_INTEGER21
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_INTEGER22
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_INTEGER23
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BYTE24
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BYTE25
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BYTE26
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DOUBLE27
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DOUBLE28
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DOUBLE29
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_FLOAT30
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_FLOAT31
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_FLOAT32
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_INTEGER33
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_INTEGER34
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_INTEGER35
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LONG36
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LONG37
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LONG38
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SHORT39
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SHORT40
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+CREATE TABLE LIST_OF_SHORT41
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
+--SetCollections
+
+
+CREATE TABLE SET_COLLECTIONS
+(
+ IDENTIFIER INTEGER NOT NULL,
+ CONSTRAINT SC_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE SET_OF_OBJECT0
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_OBJECT1
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_OBJECT2
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_CLASS3
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_CLASS4
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_CLASS5
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_INTERFACE6
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_INTERFACE7
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_INTERFACE8
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_STRING9
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_STRING10
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_STRING11
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DATE12
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DATE13
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DATE14
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LOCALE15
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LOCALE16
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LOCALE17
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_DECIMAL18
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_DECIMAL19
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_DECIMAL20
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_INTEGER21
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_INTEGER22
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_INTEGER23
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BYTE24
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BYTE25
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BYTE26
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DOUBLE27
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DOUBLE28
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DOUBLE29
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_FLOAT30
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_FLOAT31
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_FLOAT32
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_INTEGER33
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_INTEGER34
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_INTEGER35
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LONG36
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LONG37
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LONG38
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SHORT39
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SHORT40
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+CREATE TABLE SET_OF_SHORT41
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER NOT NULL
);
-------------------------
