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/06/27 23:18:07 UTC
svn commit: r202081 [2/3] - in /incubator/jdo/trunk/tck20/test:
orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/
orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/
sql/derby/applicationidentity/ sql/derby/datastoreidentity/
Modified: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm?rev=202081&r1=202080&r2=202081&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm (original)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm Mon Jun 27 14:18:06 2005
@@ -50,7 +50,10 @@
<element column="SIMPINTREF"/>
<order column="INDEX"/>
</field>
- <field name="ListOfString9" column="LIST_OF_STRING9">
+ <field name="ListOfString9" table="LIST_OF_STRING9">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfString10" column="LIST_OF_STRING10">
</field>
@@ -59,7 +62,10 @@
<element column="STRINGVAL"/>
<order column="INDEX"/>
</field>
- <field name="ListOfDate12" column="LIST_OF_DATE12">
+ <field name="ListOfDate12" table="LIST_OF_DATE12">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfDate13" column="LIST_OF_DATE13">
</field>
@@ -68,7 +74,10 @@
<element column="DATEVAL"/>
<order column="INDEX"/>
</field>
- <field name="ListOfLocale15" column="LIST_OF_LOCALE15">
+ <field name="ListOfLocale15" table="LIST_OF_LOCALE15">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfLocale16" column="LIST_OF_LOCALE16">
</field>
@@ -77,7 +86,10 @@
<element column="LOCALEVAL"/>
<order column="INDEX"/>
</field>
- <field name="ListOfBigDecimal18" column="LIST_OF_BIG_DECIMAL18">
+ <field name="ListOfBigDecimal18" table="LIST_OF_BIG_DECIMAL18">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfBigDecimal19" column="LIST_OF_BIG_DECIMAL19">
</field>
@@ -86,7 +98,10 @@
<element column="BIG_DECIMALVAL"/>
<order column="INDEX"/>
</field>
- <field name="ListOfBigInteger21" column="LIST_OF_BIG_INTEGER21">
+ <field name="ListOfBigInteger21" table="LIST_OF_BIG_INTEGER21">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfBigInteger22" column="LIST_OF_BIG_INTEGER22">
</field>
@@ -95,7 +110,10 @@
<element column="BIG_INTEGERVAL"/>
<order column="INDEX"/>
</field>
- <field name="ListOfByte24" column="LIST_OF_BYTE24">
+ <field name="ListOfByte24" table="LIST_OF_BYTE24">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfByte25" column="LIST_OF_BYTE25">
</field>
@@ -104,7 +122,10 @@
<element column="BYTEVAL"/>
<order column="INDEX"/>
</field>
- <field name="ListOfDouble27" column="LIST_OF_DOUBLE27">
+ <field name="ListOfDouble27" table="LIST_OF_DOUBLE27">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfDouble28" column="LIST_OF_DOUBLE28">
</field>
@@ -113,7 +134,10 @@
<element column="DOUBLEVAL"/>
<order column="INDEX"/>
</field>
- <field name="ListOfFloat30" column="LIST_OF_FLOAT30">
+ <field name="ListOfFloat30" table="LIST_OF_FLOAT30">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfFloat31" column="LIST_OF_FLOAT31">
</field>
@@ -122,7 +146,10 @@
<element column="FLOATVAL"/>
<order column="INDEX"/>
</field>
- <field name="ListOfInteger33" column="LIST_OF_INTEGER33">
+ <field name="ListOfInteger33" table="LIST_OF_INTEGER33">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfInteger34" column="LIST_OF_INTEGER34">
</field>
@@ -131,7 +158,10 @@
<element column="INTEGERVAL"/>
<order column="INDEX"/>
</field>
- <field name="ListOfLong36" column="LIST_OF_LONG36">
+ <field name="ListOfLong36" table="LIST_OF_LONG36">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfLong37" column="LIST_OF_LONG37">
</field>
@@ -140,7 +170,10 @@
<element column="LONGVAL"/>
<order column="INDEX"/>
</field>
- <field name="ListOfShort39" column="LIST_OF_SHORT39">
+ <field name="ListOfShort39" table="LIST_OF_SHORT39">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ <order column="INDEX"/>
</field>
<field name="ListOfShort40" column="LIST_OF_SHORT40">
</field>
Modified: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm?rev=202081&r1=202080&r2=202081&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm (original)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm Mon Jun 27 14:18:06 2005
@@ -50,7 +50,10 @@
<element column="SIMPINTREF"/>
<order column="INDEX"/>
</field>
- <field name="SetOfString9" column="SET_OF_STRING9">
+ <field name="SetOfString9" table="SET_OF_STRING9">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfString10" column="SET_OF_STRING10">
</field>
@@ -59,7 +62,10 @@
<element column="STRINGVAL"/>
<order column="INDEX"/>
</field>
- <field name="SetOfDate12" column="SET_OF_DATE12">
+ <field name="SetOfDate12" table="SET_OF_DATE12">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfDate13" column="SET_OF_DATE13">
</field>
@@ -68,7 +74,10 @@
<element column="DATEVAL"/>
<order column="INDEX"/>
</field>
- <field name="SetOfLocale15" column="SET_OF_LOCALE15">
+ <field name="SetOfLocale15" table="SET_OF_LOCALE15">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfLocale16" column="SET_OF_LOCALE16">
</field>
@@ -77,7 +86,10 @@
<element column="LOCALEVAL"/>
<order column="INDEX"/>
</field>
- <field name="SetOfBigDecimal18" column="SET_OF_BIG_DECIMAL18">
+ <field name="SetOfBigDecimal18" table="SET_OF_BIG_DECIMAL18">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfBigDecimal19" column="SET_OF_BIG_DECIMAL18">
</field>
@@ -86,7 +98,10 @@
<element column="BIG_DECIMALVAL"/>
<order column="INDEX"/>
</field>
- <field name="SetOfBigInteger21" column="SET_OF_BIG_INTEGER21">
+ <field name="SetOfBigInteger21" table="SET_OF_BIG_INTEGER21">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfBigInteger22" column="SET_OF_BIG_INTEGER22">
</field>
@@ -95,7 +110,10 @@
<element column="BIG_INTEGERVAL"/>
<order column="INDEX"/>
</field>
- <field name="SetOfByte24" column="SET_OF_BYTE24">
+ <field name="SetOfByte24" table="SET_OF_BYTE24">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfByte25" column="SET_OF_BYTE25">
</field>
@@ -104,7 +122,10 @@
<element column="BYTEVAL"/>
<order column="INDEX"/>
</field>
- <field name="SetOfDouble27" column="SET_OF_DOUBLE27">
+ <field name="SetOfDouble27" table="SET_OF_DOUBLE27">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfDouble28" column="SET_OF_DOUBLE28">
</field>
@@ -113,7 +134,10 @@
<element column="DOUBLEVAL"/>
<order column="INDEX"/>
</field>
- <field name="SetOfFloat30" column="SET_OF_FLOAT30">
+ <field name="SetOfFloat30" table="SET_OF_FLOAT30">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfFloat31" column="SET_OF_FLOAT31">
</field>
@@ -122,7 +146,10 @@
<element column="FLOATVAL"/>
<order column="INDEX"/>
</field>
- <field name="SetOfInteger33" column="SET_OF_INTEGER33">
+ <field name="SetOfInteger33" table="SET_OF_INTEGER33">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfInteger34" column="SET_OF_INTEGER34">
</field>
@@ -131,7 +158,10 @@
<element column="INTEGERVAL"/>
<order column="INDEX"/>
</field>
- <field name="SetOfLong36" column="SET_OF_LONG36">
+ <field name="SetOfLong36" table="SET_OF_LONG36">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfLong37" column="SET_OF_LONG37">
</field>
@@ -140,7 +170,10 @@
<element column="LONGVAL"/>
<order column="INDEX"/>
</field>
- <field name="SetOfShort39" column="SET_OF_SHORT39">
+ <field name="SetOfShort39" table="SET_OF_SHORT39">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ <order column="INDEX"/>
</field>
<field name="SetOfShort40" column="SET_OF_SHORT40">
</field>
Modified: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/TreeSetCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/TreeSetCollections-derby.orm?rev=202081&r1=202080&r2=202081&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/TreeSetCollections-derby.orm (original)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/TreeSetCollections-derby.orm Mon Jun 27 14:18:06 2005
@@ -50,7 +50,10 @@
<element column="SIMPINTREF"/>
<order column="INDEX"/>
</field>
- <field name="TreeSetOfString9" column="TREESET_OF_STRING9">
+ <field name="TreeSetOfString9" table="TREESET_OF_STRING9">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ <order column="INDEX"/>
</field>
<field name="TreeSetOfString10" column="TREESET_OF_STRING10">
</field>
@@ -59,7 +62,10 @@
<element column="STRINGVAL"/>
<order column="INDEX"/>
</field>
- <field name="TreeSetOfDate12" column="TREESET_OF_DATE12">
+ <field name="TreeSetOfDate12" table="TREESET_OF_DATE12">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="TreeSetOfDate13" column="TREESET_OF_DATE13">
</field>
@@ -68,7 +74,10 @@
<element column="DATEVAL"/>
<order column="INDEX"/>
</field>
- <field name="TreeSetOfBigDecimal15" column="TREESET_OF_BIG_DECIMAL15">
+ <field name="TreeSetOfBigDecimal15" table="TREESET_OF_BIG_DECIMAL15">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ <order column="INDEX"/>
</field>
<field name="TreeSetOfBigDecimal16" column="TREESET_OF_BIG_DECIMAL16">
</field>
@@ -77,7 +86,10 @@
<element column="BIG_DECIMALVAL"/>
<order column="INDEX"/>
</field>
- <field name="TreeSetOfBigInteger18" column="TREESET_OF_BIG_INTEGER18">
+ <field name="TreeSetOfBigInteger18" table="TREESET_OF_BIG_INTEGER18">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ <order column="INDEX"/>
</field>
<field name="TreeSetOfBigInteger19" column="TREESET_OF_BIG_INTEGER19">
</field>
@@ -86,7 +98,10 @@
<element column="BIG_INTEGERVAL"/>
<order column="INDEX"/>
</field>
- <field name="TreeSetOfByte21" column="TREESET_OF_BYTE21">
+ <field name="TreeSetOfByte21" table="TREESET_OF_BYTE21">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="TreeSetOfByte22" column="TREESET_OF_BYTE22">
</field>
@@ -95,7 +110,10 @@
<element column="BYTEVAL"/>
<order column="INDEX"/>
</field>
- <field name="TreeSetOfDouble24" column="TREESET_OF_DOUBLE24">
+ <field name="TreeSetOfDouble24" table="TREESET_OF_DOUBLE24">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="TreeSetOfDouble25" column="TREESET_OF_DOUBLE25">
</field>
@@ -104,7 +122,10 @@
<element column="DOUBLEVAL"/>
<order column="INDEX"/>
</field>
- <field name="TreeSetOfFloat27" column="TREESET_OF_FLOAT27">
+ <field name="TreeSetOfFloat27" table="TREESET_OF_FLOAT27">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ <order column="INDEX"/>
</field>
<field name="TreeSetOfFloat28" column="TREESET_OF_FLOAT28">
</field>
@@ -113,7 +134,10 @@
<element column="FLOATVAL"/>
<order column="INDEX"/>
</field>
- <field name="TreeSetOfInteger30" column="TREESET_OF_INTEGER30">
+ <field name="TreeSetOfInteger30" table="TREESET_OF_INTEGER30">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ <order column="INDEX"/>
</field>
<field name="TreeSetOfInteger31" column="TREESET_OF_INTEGER31">
</field>
@@ -122,7 +146,10 @@
<element column="INTEGERVAL"/>
<order column="INDEX"/>
</field>
- <field name="TreeSetOfLong33" column="TREESET_OF_LONG33">
+ <field name="TreeSetOfLong33" table="TREESET_OF_LONG33">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ <order column="INDEX"/>
</field>
<field name="TreeSetOfLong34" column="TREESET_OF_LONG34">
</field>
@@ -131,7 +158,10 @@
<element column="LONGVAL"/>
<order column="INDEX"/>
</field>
- <field name="TreeSetOfShort36" column="TREESET_OF_SHORT36">
+ <field name="TreeSetOfShort36" table="TREESET_OF_SHORT36">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ <order column="INDEX"/>
</field>
<field name="TreeSetOfShort37" column="TREESET_OF_SHORT37">
</field>
Modified: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/VectorCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/VectorCollections-derby.orm?rev=202081&r1=202080&r2=202081&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/VectorCollections-derby.orm (original)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/VectorCollections-derby.orm Mon Jun 27 14:18:06 2005
@@ -50,7 +50,10 @@
<element column="SIMPINTREF"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfString9" column="VECTOR_OF_STRING9">
+ <field name="VectorOfString9" table="VECTOR_OF_STRING9">
+ <join column="IDENTIFIER"/>
+ <element column="STRINGVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfString10" column="VECTOR_OF_STRING10">
</field>
@@ -59,7 +62,10 @@
<element column="STRINGVAL"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfDate12" column="VECTOR_OF_DATE12">
+ <field name="VectorOfDate12" table="VECTOR_OF_DATE12">
+ <join column="IDENTIFIER"/>
+ <element column="DATEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfDate13" column="VECTOR_OF_DATE13">
</field>
@@ -68,7 +74,10 @@
<element column="DATEVAL"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfLocale15" column="VECTOR_OF_LOCALE15">
+ <field name="VectorOfLocale15" table="VECTOR_OF_LOCALE15">
+ <join column="IDENTIFIER"/>
+ <element column="LOCALEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfLocale16" column="VECTOR_OF_LOCALE16">
</field>
@@ -77,7 +86,10 @@
<element column="LOCALEVAL"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfBigDecimal18" column="VECTOR_OF_BIG_DECIMAL18">
+ <field name="VectorOfBigDecimal18" table="VECTOR_OF_BIG_DECIMAL18">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_DECIMALVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfBigDecimal19" column="VECTOR_OF_BIG_DECIMAL19">
</field>
@@ -86,7 +98,10 @@
<element column="BIG_DECIMALVAL"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfBigInteger21" column="VECTOR_OF_BIG_INTEGER21">
+ <field name="VectorOfBigInteger21" table="VECTOR_OF_BIG_INTEGER21">
+ <join column="IDENTIFIER"/>
+ <element column="BIG_INTEGERVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfBigInteger22" column="VECTOR_OF_BIG_INTEGER22">
</field>
@@ -95,7 +110,10 @@
<element column="BIG_INTEGERVAL"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfByte24" column="VECTOR_OF_BYTE24">
+ <field name="VectorOfByte24" table="VECTOR_OF_BYTE24">
+ <join column="IDENTIFIER"/>
+ <element column="BYTEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfByte25" column="VECTOR_OF_BYTE25">
</field>
@@ -104,7 +122,10 @@
<element column="BYTEVAL"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfDouble27" column="VECTOR_OF_DOUBLE27">
+ <field name="VectorOfDouble27" table="VECTOR_OF_DOUBLE27">
+ <join column="IDENTIFIER"/>
+ <element column="DOUBLEVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfDouble28" column="VECTOR_OF_DOUBLE28">
</field>
@@ -113,7 +134,10 @@
<element column="DOUBLEVAL"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfFloat30" column="VECTOR_OF_FLOAT30">
+ <field name="VectorOfFloat30" table="VECTOR_OF_FLOAT30">
+ <join column="IDENTIFIER"/>
+ <element column="FLOATVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfFloat31" column="VECTOR_OF_FLOAT31">
</field>
@@ -122,7 +146,10 @@
<element column="FLOATVAL"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfInteger33" column="VECTOR_OF_INTEGER33">
+ <field name="VectorOfInteger33" table="VECTOR_OF_INTEGER33">
+ <join column="IDENTIFIER"/>
+ <element column="INTEGERVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfInteger34" column="VECTOR_OF_INTEGER34">
</field>
@@ -131,7 +158,10 @@
<element column="INTEGERVAL"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfLong36" column="VECTOR_OF_LONG36">
+ <field name="VectorOfLong36" table="VECTOR_OF_LONG36">
+ <join column="IDENTIFIER"/>
+ <element column="LONGVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfLong37" column="VECTOR_OF_LONG37">
</field>
@@ -140,7 +170,10 @@
<element column="LONGVAL"/>
<order column="INDEX"/>
</field>
- <field name="VectorOfShort39" column="VECTOR_OF_SHORT39">
+ <field name="VectorOfShort39" table="VECTOR_OF_SHORT39">
+ <join column="IDENTIFIER"/>
+ <element column="SHORTVAL"/>
+ <order column="INDEX"/>
</field>
<field name="VectorOfShort40" column="VECTOR_OF_SHORT40">
</field>
Modified: incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql?rev=202081&r1=202080&r2=202081&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql Mon Jun 27 14:18:06 2005
@@ -172,16 +172,27 @@
DROP TABLE ARRAYLIST_OF_SIMPLE_INTERFACE6;
DROP TABLE ARRAYLIST_OF_SIMPLE_INTERFACE7;
DROP TABLE ARRAYLIST_OF_SIMPLE_INTERFACE8;
+DROP TABLE ARRAYLIST_OF_STRING9;
DROP TABLE ARRAYLIST_OF_STRING11;
+DROP TABLE ARRAYLIST_OF_DATE12;
DROP TABLE ARRAYLIST_OF_DATE14;
+DROP TABLE ARRAYLIST_OF_LOCALE15;
DROP TABLE ARRAYLIST_OF_LOCALE17;
+DROP TABLE ARRAYLIST_OF_BIG_DECIMAL18;
DROP TABLE ARRAYLIST_OF_BIG_DECIMAL20;
+DROP TABLE ARRAYLIST_OF_BIG_INTEGER21;
DROP TABLE ARRAYLIST_OF_BIG_INTEGER23;
+DROP TABLE ARRAYLIST_OF_BYTE24;
DROP TABLE ARRAYLIST_OF_BYTE26;
+DROP TABLE ARRAYLIST_OF_DOUBLE27;
DROP TABLE ARRAYLIST_OF_DOUBLE29;
+DROP TABLE ARRAYLIST_OF_FLOAT30;
DROP TABLE ARRAYLIST_OF_FLOAT32;
+DROP TABLE ARRAYLIST_OF_INTEGER33;
DROP TABLE ARRAYLIST_OF_INTEGER35;
+DROP TABLE ARRAYLIST_OF_LONG36;
DROP TABLE ARRAYLIST_OF_LONG38;
+DROP TABLE ARRAYLIST_OF_SHORT39;
DROP TABLE ARRAYLIST_OF_SHORT41;
DROP TABLE ARRAYLIST_COLLECTIONS;
@@ -194,16 +205,27 @@
DROP TABLE COLLECTION_OF_SIMPLE_INTERFACE6;
DROP TABLE COLLECTION_OF_SIMPLE_INTERFACE7;
DROP TABLE COLLECTION_OF_SIMPLE_INTERFACE8;
+DROP TABLE COLLECTION_OF_STRING9;
DROP TABLE COLLECTION_OF_STRING11;
+DROP TABLE COLLECTION_OF_DATE12;
DROP TABLE COLLECTION_OF_DATE14;
+DROP TABLE COLLECTION_OF_LOCALE15;
DROP TABLE COLLECTION_OF_LOCALE17;
+DROP TABLE COLLECTION_OF_BIG_DECIMAL18;
DROP TABLE COLLECTION_OF_BIG_DECIMAL20;
+DROP TABLE COLLECTION_OF_BIG_INTEGER21;
DROP TABLE COLLECTION_OF_BIG_INTEGER23;
+DROP TABLE COLLECTION_OF_BYTE24;
DROP TABLE COLLECTION_OF_BYTE26;
+DROP TABLE COLLECTION_OF_DOUBLE27;
DROP TABLE COLLECTION_OF_DOUBLE29;
+DROP TABLE COLLECTION_OF_FLOAT31;
DROP TABLE COLLECTION_OF_FLOAT32;
+DROP TABLE COLLECTION_OF_INTEGER33;
DROP TABLE COLLECTION_OF_INTEGER35;
+DROP TABLE COLLECTION_OF_LONG36;
DROP TABLE COLLECTION_OF_LONG38;
+DROP TABLE COLLECTION_OF_SHORT39;
DROP TABLE COLLECTION_OF_SHORT41;
DROP TABLE COLLECTION_COLLECTIONS;
@@ -216,16 +238,27 @@
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_STRING11;
+DROP TABLE LIST_OF_DATE12;
DROP TABLE LIST_OF_DATE14;
+DROP TABLE LIST_OF_LOCALE15;
DROP TABLE LIST_OF_LOCALE17;
+DROP TABLE LIST_OF_BIG_DECIMAL18;
DROP TABLE LIST_OF_BIG_DECIMAL20;
+DROP TABLE LIST_OF_BIG_INTEGER21;
DROP TABLE LIST_OF_BIG_INTEGER23;
+DROP TABLE LIST_OF_BYTE25;
DROP TABLE LIST_OF_BYTE26;
+DROP TABLE LIST_OF_DOUBLE27;
DROP TABLE LIST_OF_DOUBLE29;
+DROP TABLE LIST_OF_FLOAT31;
DROP TABLE LIST_OF_FLOAT32;
+DROP TABLE LIST_OF_INTEGER33;
DROP TABLE LIST_OF_INTEGER35;
+DROP TABLE LIST_OF_LONG36;
DROP TABLE LIST_OF_LONG38;
+DROP TABLE LIST_OF_SHORT39;
DROP TABLE LIST_OF_SHORT41;
DROP TABLE LIST_COLLECTIONS;
@@ -238,16 +271,27 @@
DROP TABLE LINKEDLIST_OF_SIMPLE_INTERFACE6;
DROP TABLE LINKEDLIST_OF_SIMPLE_INTERFACE7;
DROP TABLE LINKEDLIST_OF_SIMPLE_INTERFACE8;
+DROP TABLE LINKEDLIST_OF_STRING9;
DROP TABLE LINKEDLIST_OF_STRING11;
+DROP TABLE LINKEDLIST_OF_DATE12;
DROP TABLE LINKEDLIST_OF_DATE14;
+DROP TABLE LINKEDLIST_OF_LOCALE15;
DROP TABLE LINKEDLIST_OF_LOCALE17;
+DROP TABLE LINKEDLIST_OF_BIG_DECIMAL18;
DROP TABLE LINKEDLIST_OF_BIG_DECIMAL20;
+DROP TABLE LINKEDLIST_OF_BIG_INTEGER21;
DROP TABLE LINKEDLIST_OF_BIG_INTEGER23;
+DROP TABLE LINKEDLIST_OF_BYTE24;
DROP TABLE LINKEDLIST_OF_BYTE26;
+DROP TABLE LINKEDLIST_OF_DOUBLE27;
DROP TABLE LINKEDLIST_OF_DOUBLE29;
+DROP TABLE LINKEDLIST_OF_FLOAT30;
DROP TABLE LINKEDLIST_OF_FLOAT32;
+DROP TABLE LINKEDLIST_OF_INTEGER33;
DROP TABLE LINKEDLIST_OF_INTEGER35;
+DROP TABLE LINKEDLIST_OF_LONG36;
DROP TABLE LINKEDLIST_OF_LONG38;
+DROP TABLE LINKEDLIST_OF_SHORT39;
DROP TABLE LINKEDLIST_OF_SHORT41;
DROP TABLE LINKEDLIST_COLLECTIONS;
@@ -260,16 +304,27 @@
DROP TABLE VECTOR_OF_SIMPLE_INTERFACE6;
DROP TABLE VECTOR_OF_SIMPLE_INTERFACE7;
DROP TABLE VECTOR_OF_SIMPLE_INTERFACE8;
+DROP TABLE VECTOR_OF_STRING9;
DROP TABLE VECTOR_OF_STRING11;
+DROP TABLE VECTOR_OF_DATE12;
DROP TABLE VECTOR_OF_DATE14;
+DROP TABLE VECTOR_OF_LOCALE15;
DROP TABLE VECTOR_OF_LOCALE17;
+DROP TABLE VECTOR_OF_BIG_DECIMAL18;
DROP TABLE VECTOR_OF_BIG_DECIMAL20;
+DROP TABLE VECTOR_OF_BIG_INTEGER21;
DROP TABLE VECTOR_OF_BIG_INTEGER23;
+DROP TABLE VECTOR_OF_BYTE24;
DROP TABLE VECTOR_OF_BYTE26;
+DROP TABLE VECTOR_OF_DOUBLE27;
DROP TABLE VECTOR_OF_DOUBLE29;
+DROP TABLE VECTOR_OF_FLOAT31;
DROP TABLE VECTOR_OF_FLOAT32;
+DROP TABLE VECTOR_OF_INTEGER33;
DROP TABLE VECTOR_OF_INTEGER35;
+DROP TABLE VECTOR_OF_LONG36;
DROP TABLE VECTOR_OF_LONG38;
+DROP TABLE VECTOR_OF_SHORT39;
DROP TABLE VECTOR_OF_SHORT41;
DROP TABLE VECTOR_COLLECTIONS;
@@ -282,16 +337,27 @@
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_STRING11;
+DROP TABLE SET_OF_DATE12;
DROP TABLE SET_OF_DATE14;
+DROP TABLE SET_OF_LOCALE15;
DROP TABLE SET_OF_LOCALE17;
+DROP TABLE SET_OF_BIG_DECIMAL18;
DROP TABLE SET_OF_BIG_DECIMAL20;
+DROP TABLE SET_OF_BIG_INTEGER21;
DROP TABLE SET_OF_BIG_INTEGER23;
+DROP TABLE SET_OF_BYTE24;
DROP TABLE SET_OF_BYTE26;
+DROP TABLE SET_OF_DOUBLE27;
DROP TABLE SET_OF_DOUBLE29;
+DROP TABLE SET_OF_FLOAT31;
DROP TABLE SET_OF_FLOAT32;
+DROP TABLE SET_OF_INTEGER34;
DROP TABLE SET_OF_INTEGER35;
+DROP TABLE SET_OF_LONG36;
DROP TABLE SET_OF_LONG38;
+DROP TABLE SET_OF_SHORT39;
DROP TABLE SET_OF_SHORT41;
DROP TABLE SET_COLLECTIONS;
@@ -304,16 +370,27 @@
DROP TABLE HASHSET_OF_SIMPLE_INTERFACE6;
DROP TABLE HASHSET_OF_SIMPLE_INTERFACE7;
DROP TABLE HASHSET_OF_SIMPLE_INTERFACE8;
+DROP TABLE HASHSET_OF_STRING9;
DROP TABLE HASHSET_OF_STRING11;
+DROP TABLE HASHSET_OF_DATE12;
DROP TABLE HASHSET_OF_DATE14;
+DROP TABLE HASHSET_OF_LOCALE15;
DROP TABLE HASHSET_OF_LOCALE17;
+DROP TABLE HASHSET_OF_BIG_DECIMAL18;
DROP TABLE HASHSET_OF_BIG_DECIMAL20;
+DROP TABLE HASHSET_OF_BIG_INTEGER21;
DROP TABLE HASHSET_OF_BIG_INTEGER23;
+DROP TABLE HASHSET_OF_BYTE24;
DROP TABLE HASHSET_OF_BYTE26;
+DROP TABLE HASHSET_OF_DOUBLE27;
DROP TABLE HASHSET_OF_DOUBLE29;
+DROP TABLE HASHSET_OF_FLOAT30;
DROP TABLE HASHSET_OF_FLOAT32;
+DROP TABLE HASHSET_OF_INTEGER33;
DROP TABLE HASHSET_OF_INTEGER35;
+DROP TABLE HASHSET_OF_LONG36;
DROP TABLE HASHSET_OF_LONG38;
+DROP TABLE HASHSET_OF_SHORT39;
DROP TABLE HASHSET_OF_SHORT41;
DROP TABLE HASHSET_COLLECTIONS;
@@ -326,15 +403,25 @@
DROP TABLE TREESET_OF_SIMPLE_INTERFACE6;
DROP TABLE TREESET_OF_SIMPLE_INTERFACE7;
DROP TABLE TREESET_OF_SIMPLE_INTERFACE8;
+DROP TABLE TREESET_OF_STRING9;
DROP TABLE TREESET_OF_STRING11;
+DROP TABLE TREESET_OF_DATE12;
DROP TABLE TREESET_OF_DATE14;
+DROP TABLE TREESET_OF_BIG_DECIMAL15;
DROP TABLE TREESET_OF_BIG_DECIMAL17;
+DROP TABLE TREESET_OF_BIG_INTEGER18;
DROP TABLE TREESET_OF_BIG_INTEGER20;
+DROP TABLE TREESET_OF_BYTE21;
DROP TABLE TREESET_OF_BYTE23;
+DROP TABLE TREESET_OF_DOUBLE24;
DROP TABLE TREESET_OF_DOUBLE26;
+DROP TABLE TREESET_OF_FLOAT27;
DROP TABLE TREESET_OF_FLOAT29;
+DROP TABLE TREESET_OF_INTEGER30;
DROP TABLE TREESET_OF_INTEGER32;
+DROP TABLE TREESET_OF_LONG33;
DROP TABLE TREESET_OF_LONG35;
+DROP TABLE TREESET_OF_SHORT36;
DROP TABLE TREESET_OF_SHORT38;
DROP TABLE TREESET_COLLECTIONS;
@@ -713,78 +800,78 @@
CREATE TABLE FIELDSOFBIGDECIMAL
(
IDENTIFIER INTEGER NOT NULL,
- BIG_DECIMAL0 DECIMAL(11,4),
- BIG_DECIMAL1 DECIMAL(11,4),
- BIG_DECIMAL102 DECIMAL(11,4),
- BIG_DECIMAL103 DECIMAL(11,4),
- BIG_DECIMAL104 DECIMAL(11,4),
- BIG_DECIMAL108 DECIMAL(11,4),
- BIG_DECIMAL109 DECIMAL(11,4),
- BIG_DECIMAL11 DECIMAL(11,4),
- BIG_DECIMAL110 DECIMAL(11,4),
- BIG_DECIMAL112 DECIMAL(11,4),
- BIG_DECIMAL113 DECIMAL(11,4),
- BIG_DECIMAL114 DECIMAL(11,4),
- BIG_DECIMAL119 DECIMAL(11,4),
- BIG_DECIMAL12 DECIMAL(11,4),
- BIG_DECIMAL120 DECIMAL(11,4),
- BIG_DECIMAL121 DECIMAL(11,4),
- BIG_DECIMAL124 DECIMAL(11,4),
- BIG_DECIMAL125 DECIMAL(11,4),
- BIG_DECIMAL126 DECIMAL(11,4),
- BIG_DECIMAL128 DECIMAL(11,4),
- BIG_DECIMAL129 DECIMAL(11,4),
- BIG_DECIMAL13 DECIMAL(11,4),
- BIG_DECIMAL130 DECIMAL(11,4),
- BIG_DECIMAL138 DECIMAL(11,4),
- BIG_DECIMAL139 DECIMAL(11,4),
- BIG_DECIMAL140 DECIMAL(11,4),
- BIG_DECIMAL16 DECIMAL(11,4),
- BIG_DECIMAL17 DECIMAL(11,4),
- BIG_DECIMAL18 DECIMAL(11,4),
- BIG_DECIMAL2 DECIMAL(11,4),
- BIG_DECIMAL20 DECIMAL(11,4),
- BIG_DECIMAL21 DECIMAL(11,4),
- BIG_DECIMAL22 DECIMAL(11,4),
- BIG_DECIMAL30 DECIMAL(11,4),
- BIG_DECIMAL31 DECIMAL(11,4),
- BIG_DECIMAL32 DECIMAL(11,4),
- BIG_DECIMAL36 DECIMAL(11,4),
- BIG_DECIMAL37 DECIMAL(11,4),
- BIG_DECIMAL38 DECIMAL(11,4),
- BIG_DECIMAL4 DECIMAL(11,4),
- BIG_DECIMAL40 DECIMAL(11,4),
- BIG_DECIMAL41 DECIMAL(11,4),
- BIG_DECIMAL42 DECIMAL(11,4),
- BIG_DECIMAL47 DECIMAL(11,4),
- BIG_DECIMAL48 DECIMAL(11,4),
- BIG_DECIMAL49 DECIMAL(11,4),
- BIG_DECIMAL5 DECIMAL(11,4),
- BIG_DECIMAL52 DECIMAL(11,4),
- BIG_DECIMAL53 DECIMAL(11,4),
- BIG_DECIMAL54 DECIMAL(11,4),
- BIG_DECIMAL56 DECIMAL(11,4),
- BIG_DECIMAL57 DECIMAL(11,4),
- BIG_DECIMAL58 DECIMAL(11,4),
- BIG_DECIMAL6 DECIMAL(11,4),
- BIG_DECIMAL66 DECIMAL(11,4),
- BIG_DECIMAL67 DECIMAL(11,4),
- BIG_DECIMAL68 DECIMAL(11,4),
- BIG_DECIMAL72 DECIMAL(11,4),
- BIG_DECIMAL73 DECIMAL(11,4),
- BIG_DECIMAL74 DECIMAL(11,4),
- BIG_DECIMAL76 DECIMAL(11,4),
- BIG_DECIMAL77 DECIMAL(11,4),
- BIG_DECIMAL78 DECIMAL(11,4),
- BIG_DECIMAL83 DECIMAL(11,4),
- BIG_DECIMAL84 DECIMAL(11,4),
- BIG_DECIMAL85 DECIMAL(11,4),
- BIG_DECIMAL88 DECIMAL(11,4),
- BIG_DECIMAL89 DECIMAL(11,4),
- BIG_DECIMAL90 DECIMAL(11,4),
- BIG_DECIMAL92 DECIMAL(11,4),
- BIG_DECIMAL93 DECIMAL(11,4),
- BIG_DECIMAL94 DECIMAL(11,4)
+ BIG_DECIMAL0 DECIMAL(17,6),
+ BIG_DECIMAL1 DECIMAL(17,6),
+ BIG_DECIMAL102 DECIMAL(17,6),
+ BIG_DECIMAL103 DECIMAL(17,6),
+ BIG_DECIMAL104 DECIMAL(17,6),
+ BIG_DECIMAL108 DECIMAL(17,6),
+ BIG_DECIMAL109 DECIMAL(17,6),
+ BIG_DECIMAL11 DECIMAL(17,6),
+ BIG_DECIMAL110 DECIMAL(17,6),
+ BIG_DECIMAL112 DECIMAL(17,6),
+ BIG_DECIMAL113 DECIMAL(17,6),
+ BIG_DECIMAL114 DECIMAL(17,6),
+ BIG_DECIMAL119 DECIMAL(17,6),
+ BIG_DECIMAL12 DECIMAL(17,6),
+ BIG_DECIMAL120 DECIMAL(17,6),
+ BIG_DECIMAL121 DECIMAL(17,6),
+ BIG_DECIMAL124 DECIMAL(17,6),
+ BIG_DECIMAL125 DECIMAL(17,6),
+ BIG_DECIMAL126 DECIMAL(17,6),
+ BIG_DECIMAL128 DECIMAL(17,6),
+ BIG_DECIMAL129 DECIMAL(17,6),
+ BIG_DECIMAL13 DECIMAL(17,6),
+ BIG_DECIMAL130 DECIMAL(17,6),
+ BIG_DECIMAL138 DECIMAL(17,6),
+ BIG_DECIMAL139 DECIMAL(17,6),
+ BIG_DECIMAL140 DECIMAL(17,6),
+ BIG_DECIMAL16 DECIMAL(17,6),
+ BIG_DECIMAL17 DECIMAL(17,6),
+ BIG_DECIMAL18 DECIMAL(17,6),
+ BIG_DECIMAL2 DECIMAL(17,6),
+ BIG_DECIMAL20 DECIMAL(17,6),
+ BIG_DECIMAL21 DECIMAL(17,6),
+ BIG_DECIMAL22 DECIMAL(17,6),
+ BIG_DECIMAL30 DECIMAL(17,6),
+ BIG_DECIMAL31 DECIMAL(17,6),
+ BIG_DECIMAL32 DECIMAL(17,6),
+ BIG_DECIMAL36 DECIMAL(17,6),
+ BIG_DECIMAL37 DECIMAL(17,6),
+ BIG_DECIMAL38 DECIMAL(17,6),
+ BIG_DECIMAL4 DECIMAL(17,6),
+ BIG_DECIMAL40 DECIMAL(17,6),
+ BIG_DECIMAL41 DECIMAL(17,6),
+ BIG_DECIMAL42 DECIMAL(17,6),
+ BIG_DECIMAL47 DECIMAL(17,6),
+ BIG_DECIMAL48 DECIMAL(17,6),
+ BIG_DECIMAL49 DECIMAL(17,6),
+ BIG_DECIMAL5 DECIMAL(17,6),
+ BIG_DECIMAL52 DECIMAL(17,6),
+ BIG_DECIMAL53 DECIMAL(17,6),
+ BIG_DECIMAL54 DECIMAL(17,6),
+ BIG_DECIMAL56 DECIMAL(17,6),
+ BIG_DECIMAL57 DECIMAL(17,6),
+ BIG_DECIMAL58 DECIMAL(17,6),
+ BIG_DECIMAL6 DECIMAL(17,6),
+ BIG_DECIMAL66 DECIMAL(17,6),
+ BIG_DECIMAL67 DECIMAL(17,6),
+ BIG_DECIMAL68 DECIMAL(17,6),
+ BIG_DECIMAL72 DECIMAL(17,6),
+ BIG_DECIMAL73 DECIMAL(17,6),
+ BIG_DECIMAL74 DECIMAL(17,6),
+ BIG_DECIMAL76 DECIMAL(17,6),
+ BIG_DECIMAL77 DECIMAL(17,6),
+ BIG_DECIMAL78 DECIMAL(17,6),
+ BIG_DECIMAL83 DECIMAL(17,6),
+ BIG_DECIMAL84 DECIMAL(17,6),
+ BIG_DECIMAL85 DECIMAL(17,6),
+ BIG_DECIMAL88 DECIMAL(17,6),
+ BIG_DECIMAL89 DECIMAL(17,6),
+ BIG_DECIMAL90 DECIMAL(17,6),
+ BIG_DECIMAL92 DECIMAL(17,6),
+ BIG_DECIMAL93 DECIMAL(17,6),
+ BIG_DECIMAL94 DECIMAL(17,6)
);
ALTER TABLE FIELDSOFBIGDECIMAL ADD CONSTRAINT FIELDSOFBIGDPP_PK PRIMARY KEY (IDENTIFIER);
@@ -2630,32 +2717,105 @@
CREATE TABLE ARRAY_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
+ ARRAY_OF_OBJECT0 LONG VARCHAR FOR BIT DATA,
+ ARRAY_OF_SIMPLE_CLASS2 LONG VARCHAR FOR BIT DATA,
+ ARRAY_OF_SIMPLE_INTERFACE4 LONG VARCHAR FOR BIT DATA,
+ ARRAY_OF_STRING6 LONG VARCHAR FOR BIT DATA,
+ ARRAY_OF_DATE8 LONG VARCHAR FOR BIT DATA,
+ ARRAY_OF_LOCALE10 LONG VARCHAR FOR BIT DATA,
ARRAY_OF_BIG_DECIMAL12 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_BIG_DECIMAL13 LONG VARCHAR FOR BIT DATA,
ARRAY_OF_BIG_INTEGER14 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_BIG_INTEGER15 LONG VARCHAR FOR BIT DATA,
ARRAY_OF_BYTE16 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_BYTE17 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_DATE8 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_DATE9 LONG VARCHAR FOR BIT DATA,
ARRAY_OF_DOUBLE18 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_DOUBLE19 LONG VARCHAR FOR BIT DATA,
ARRAY_OF_FLOAT20 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_FLOAT21 LONG VARCHAR FOR BIT DATA,
ARRAY_OF_INTEGER22 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_INTEGER23 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_LOCALE10 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_LOCALE11 LONG VARCHAR FOR BIT DATA,
ARRAY_OF_LONG24 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_LONG25 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_OBJECT0 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_OBJECT1 LONG VARCHAR FOR BIT DATA,
ARRAY_OF_SHORT26 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_SHORT27 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_SIMPLE_INTERFACE4 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_SIMPLE_INTERFACE5 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_STRING6 LONG VARCHAR FOR BIT DATA,
- ARRAY_OF_STRING7 LONG VARCHAR FOR BIT DATA
+ CONSTRAINT AC_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE ARRAY_OF_OBJECT1
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+);
+
+CREATE TABLE ARRAY_OF_SIMPLE_CLASS3
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+);
+
+CREATE TABLE ARRAY_OF_SIMPLE_INTERFACE5
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+);
+
+CREATE TABLE ARRAY_OF_STRING7
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024)
+);
+
+CREATE TABLE ARRAY_OF_DATE9
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ DATEVAL DATE
+);
+
+CREATE TABLE ARRAY_OF_LOCALE11
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20)
+);
+
+CREATE TABLE ARRAY_OF_BIG_DECIMAL13
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL DECIMAL(17,6)
+);
+
+CREATE TABLE ARRAY_OF_BIG_INTEGER15
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT
+);
+
+CREATE TABLE ARRAY_OF_BYTE17
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT
+);
+
+CREATE TABLE ARRAY_OF_DOUBLE19
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE
+);
+
+CREATE TABLE ARRAY_OF_FLOAT21
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT
+);
+
+CREATE TABLE ARRAY_OF_INTEGER23
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER
+);
+
+CREATE TABLE ARRAY_OF_LONG25
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT
+);
+
+CREATE TABLE ARRAY_OF_SHORT27
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT
);
--CollectionCollections
@@ -2663,27 +2823,16 @@
CREATE TABLE COLLECTION_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- COLLECTION_OF_STRING9 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- COLLECTION_OF_DATE12 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- COLLECTION_OF_LOCALE15 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- COLLECTION_OF_BIG_DECIMAL18 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- COLLECTION_OF_BIG_INTEGER21 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- COLLECTION_OF_BYTE24 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- COLLECTION_OF_DOUBLE27 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- COLLECTION_OF_FLOAT30 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- COLLECTION_OF_INTEGER33 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- COLLECTION_OF_LONG36 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- COLLECTION_OF_SHORT39 LONG VARCHAR FOR BIT DATA,
COLLECTION_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
CONSTRAINT CC_PK PRIMARY KEY (IDENTIFIER)
);
@@ -2742,6 +2891,73 @@
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
+CREATE TABLE COLLECTION_OF_STRING9
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024)
+);
+
+
+CREATE TABLE COLLECTION_OF_DATE12
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ DATEVAL DATE
+);
+
+CREATE TABLE COLLECTION_OF_LOCALE15
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20)
+);
+
+CREATE TABLE COLLECTION_OF_BIG_DECIMAL18
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL DECIMAL(17,6)
+);
+
+CREATE TABLE COLLECTION_OF_BIG_INTEGER21
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT
+);
+
+CREATE TABLE COLLECTION_OF_BYTE24
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT
+);
+
+CREATE TABLE COLLECTION_OF_DOUBLE27
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE
+);
+
+CREATE TABLE COLLECTION_OF_FLOAT30
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT
+);
+
+CREATE TABLE COLLECTION_OF_INTEGER33
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER
+);
+
+CREATE TABLE COLLECTION_OF_LONG36
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT
+);
+
+CREATE TABLE COLLECTION_OF_SHORT39
+(
+ IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT
+);
+
CREATE TABLE COLLECTION_OF_STRING11
(
IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
@@ -2764,7 +2980,7 @@
CREATE TABLE COLLECTION_OF_BIG_DECIMAL20
(
IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA
+ BIG_DECIMALVAL DECIMAL(17,6)
);
CREATE TABLE COLLECTION_OF_BIG_INTEGER23
@@ -2814,27 +3030,16 @@
CREATE TABLE LIST_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- LIST_OF_STRING9 LONG VARCHAR FOR BIT DATA,
LIST_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- LIST_OF_DATE12 LONG VARCHAR FOR BIT DATA,
LIST_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- LIST_OF_LOCALE15 LONG VARCHAR FOR BIT DATA,
LIST_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- LIST_OF_BIG_DECIMAL18 LONG VARCHAR FOR BIT DATA,
LIST_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- LIST_OF_BIG_INTEGER21 LONG VARCHAR FOR BIT DATA,
LIST_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- LIST_OF_BYTE24 LONG VARCHAR FOR BIT DATA,
LIST_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- LIST_OF_DOUBLE27 LONG VARCHAR FOR BIT DATA,
LIST_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- LIST_OF_FLOAT30 LONG VARCHAR FOR BIT DATA,
LIST_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- LIST_OF_INTEGER33 LONG VARCHAR FOR BIT DATA,
LIST_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- LIST_OF_LONG36 LONG VARCHAR FOR BIT DATA,
LIST_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- LIST_OF_SHORT39 LONG VARCHAR FOR BIT DATA,
LIST_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
CONSTRAINT LC_PK PRIMARY KEY (IDENTIFIER)
);
@@ -2902,6 +3107,13 @@
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_STRING11
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
@@ -2909,6 +3121,13 @@
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_DATE14
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
@@ -2916,6 +3135,13 @@
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_LOCALE17
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
@@ -2923,10 +3149,24 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE LIST_OF_BIG_DECIMAL18
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE LIST_OF_BIG_DECIMAL20
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_INTEGER21
+(
+ IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
INDEX INTEGER NOT NULL
);
@@ -2937,6 +3177,13 @@
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,
@@ -2944,6 +3191,13 @@
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_DOUBLE29
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
@@ -2951,6 +3205,13 @@
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_FLOAT32
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
@@ -2958,6 +3219,13 @@
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_INTEGER35
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
@@ -2965,6 +3233,13 @@
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_LONG38
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
@@ -2972,6 +3247,13 @@
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_SHORT41
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
@@ -2984,27 +3266,16 @@
CREATE TABLE ARRAYLIST_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- ARRAYLIST_OF_STRING9 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- ARRAYLIST_OF_DATE12 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- ARRAYLIST_OF_LOCALE15 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- ARRAYLIST_OF_BIG_DECIMAL18 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- ARRAYLIST_OF_BIG_INTEGER21 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- ARRAYLIST_OF_BYTE24 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- ARRAYLIST_OF_DOUBLE27 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- ARRAYLIST_OF_FLOAT30 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- ARRAYLIST_OF_INTEGER33 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- ARRAYLIST_OF_LONG36 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- ARRAYLIST_OF_SHORT39 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
CONSTRAINT ALC_PK PRIMARY KEY (IDENTIFIER)
);
@@ -3096,7 +3367,7 @@
CREATE TABLE ARRAYLIST_OF_BIG_DECIMAL20
(
IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ BIG_DECIMALVAL DECIMAL(17,6),
INDEX INTEGER NOT NULL
);
@@ -3149,32 +3420,98 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE ARRAYLIST_OF_STRING9
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_DATE12
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_LOCALE15
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_BIG_DECIMAL18
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_BIG_INTEGER21
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_BYTE24
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_DOUBLE27
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_FLOAT30
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_INTEGER33
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_LONG36
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SHORT39
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
--LinkedListCollections
CREATE TABLE LINKEDLIST_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- LINKEDLIST_OF_STRING9 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_DATE12 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_LOCALE15 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_BIG_DECIMAL18 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_BIG_INTEGER21 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_BYTE24 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_DOUBLE27 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_FLOAT30 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_INTEGER33 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_LONG36 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_SHORT39 LONG VARCHAR FOR BIT DATA,
LINKEDLIST_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
CONSTRAINT LLC_PK PRIMARY KEY (IDENTIFIER)
);
@@ -3242,31 +3579,66 @@
INDEX INTEGER NOT NULL
);
-CREATE TABLE LINKEDLIST_OF_STRING11
+CREATE TABLE LINKEDLIST_OF_STRING9
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
STRINGVAL VARCHAR(1024),
INDEX INTEGER NOT NULL
);
-CREATE TABLE LINKEDLIST_OF_DATE14
+CREATE TABLE LINKEDLIST_OF_STRING11
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- DATEVAL DATE,
+ STRINGVAL VARCHAR(1024),
INDEX INTEGER NOT NULL
);
-CREATE TABLE LINKEDLIST_OF_LOCALE17
+CREATE TABLE LINKEDLIST_OF_DATE12
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LINKEDLIST_OF_DATE14
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LINKEDLIST_OF_LOCALE15
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
LOCALEVAL CHAR(20),
INDEX INTEGER NOT NULL
);
+CREATE TABLE LINKEDLIST_OF_LOCALE17
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LINKEDLIST_OF_BIG_DECIMAL18
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE LINKEDLIST_OF_BIG_DECIMAL20
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LINKEDLIST_OF_BIG_INTEGER21
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
INDEX INTEGER NOT NULL
);
@@ -3277,6 +3649,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE LINKEDLIST_OF_BYTE24
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE LINKEDLIST_OF_BYTE26
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
@@ -3284,6 +3663,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE LINKEDLIST_OF_DOUBLE27
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE LINKEDLIST_OF_DOUBLE29
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
@@ -3291,6 +3677,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE LINKEDLIST_OF_FLOAT30
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE LINKEDLIST_OF_FLOAT32
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
@@ -3298,6 +3691,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE LINKEDLIST_OF_INTEGER33
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE LINKEDLIST_OF_INTEGER35
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
@@ -3305,6 +3705,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE LINKEDLIST_OF_LONG36
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE LINKEDLIST_OF_LONG38
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
@@ -3312,6 +3719,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE LINKEDLIST_OF_SHORT39
+(
+ IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE LINKEDLIST_OF_SHORT41
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
@@ -3324,27 +3738,16 @@
CREATE TABLE VECTOR_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- VECTOR_OF_STRING9 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_DATE12 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_LOCALE15 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_BIG_DECIMAL18 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_BIG_INTEGER21 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_BYTE24 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_DOUBLE27 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_FLOAT30 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_INTEGER33 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_LONG36 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_SHORT39 LONG VARCHAR FOR BIT DATA,
VECTOR_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
CONSTRAINT VC_PK PRIMARY KEY (IDENTIFIER)
);
@@ -3412,6 +3815,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE VECTOR_OF_STRING9
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE VECTOR_OF_STRING11
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
@@ -3419,6 +3829,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE VECTOR_OF_DATE12
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE VECTOR_OF_DATE14
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
@@ -3426,6 +3843,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE VECTOR_OF_LOCALE15
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE VECTOR_OF_LOCALE17
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
@@ -3433,10 +3857,24 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE VECTOR_OF_BIG_DECIMAL18
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE VECTOR_OF_BIG_DECIMAL20
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE VECTOR_OF_BIG_INTEGER21
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
INDEX INTEGER NOT NULL
);
@@ -3447,6 +3885,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE VECTOR_OF_BYTE24
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE VECTOR_OF_BYTE26
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
@@ -3454,6 +3899,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE VECTOR_OF_DOUBLE27
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE VECTOR_OF_DOUBLE29
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
@@ -3461,6 +3913,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE VECTOR_OF_FLOAT30
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE VECTOR_OF_FLOAT32
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
@@ -3468,6 +3927,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE VECTOR_OF_INTEGER33
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE VECTOR_OF_INTEGER35
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
@@ -3475,6 +3941,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE VECTOR_OF_LONG36
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE VECTOR_OF_LONG38
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
@@ -3482,6 +3955,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE VECTOR_OF_SHORT39
+(
+ IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE VECTOR_OF_SHORT41
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
@@ -3494,27 +3974,16 @@
CREATE TABLE SET_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- SET_OF_STRING9 LONG VARCHAR FOR BIT DATA,
SET_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- SET_OF_DATE12 LONG VARCHAR FOR BIT DATA,
SET_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- SET_OF_LOCALE15 LONG VARCHAR FOR BIT DATA,
SET_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- SET_OF_BIG_DECIMAL18 LONG VARCHAR FOR BIT DATA,
SET_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- SET_OF_BIG_INTEGER21 LONG VARCHAR FOR BIT DATA,
SET_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- SET_OF_BYTE24 LONG VARCHAR FOR BIT DATA,
SET_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- SET_OF_DOUBLE27 LONG VARCHAR FOR BIT DATA,
SET_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- SET_OF_FLOAT30 LONG VARCHAR FOR BIT DATA,
SET_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- SET_OF_INTEGER33 LONG VARCHAR FOR BIT DATA,
SET_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- SET_OF_LONG36 LONG VARCHAR FOR BIT DATA,
SET_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- SET_OF_SHORT39 LONG VARCHAR FOR BIT DATA,
SET_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
CONSTRAINT SC_PK PRIMARY KEY (IDENTIFIER)
);
@@ -3523,133 +3992,210 @@
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE SET_OF_OBJECT1
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE SET_OF_OBJECT2
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE SET_OF_SIMPLE_CLASS3
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE SET_OF_SIMPLE_CLASS4
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE SET_OF_SIMPLE_CLASS5
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE SET_OF_SIMPLE_INTERFACE6
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE SET_OF_SIMPLE_INTERFACE7
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE SET_OF_SIMPLE_INTERFACE8
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_STRING9
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER
);
CREATE TABLE SET_OF_STRING11
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
STRINGVAL VARCHAR(1024),
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_DATE12
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER
);
CREATE TABLE SET_OF_DATE14
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
DATEVAL DATE,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_LOCALE15
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER
);
CREATE TABLE SET_OF_LOCALE17
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
LOCALEVAL CHAR(20),
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_BIG_DECIMAL18
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER
);
CREATE TABLE SET_OF_BIG_DECIMAL20
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
- INDEX INTEGER NOT NULL
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_BIG_INTEGER19
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ INDEX INTEGER
);
CREATE TABLE SET_OF_BIG_INTEGER23
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
BIG_INTEGERVAL BIGINT,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_BYTE24
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER
);
CREATE TABLE SET_OF_BYTE26
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
BYTEVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_DOUBLE27
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER
);
CREATE TABLE SET_OF_DOUBLE29
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
DOUBLEVAL DOUBLE,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_FLOAT30
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER
);
CREATE TABLE SET_OF_FLOAT32
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
FLOATVAL FLOAT,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_INTEGER33
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER
);
CREATE TABLE SET_OF_INTEGER35
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
INTEGERVAL INTEGER,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_LONG36
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER
);
CREATE TABLE SET_OF_LONG38
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
LONGVAL BIGINT,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE SET_OF_SHORT39
+(
+ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER
);
CREATE TABLE SET_OF_SHORT41
@@ -3664,27 +4210,16 @@
CREATE TABLE HASHSET_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- HASHSET_OF_STRING9 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_DATE12 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_LOCALE15 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_BIG_DECIMAL18 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_BIG_INTEGER21 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_BYTE24 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_DOUBLE27 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_FLOAT30 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_INTEGER33 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_LONG36 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_SHORT39 LONG VARCHAR FOR BIT DATA,
HASHSET_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
CONSTRAINT HSC_PK PRIMARY KEY (IDENTIFIER)
);
@@ -3693,140 +4228,217 @@
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_OBJECT1
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_OBJECT2
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_SIMPLE_CLASS3
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_SIMPLE_CLASS4
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_SIMPLE_CLASS5
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE6
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE7
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE8
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_STRING9
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_STRING11
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
STRINGVAL VARCHAR(1024),
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_DATE12
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_DATE14
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
DATEVAL DATE,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_LOCALE15
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ LOCALEVAL CHAR(20),
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_LOCALE17
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
LOCALEVAL CHAR(20),
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_BIG_DECIMAL18
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_BIG_DECIMAL20
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
- INDEX INTEGER NOT NULL
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_BIG_INTEGER21
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_BIG_INTEGER23
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
BIG_INTEGERVAL BIGINT,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_BYTE24
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_BYTE26
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
BYTEVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_DOUBLE27
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_DOUBLE29
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
DOUBLEVAL DOUBLE,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_FLOAT30
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_FLOAT32
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
FLOATVAL FLOAT,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_INTEGER33
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_INTEGER35
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
INTEGERVAL INTEGER,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_LONG36
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_LONG38
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
LONGVAL BIGINT,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
+);
+
+CREATE TABLE HASHSET_OF_SHORT39
+(
+ IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER
);
CREATE TABLE HASHSET_OF_SHORT41
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
SHORTVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ INDEX INTEGER
);
--TreeSetCollections
@@ -3834,25 +4446,15 @@
CREATE TABLE TREESET_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- TREESET_OF_STRING9 LONG VARCHAR FOR BIT DATA,
TREESET_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- TREESET_OF_DATE12 LONG VARCHAR FOR BIT DATA,
TREESET_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- TREESET_OF_BIG_DECIMAL15 LONG VARCHAR FOR BIT DATA,
TREESET_OF_BIG_DECIMAL16 LONG VARCHAR FOR BIT DATA,
- TREESET_OF_BIG_INTEGER18 LONG VARCHAR FOR BIT DATA,
TREESET_OF_BIG_INTEGER19 LONG VARCHAR FOR BIT DATA,
- TREESET_OF_BYTE21 LONG VARCHAR FOR BIT DATA,
TREESET_OF_BYTE22 LONG VARCHAR FOR BIT DATA,
- TREESET_OF_DOUBLE24 LONG VARCHAR FOR BIT DATA,
TREESET_OF_DOUBLE25 LONG VARCHAR FOR BIT DATA,
- TREESET_OF_FLOAT27 LONG VARCHAR FOR BIT DATA,
TREESET_OF_FLOAT28 LONG VARCHAR FOR BIT DATA,
- TREESET_OF_INTEGER30 LONG VARCHAR FOR BIT DATA,
TREESET_OF_INTEGER31 LONG VARCHAR FOR BIT DATA,
- TREESET_OF_LONG33 LONG VARCHAR FOR BIT DATA,
TREESET_OF_LONG34 LONG VARCHAR FOR BIT DATA,
- TREESET_OF_SHORT36 LONG VARCHAR FOR BIT DATA,
TREESET_OF_SHORT37 LONG VARCHAR FOR BIT DATA,
CONSTRAINT TSC_PK PRIMARY KEY (IDENTIFIER)
);
@@ -3920,6 +4522,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE TREESET_OF_STRING9
+(
+ IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
+ STRINGVAL VARCHAR(1024),
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE TREESET_OF_STRING11
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
@@ -3927,6 +4536,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE TREESET_OF_DATE12
+(
+ IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
+ DATEVAL DATE,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE TREESET_OF_DATE14
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
@@ -3934,10 +4550,24 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE TREESET_OF_BIG_DECIMAL15
+(
+ IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE TREESET_OF_BIG_DECIMAL17
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ BIG_DECIMALVAL DECIMAL(17,6),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE TREESET_OF_BIG_INTEGER18
+(
+ IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
+ BIG_INTEGERVAL BIGINT,
INDEX INTEGER NOT NULL
);
@@ -3948,6 +4578,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE TREESET_OF_BYTE21
+(
+ IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
+ BYTEVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE TREESET_OF_BYTE23
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
@@ -3955,6 +4592,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE TREESET_OF_DOUBLE24
+(
+ IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
+ DOUBLEVAL DOUBLE,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE TREESET_OF_DOUBLE26
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
@@ -3962,6 +4606,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE TREESET_OF_FLOAT27
+(
+ IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
+ FLOATVAL FLOAT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE TREESET_OF_FLOAT29
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
@@ -3969,6 +4620,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE TREESET_OF_INTEGER30
+(
+ IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
+ INTEGERVAL INTEGER,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE TREESET_OF_INTEGER32
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
@@ -3976,6 +4634,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE TREESET_OF_LONG33
+(
+ IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
+ LONGVAL BIGINT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE TREESET_OF_LONG35
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
@@ -3983,6 +4648,13 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE TREESET_OF_SHORT36
+(
+ IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
+ SHORTVAL SMALLINT,
+ INDEX INTEGER NOT NULL
+);
+
CREATE TABLE TREESET_OF_SHORT38
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
@@ -4331,7 +5003,7 @@
(
IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
KEYVAL INTEGER NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ BIG_DECIMALVAL DECIMAL(17,6),
INDEX INTEGER NOT NULL
);
@@ -4732,7 +5404,7 @@
(
IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
KEYVAL INTEGER NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ BIG_DECIMALVAL DECIMAL(17,6),
INDEX INTEGER NOT NULL
);
@@ -5133,7 +5805,7 @@
(
IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
KEYVAL INTEGER NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ BIG_DECIMALVAL DECIMAL(17,6),
INDEX INTEGER NOT NULL
);
@@ -5486,7 +6158,7 @@
CREATE TABLE HASHMAP_BIG_DECIMAL53_STR (
IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
VALUEVAL INTEGER NOT NULL,
- KEYVAL DECIMAL(11,4),
+ KEYVAL DECIMAL(17,6),
INDEX INTEGER NOT NULL
);
@@ -5832,7 +6504,7 @@
CREATE TABLE HASHTBL_BIG_DECIMAL53_STR (
IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
VALUEVAL INTEGER NOT NULL,
- KEYVAL DECIMAL(11,4),
+ KEYVAL DECIMAL(17,6),
INDEX INTEGER NOT NULL
);
@@ -6178,7 +6850,7 @@
CREATE TABLE TREEMAP_BIG_DECIMAL53_STR (
IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
VALUEVAL INTEGER NOT NULL,
- KEYVAL DECIMAL(11,4),
+ KEYVAL DECIMAL(17,6),
INDEX INTEGER NOT NULL
);
@@ -6524,7 +7196,7 @@
CREATE TABLE MAP_OF_BIG_DECIMAL53_STRING (
IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
VALUEVAL INTEGER NOT NULL,
- KEYVAL DECIMAL(11,4),
+ KEYVAL DECIMAL(17,6),
INDEX INTEGER NOT NULL
);
@@ -6918,7 +7590,7 @@
(
IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
KEYVAL INTEGER NOT NULL,
- BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+ BIG_DECIMALVAL DECIMAL(17,6),
INDEX INTEGER NOT NULL
);