db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject 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/
Date Mon, 27 Jun 2005 21:18:07 GMT
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
 );
 



Mime
View raw message