db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r169754 - in /incubator/jdo/trunk/tck20/test: java/org/apache/jdo/tck/ orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ sql/derby/
Date Thu, 12 May 2005 03:30:28 GMT
Author: mcaisse
Date: Wed May 11 20:30:26 2005
New Revision: 169754

URL: http://svn.apache.org/viewcvs?rev=169754&view=rev
Log:
JDO-39 (JDO_Test); JDO-8 finally complete??

Added:
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm   (with props)
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm   (with props)
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm   (with props)
    incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm   (with props)
    incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm   (with props)
    incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm   (with props)
Modified:
    incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/JDO_Test.java
    incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql
    incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql

Modified: incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/JDO_Test.java
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/JDO_Test.java?rev=169754&r1=169753&r2=169754&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/JDO_Test.java (original)
+++ incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/JDO_Test.java Wed May 11 20:30:26 2005
@@ -21,6 +21,7 @@
 import java.io.IOException;
 import java.io.InputStream;
 import java.lang.reflect.Field;
+import java.lang.Runtime;
 import java.util.Properties;
 
 import javax.jdo.JDOHelper;
@@ -150,6 +151,8 @@
         }
         finally {
             tearDown();
+            long freeMem = Runtime.getRuntime().freeMemory();
+            if (debug) logger.debug("Free memory: " + freeMem);
         }
     }
 

Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm?rev=169754&view=auto
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm (added)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm Wed May 11 20:30:26 2005
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
+<orm>
+    <package name="org.apache.jdo.tck.pc.fieldtypes">
+        <class name="AllTypes" table="ALLTYPES">
+            <field name="id" column="ID" primary-key="true"/>
+            <field name="fld_boolean" column="PRIMITIVEBOOLEAN"/>
+            <field name="fld_byte" column="PRIMITIVEBYTE"/>
+            <field name="fld_char" column="PRIMITIVECHAR"/>
+            <field name="fld_double" column="PRIMITIVEDOUBLE"/>
+            <field name="fld_float" column="PRIMITIVEFLOAT"/>
+            <field name="fld_int" column="PRIMITIVEINT"/>
+            <field name="fld_long" column="PRIMITIVELONG"/>
+            <field name="fld_short" column="PRIMITIVESHORT"/>
+            <field name="fld_Boolean" column="BOOLEANVAL"/>
+            <field name="fld_Byte" column="BYTEVAL"/>
+            <field name="fld_Character" column="CHARACTERVAL"/>
+            <field name="fld_Double" column="DOUBLEVAL"/>
+            <field name="fld_Float" column="FLOATVAL"/>
+            <field name="fld_Integer" column="INTEGERVAL"/>
+            <field name="fld_Long" column="LONGVAL"/>
+            <field name="fld_Short" column="SHORTVAL"/>
+            <field name="fld_String" column="STRINGVAL"/>
+            <field name="fld_Locale" column="LOCALEVAL"/>
+            <field name="fld_Date" column="DATEVAL"/>
+            <field name="fld_BigDecimal" column="BIGDECIMALVAL"/>
+            <field name="fld_BigInteger" column="BIGINTEGERVAL"/>
+        </class>
+    </package>
+</orm>

Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
------------------------------------------------------------------------------
    svn:executable = *

Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm?rev=169754&view=auto
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm (added)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm Wed May 11 20:30:26 2005
@@ -0,0 +1,153 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
+<orm>
+    <package name="org.apache.jdo.tck.pc.fieldtypes">
+        <class name="ArrayListCollections" table="LIST_COLLECTIONS">
+            <field name="identifier" column="IDENTIFIER" primary-key="true"/>
+            <field name="ArrayListOfObject0" table="ARRAYLIST_OF_OBJECT0">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfObject1" table="ARRAYLIST_OF_OBJECT1">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfObject2" table="ARRAYLIST_OF_OBJECT2">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleClass3" table="ARRAYLIST_OF_SIMPLE_CLASS3">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleClass4" table="ARRAYLIST_OF_SIMPLE_CLASS4">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleClass5" table="ARRAYLIST_OF_SIMPLE_CLASS5">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleInterface6" table="ARRAYLIST_OF_SIMPLE_INTERFACE6">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleInterface7" table="ARRAYLIST_OF_SIMPLE_INTERFACE7">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleInterface8" table="ARRAYLIST_OF_SIMPLE_INTERFACE8">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfString9" column="ARRAYLIST_OF_STRING9">
+            </field>
+            <field name="ArrayListOfString10" column="ARRAYLIST_OF_STRING10">
+            </field>
+            <field name="ArrayListOfString11" table="ARRAYLIST_OF_STRING11">
+                <join column="IDENTIFIER"/>
+                <element column="STRINGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfDate12" column="ARRAYLIST_OF_DATE12">
+            </field>
+            <field name="ArrayListOfDate13" column="ARRAYLIST_OF_DATE13">
+            </field>
+            <field name="ArrayListOfDate14" table="ARRAYLIST_OF_DATE14">
+                <join column="IDENTIFIER"/>
+                <element column="DATEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfLocale15" column="ARRAYLIST_OF_LOCALE15">
+            </field>
+            <field name="ArrayListOfLocale16" column="ARRAYLIST_OF_LOCALE16">
+            </field>
+            <field name="ArrayListOfLocale17" table="ARRAYLIST_OF_LOCALE17">
+                <join column="IDENTIFIER"/>
+                <element column="LOCALEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfBigDecimal18" column="ARRAYLIST_OF_BIG_DECIMAL18">
+            </field>
+            <field name="ArrayListOfBigDecimal19" column="ARRAYLIST_OF_BIG_DECIMAL19">
+            </field>
+            <field name="ArrayListOfBigDecimal20" table="ARRAYLIST_OF_BIG_DECIMAL20">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_DECIMALVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfBigInteger21" column="ARRAYLIST_OF_BIG_INTEGER21">
+            </field>
+            <field name="ArrayListOfBigInteger22" column="ARRAYLIST_OF_BIG_INTEGER22">
+            </field>
+            <field name="ArrayListOfBigInteger23" table="ARRAYLIST_OF_BIG_INTEGER23">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfByte24" column="ARRAYLIST_OF_BYTE24">
+            </field>
+            <field name="ArrayListOfByte25" column="ARRAYLIST_OF_BYTE25">
+            </field>
+            <field name="ArrayListOfByte26" table="ARRAYLIST_OF_BYTE27">
+                <join column="IDENTIFIER"/>
+                <element column="BYTEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfDouble27" column="ARRAYLIST_OF_DOUBLE27">
+            </field>
+            <field name="ArrayListOfDouble28" column="ARRAYLIST_OF_DOUBLE28">
+            </field>
+            <field name="ArrayListOfDouble29" table="ARRAYLIST_OF_DOUBLE29">
+                <join column="IDENTIFIER"/>
+                <element column="DOUBLEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfFloat30" column="ARRAYLIST_OF_FLOAT30">
+            </field>
+            <field name="ArrayListOfFloat31" column="ARRAYLIST_OF_FLOAT31">
+            </field>
+            <field name="ArrayListOfFloat32" table="ARRAYLIST_OF_FLOAT32">
+                <join column="IDENTIFIER"/>
+                <element column="FLOATVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfInteger33" column="ARRAYLIST_OF_INTEGER33">
+            </field>
+            <field name="ArrayListOfInteger34" column="ARRAYLIST_OF_INTEGER34">
+            </field>
+            <field name="ArrayListOfInteger35" table="ARRAYLIST_OF_INTEGER35">
+                <join column="IDENTIFIER"/>
+                <element column="INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfLong36" column="ARRAYLIST_OF_LONG36">
+            </field>
+            <field name="ArrayListOfLong37" column="ARRAYLIST_OF_LONG37">
+            </field>
+            <field name="ArrayListOfLong38" table="ARRAYLIST_OF_LONG38">
+                <join column="IDENTIFIER"/>
+                <element column="LONGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfShort39" column="ARRAYLIST_OF_SHORT39">
+            </field>
+            <field name="ArrayListOfShort40" column="ARRAYLIST_OF_SHORT40">
+            </field>
+            <field name="ArrayListOfShort41" table="ARRAYLIST_OF_SHORT41">
+                <join column="IDENTIFIER"/>
+                <element column="SHORTVAL"/>
+                <order column="INDEX"/>
+            </field>
+        </class>
+    </package>
+</orm>

Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm
------------------------------------------------------------------------------
    svn:executable = *

Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm?rev=169754&view=auto
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm (added)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm Wed May 11 20:30:26 2005
@@ -0,0 +1,73 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
+<orm>
+    <package name="org.apache.jdo.tck.pc.fieldtypes">
+        <class name="FieldsOfSimpleInterface" table="FIELDSOFSIMPLEINTERFACE">
+            <field name="identifier" primary-key="true" column="IDENTIFIER"/>
+            <field name="SimpleInterface1" column="SIMPLEINTERFACE1"/>
+            <field name="SimpleInterface102" column="SIMPLEINTERFACE102"/>
+            <field name="SimpleInterface103" column="SIMPLEINTERFACE103"/>
+            <field name="SimpleInterface104" column="SIMPLEINTERFACE104"/>
+            <field name="SimpleInterface109" column="SIMPLEINTERFACE109"/>
+            <field name="SimpleInterface11" column="SIMPLEINTERFACE11"/>
+            <field name="SimpleInterface110" column="SIMPLEINTERFACE110"/>
+            <field name="SimpleInterface112" column="SIMPLEINTERFACE112"/>
+            <field name="SimpleInterface113" column="SIMPLEINTERFACE113"/>
+            <field name="SimpleInterface114" column="SIMPLEINTERFACE114"/>
+            <field name="SimpleInterface119" column="SIMPLEINTERFACE119"/>
+            <field name="SimpleInterface12" column="SIMPLEINTERFACE12"/>
+            <field name="SimpleInterface120" column="SIMPLEINTERFACE120"/>
+            <field name="SimpleInterface121" column="SIMPLEINTERFACE121"/>
+            <field name="SimpleInterface125" column="SIMPLEINTERFACE125"/>
+            <field name="SimpleInterface126" column="SIMPLEINTERFACE126"/>
+            <field name="SimpleInterface128" column="SIMPLEINTERFACE128"/>
+            <field name="SimpleInterface129" column="SIMPLEINTERFACE129"/>
+            <field name="SimpleInterface13" column="SIMPLEINTERFACE13"/>
+            <field name="SimpleInterface130" column="SIMPLEINTERFACE130"/>
+            <field name="SimpleInterface138" column="SIMPLEINTERFACE138"/>
+            <field name="SimpleInterface139" column="SIMPLEINTERFACE139"/>
+            <field name="SimpleInterface140" column="SIMPLEINTERFACE140"/>
+            <field name="SimpleInterface17" column="SIMPLEINTERFACE17"/>
+            <field name="SimpleInterface18" column="SIMPLEINTERFACE18"/>
+            <field name="SimpleInterface2" column="SIMPLEINTERFACE2"/>
+            <field name="SimpleInterface20" column="SIMPLEINTERFACE20"/>
+            <field name="SimpleInterface21" column="SIMPLEINTERFACE21"/>
+            <field name="SimpleInterface22" column="SIMPLEINTERFACE22"/>
+            <field name="SimpleInterface30" column="SIMPLEINTERFACE30"/>
+            <field name="SimpleInterface31" column="SIMPLEINTERFACE31"/>
+            <field name="SimpleInterface32" column="SIMPLEINTERFACE32"/>
+            <field name="SimpleInterface37" column="SIMPLEINTERFACE37"/>
+            <field name="SimpleInterface38" column="SIMPLEINTERFACE38"/>
+            <field name="SimpleInterface4" column="SIMPLEINTERFACE4"/>
+            <field name="SimpleInterface40" column="SIMPLEINTERFACE40"/>
+            <field name="SimpleInterface41" column="SIMPLEINTERFACE41"/>
+            <field name="SimpleInterface42" column="SIMPLEINTERFACE42"/>
+            <field name="SimpleInterface47" column="SIMPLEINTERFACE47"/>
+            <field name="SimpleInterface48" column="SIMPLEINTERFACE48"/>
+            <field name="SimpleInterface49" column="SIMPLEINTERFACE49"/>
+            <field name="SimpleInterface5" column="SIMPLEINTERFACE5"/>
+            <field name="SimpleInterface53" column="SIMPLEINTERFACE53"/>
+            <field name="SimpleInterface54" column="SIMPLEINTERFACE54"/>
+            <field name="SimpleInterface56" column="SIMPLEINTERFACE56"/>
+            <field name="SimpleInterface57" column="SIMPLEINTERFACE57"/>
+            <field name="SimpleInterface58" column="SIMPLEINTERFACE58"/>
+            <field name="SimpleInterface6" column="SIMPLEINTERFACE6"/>
+            <field name="SimpleInterface66" column="SIMPLEINTERFACE66"/>
+            <field name="SimpleInterface67" column="SIMPLEINTERFACE67"/>
+            <field name="SimpleInterface68" column="SIMPLEINTERFACE68"/>
+            <field name="SimpleInterface73" column="SIMPLEINTERFACE73"/>
+            <field name="SimpleInterface74" column="SIMPLEINTERFACE74"/>
+            <field name="SimpleInterface76" column="SIMPLEINTERFACE76"/>
+            <field name="SimpleInterface77" column="SIMPLEINTERFACE77"/>
+            <field name="SimpleInterface78" column="SIMPLEINTERFACE78"/>
+            <field name="SimpleInterface83" column="SIMPLEINTERFACE83"/>
+            <field name="SimpleInterface84" column="SIMPLEINTERFACE84"/>
+            <field name="SimpleInterface85" column="SIMPLEINTERFACE85"/>
+            <field name="SimpleInterface89" column="SIMPLEINTERFACE89"/>
+            <field name="SimpleInterface90" column="SIMPLEINTERFACE90"/>
+            <field name="SimpleInterface92" column="SIMPLEINTERFACE92"/>
+            <field name="SimpleInterface93" column="SIMPLEINTERFACE93"/>
+            <field name="SimpleInterface94" column="SIMPLEINTERFACE94"/>
+        </class>
+    </package>
+</orm>

Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm
------------------------------------------------------------------------------
    svn:executable = *

Added: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm?rev=169754&view=auto
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm (added)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm Wed May 11 20:30:26 2005
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
+<orm>
+    <package name="org.apache.jdo.tck.pc.fieldtypes">
+        <class name="AllTypes" table="ALLTYPES">
+            <datastore-identity strategy="identity" column="ID"/>
+            <field name="fld_boolean" column="PRIMITIVEBOOLEAN"/>
+            <field name="fld_byte" column="PRIMITIVEBYTE"/>
+            <field name="fld_char" column="PRIMITIVECHAR"/>
+            <field name="fld_double" column="PRIMITIVEDOUBLE"/>
+            <field name="fld_float" column="PRIMITIVEFLOAT"/>
+            <field name="fld_int" column="PRIMITIVEINT"/>
+            <field name="fld_long" column="PRIMITIVELONG"/>
+            <field name="fld_short" column="PRIMITIVESHORT"/>
+            <field name="fld_Boolean" column="BOOLEANVAL"/>
+            <field name="fld_Byte" column="BYTEVAL"/>
+            <field name="fld_Character" column="CHARACTERVAL"/>
+            <field name="fld_Double" column="DOUBLEVAL"/>
+            <field name="fld_Float" column="FLOATVAL"/>
+            <field name="fld_Integer" column="INTEGERVAL"/>
+            <field name="fld_Long" column="LONGVAL"/>
+            <field name="fld_Short" column="SHORTVAL"/>
+            <field name="fld_String" column="STRINGVAL"/>
+            <field name="fld_Locale" column="LOCALEVAL"/>
+            <field name="fld_Date" column="DATEVAL"/>
+            <field name="fld_BigDecimal" column="BIGDECIMALVAL"/>
+            <field name="fld_BigInteger" column="BIGINTEGERVAL"/>
+        </class>
+    </package>
+</orm>

Propchange: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/AllTypes-derby.orm
------------------------------------------------------------------------------
    svn:executable = *

Added: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm?rev=169754&view=auto
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm (added)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm Wed May 11 20:30:26 2005
@@ -0,0 +1,153 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
+<orm>
+    <package name="org.apache.jdo.tck.pc.fieldtypes">
+        <class name="ArrayListCollections" table="LIST_COLLECTIONS">
+            <datastore-identity strategy="identity" column="IDENTIFIER"/>
+            <field name="ArrayListOfObject0" table="ARRAYLIST_OF_OBJECT0">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfObject1" table="ARRAYLIST_OF_OBJECT1">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfObject2" table="ARRAYLIST_OF_OBJECT2">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleClass3" table="ARRAYLIST_OF_SIMPLE_CLASS3">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleClass4" table="ARRAYLIST_OF_SIMPLE_CLASS4">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleClass5" table="ARRAYLIST_OF_SIMPLE_CLASS5">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleInterface6" table="ARRAYLIST_OF_SIMPLE_INTERFACE6">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleInterface7" table="ARRAYLIST_OF_SIMPLE_INTERFACE7">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfSimpleInterface8" table="ARRAYLIST_OF_SIMPLE_INTERFACE8">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfString9" column="ARRAYLIST_OF_STRING9">
+            </field>
+            <field name="ArrayListOfString10" column="ARRAYLIST_OF_STRING10">
+            </field>
+            <field name="ArrayListOfString11" table="ARRAYLIST_OF_STRING11">
+                <join column="IDENTIFIER"/>
+                <element column="STRINGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfDate12" column="ARRAYLIST_OF_DATE12">
+            </field>
+            <field name="ArrayListOfDate13" column="ARRAYLIST_OF_DATE13">
+            </field>
+            <field name="ArrayListOfDate14" table="ARRAYLIST_OF_DATE14">
+                <join column="IDENTIFIER"/>
+                <element column="DATEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfLocale15" column="ARRAYLIST_OF_LOCALE15">
+            </field>
+            <field name="ArrayListOfLocale16" column="ARRAYLIST_OF_LOCALE16">
+            </field>
+            <field name="ArrayListOfLocale17" table="ARRAYLIST_OF_LOCALE17">
+                <join column="IDENTIFIER"/>
+                <element column="LOCALEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfBigDecimal18" column="ARRAYLIST_OF_BIG_DECIMAL18">
+            </field>
+            <field name="ArrayListOfBigDecimal19" column="ARRAYLIST_OF_BIG_DECIMAL19">
+            </field>
+            <field name="ArrayListOfBigDecimal20" table="ARRAYLIST_OF_BIG_DECIMAL20">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_DECIMALVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfBigInteger21" column="ARRAYLIST_OF_BIG_INTEGER21">
+            </field>
+            <field name="ArrayListOfBigInteger22" column="ARRAYLIST_OF_BIG_INTEGER22">
+            </field>
+            <field name="ArrayListOfBigInteger23" table="ARRAYLIST_OF_BIG_INTEGER23">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfByte24" column="ARRAYLIST_OF_BYTE24">
+            </field>
+            <field name="ArrayListOfByte25" column="ARRAYLIST_OF_BYTE25">
+            </field>
+            <field name="ArrayListOfByte26" table="ARRAYLIST_OF_BYTE27">
+                <join column="IDENTIFIER"/>
+                <element column="BYTEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfDouble27" column="ARRAYLIST_OF_DOUBLE27">
+            </field>
+            <field name="ArrayListOfDouble28" column="ARRAYLIST_OF_DOUBLE28">
+            </field>
+            <field name="ArrayListOfDouble29" table="ARRAYLIST_OF_DOUBLE29">
+                <join column="IDENTIFIER"/>
+                <element column="DOUBLEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfFloat30" column="ARRAYLIST_OF_FLOAT30">
+            </field>
+            <field name="ArrayListOfFloat31" column="ARRAYLIST_OF_FLOAT31">
+            </field>
+            <field name="ArrayListOfFloat32" table="ARRAYLIST_OF_FLOAT32">
+                <join column="IDENTIFIER"/>
+                <element column="FLOATVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfInteger33" column="ARRAYLIST_OF_INTEGER33">
+            </field>
+            <field name="ArrayListOfInteger34" column="ARRAYLIST_OF_INTEGER34">
+            </field>
+            <field name="ArrayListOfInteger35" table="ARRAYLIST_OF_INTEGER35">
+                <join column="IDENTIFIER"/>
+                <element column="INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfLong36" column="ARRAYLIST_OF_LONG36">
+            </field>
+            <field name="ArrayListOfLong37" column="ARRAYLIST_OF_LONG37">
+            </field>
+            <field name="ArrayListOfLong38" table="ARRAYLIST_OF_LONG38">
+                <join column="IDENTIFIER"/>
+                <element column="LONGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ArrayListOfShort39" column="ARRAYLIST_OF_SHORT39">
+            </field>
+            <field name="ArrayListOfShort40" column="ARRAYLIST_OF_SHORT40">
+            </field>
+            <field name="ArrayListOfShort41" table="ARRAYLIST_OF_SHORT41">
+                <join column="IDENTIFIER"/>
+                <element column="SHORTVAL"/>
+                <order column="INDEX"/>
+            </field>
+        </class>
+    </package>
+</orm>

Propchange: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayListCollections-derby.orm
------------------------------------------------------------------------------
    svn:executable = *

Added: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm?rev=169754&view=auto
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm (added)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm Wed May 11 20:30:26 2005
@@ -0,0 +1,73 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
+<orm>
+    <package name="org.apache.jdo.tck.pc.fieldtypes">
+        <class name="FieldsOfSimpleInterface" table="FIELDSOFSIMPLEINTERFACE">
+            <datastore-identity strategy="identity" column="IDENTIFIER"/>
+            <field name="SimpleInterface1" column="SIMPLEINTERFACE1"/>
+            <field name="SimpleInterface102" column="SIMPLEINTERFACE102"/>
+            <field name="SimpleInterface103" column="SIMPLEINTERFACE103"/>
+            <field name="SimpleInterface104" column="SIMPLEINTERFACE104"/>
+            <field name="SimpleInterface109" column="SIMPLEINTERFACE109"/>
+            <field name="SimpleInterface11" column="SIMPLEINTERFACE11"/>
+            <field name="SimpleInterface110" column="SIMPLEINTERFACE110"/>
+            <field name="SimpleInterface112" column="SIMPLEINTERFACE112"/>
+            <field name="SimpleInterface113" column="SIMPLEINTERFACE113"/>
+            <field name="SimpleInterface114" column="SIMPLEINTERFACE114"/>
+            <field name="SimpleInterface119" column="SIMPLEINTERFACE119"/>
+            <field name="SimpleInterface12" column="SIMPLEINTERFACE12"/>
+            <field name="SimpleInterface120" column="SIMPLEINTERFACE120"/>
+            <field name="SimpleInterface121" column="SIMPLEINTERFACE121"/>
+            <field name="SimpleInterface125" column="SIMPLEINTERFACE125"/>
+            <field name="SimpleInterface126" column="SIMPLEINTERFACE126"/>
+            <field name="SimpleInterface128" column="SIMPLEINTERFACE128"/>
+            <field name="SimpleInterface129" column="SIMPLEINTERFACE129"/>
+            <field name="SimpleInterface13" column="SIMPLEINTERFACE13"/>
+            <field name="SimpleInterface130" column="SIMPLEINTERFACE130"/>
+            <field name="SimpleInterface138" column="SIMPLEINTERFACE138"/>
+            <field name="SimpleInterface139" column="SIMPLEINTERFACE139"/>
+            <field name="SimpleInterface140" column="SIMPLEINTERFACE140"/>
+            <field name="SimpleInterface17" column="SIMPLEINTERFACE17"/>
+            <field name="SimpleInterface18" column="SIMPLEINTERFACE18"/>
+            <field name="SimpleInterface2" column="SIMPLEINTERFACE2"/>
+            <field name="SimpleInterface20" column="SIMPLEINTERFACE20"/>
+            <field name="SimpleInterface21" column="SIMPLEINTERFACE21"/>
+            <field name="SimpleInterface22" column="SIMPLEINTERFACE22"/>
+            <field name="SimpleInterface30" column="SIMPLEINTERFACE30"/>
+            <field name="SimpleInterface31" column="SIMPLEINTERFACE31"/>
+            <field name="SimpleInterface32" column="SIMPLEINTERFACE32"/>
+            <field name="SimpleInterface37" column="SIMPLEINTERFACE37"/>
+            <field name="SimpleInterface38" column="SIMPLEINTERFACE38"/>
+            <field name="SimpleInterface4" column="SIMPLEINTERFACE4"/>
+            <field name="SimpleInterface40" column="SIMPLEINTERFACE40"/>
+            <field name="SimpleInterface41" column="SIMPLEINTERFACE41"/>
+            <field name="SimpleInterface42" column="SIMPLEINTERFACE42"/>
+            <field name="SimpleInterface47" column="SIMPLEINTERFACE47"/>
+            <field name="SimpleInterface48" column="SIMPLEINTERFACE48"/>
+            <field name="SimpleInterface49" column="SIMPLEINTERFACE49"/>
+            <field name="SimpleInterface5" column="SIMPLEINTERFACE5"/>
+            <field name="SimpleInterface53" column="SIMPLEINTERFACE53"/>
+            <field name="SimpleInterface54" column="SIMPLEINTERFACE54"/>
+            <field name="SimpleInterface56" column="SIMPLEINTERFACE56"/>
+            <field name="SimpleInterface57" column="SIMPLEINTERFACE57"/>
+            <field name="SimpleInterface58" column="SIMPLEINTERFACE58"/>
+            <field name="SimpleInterface6" column="SIMPLEINTERFACE6"/>
+            <field name="SimpleInterface66" column="SIMPLEINTERFACE66"/>
+            <field name="SimpleInterface67" column="SIMPLEINTERFACE67"/>
+            <field name="SimpleInterface68" column="SIMPLEINTERFACE68"/>
+            <field name="SimpleInterface73" column="SIMPLEINTERFACE73"/>
+            <field name="SimpleInterface74" column="SIMPLEINTERFACE74"/>
+            <field name="SimpleInterface76" column="SIMPLEINTERFACE76"/>
+            <field name="SimpleInterface77" column="SIMPLEINTERFACE77"/>
+            <field name="SimpleInterface78" column="SIMPLEINTERFACE78"/>
+            <field name="SimpleInterface83" column="SIMPLEINTERFACE83"/>
+            <field name="SimpleInterface84" column="SIMPLEINTERFACE84"/>
+            <field name="SimpleInterface85" column="SIMPLEINTERFACE85"/>
+            <field name="SimpleInterface89" column="SIMPLEINTERFACE89"/>
+            <field name="SimpleInterface90" column="SIMPLEINTERFACE90"/>
+            <field name="SimpleInterface92" column="SIMPLEINTERFACE92"/>
+            <field name="SimpleInterface93" column="SIMPLEINTERFACE93"/>
+            <field name="SimpleInterface94" column="SIMPLEINTERFACE94"/>
+        </class>
+    </package>
+</orm>

Propchange: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm
------------------------------------------------------------------------------
    svn:executable = *

Modified: incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql?rev=169754&r1=169753&r2=169754&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Wed May 11 20:30:26 2005
@@ -630,7 +630,7 @@
 DROP TABLE TREEMAPSTRINGVALUE_COLLECTIONS;
 
 DROP TABLE FIELDSOFSIMPLECLASS;
-DROP TABLE SIMPLE_CLASS;
+DROP TABLE ALLTYPES;
 DROP TABLE FIELDSOFBYTE;
 DROP TABLE FIELDSOFBIGDECIMAL;
 DROP TABLE FIELDSOFBIGINTEGER;
@@ -643,6 +643,7 @@
 DROP TABLE FIELDSOFLOCALE;
 DROP TABLE FIELDSOFLONG;
 DROP TABLE FIELDSOFOBJECT;
+DROP TABLE FIELDSOFSIMPLEINTERFACE;
 DROP TABLE FIELDSOFPRIMITIVEBOOLEAN;
 DROP TABLE FIELDSOFPRIMITIVEBYTE;
 DROP TABLE FIELDSOFPRIMITIVECHAR;
@@ -654,6 +655,36 @@
 DROP TABLE FIELDSOFSHORT;
 DROP TABLE FIELDSOFSTRING;
 
+DROP TABLE SIMPLE_CLASS;
+
+CREATE TABLE ALLTYPES
+(
+    ID INTEGER NOT NULL,
+    PRIMITIVEBOOLEAN CHAR(1) NOT NULL CHECK (PRIMITIVEBOOLEAN IN ('Y','N')),
+    PRIMITIVEBYTE SMALLINT NOT NULL,
+    PRIMITIVECHAR INTEGER NOT NULL,
+    PRIMITIVEDOUBLE DOUBLE NOT NULL,
+    PRIMITIVEFLOAT FLOAT NOT NULL,
+    PRIMITIVEINT INTEGER NOT NULL,
+    PRIMITIVELONG BIGINT NOT NULL,
+    PRIMITIVESHORT SMALLINT NOT NULL,
+    BOOLEANVAL CHAR(1) NOT NULL CHECK (BOOLEANVAL IN ('Y','N')),
+    BYTEVAL SMALLINT NOT NULL,
+    CHARACTERVAL CHAR(1) NOT NULL,
+    DOUBLEVAL DOUBLE NOT NULL,
+    FLOATVAL FLOAT NOT NULL,
+    INTEGERVAL INTEGER NOT NULL,
+    LONGVAL BIGINT NOT NULL,
+    SHORTVAL SMALLINT NOT NULL,
+    STRINGVAL VARCHAR(255) NOT NULL,
+    LOCALEVAL CHAR(20) NOT NULL,
+    DATEVAL DATE NOT NULL,
+    BIGDECIMALVAL DECIMAL(19),
+    BIGINTEGERVAL BIGINT
+);
+
+ALTER TABLE ALLTYPES ADD CONSTRAINT ALLTYPES_PK PRIMARY KEY (ID);
+
 CREATE TABLE FIELDSOFBIGDECIMAL
 (
     IDENTIFIER INTEGER NOT NULL,
@@ -1515,6 +1546,77 @@
 
 ALTER TABLE FIELDSOFOBJECT ADD CONSTRAINT FIELDSOFOBJECT_PK PRIMARY KEY (IDENTIFIER);
 
+CREATE TABLE FIELDSOFSIMPLEINTERFACE
+(
+    IDENTIFIER INTEGER NOT NULL,
+    SIMPLEINTERFACE1 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE102 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE103 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE104 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE109 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE11 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE110 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE112 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE113 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE114 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE119 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE12 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE120 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE121 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE125 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE126 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE128 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE129 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE13 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE130 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE138 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE139 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE140 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE17 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE18 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE2 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE20 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE21 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE22 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE30 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE31 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE32 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE37 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE38 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE4 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE40 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE41 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE42 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE47 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE48 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE49 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE5 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE53 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE54 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE56 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE57 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE58 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE6 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE66 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE67 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE68 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE73 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE74 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE76 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE77 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE78 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE83 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE84 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE85 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE89 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE90 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE92 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE93 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE94 LONG VARCHAR FOR BIT DATA
+);
+
+ALTER TABLE FIELDSOFSIMPLEINTERFACE ADD CONSTRAINT FOSI_PK PRIMARY KEY (IDENTIFIER);
+
 CREATE TABLE FIELDSOFPRIMITIVEBOOLEAN
 (
     IDENTIFIER INTEGER NOT NULL,
@@ -2848,6 +2950,176 @@
 CREATE TABLE LIST_OF_SHORT41
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    SHORTVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+--ArrayListCollections
+
+CREATE TABLE ARRAYLIST_COLLECTIONS
+(
+    IDENTIFIER INTEGER NOT NULL,
+	ARRAYLIST_OF_STRING9 BLOB,
+	ARRAYLIST_OF_STRING10 BLOB,
+	ARRAYLIST_OF_DATE12 BLOB,
+	ARRAYLIST_OF_DATE13 BLOB,
+	ARRAYLIST_OF_LOCALE15 BLOB,
+	ARRAYLIST_OF_LOCALE16 BLOB,
+	ARRAYLIST_OF_BIG_DECIMAL18 BLOB,
+	ARRAYLIST_OF_BIG_DECIMAL19 BLOB,
+	ARRAYLIST_OF_BIG_INTEGER21 BLOB,
+	ARRAYLIST_OF_BIG_INTEGER22 BLOB,
+	ARRAYLIST_OF_BYTE24 BLOB,
+	ARRAYLIST_OF_BYTE25 BLOB,
+	ARRAYLIST_OF_DOUBLE27 BLOB,
+	ARRAYLIST_OF_DOUBLE28 BLOB,
+	ARRAYLIST_OF_FLOAT30 BLOB,
+	ARRAYLIST_OF_FLOAT31 BLOB,
+	ARRAYLIST_OF_INTEGER33 BLOB,
+	ARRAYLIST_OF_INTEGER34 BLOB,
+	ARRAYLIST_OF_LONG36 BLOB,
+	ARRAYLIST_OF_LONG37 BLOB,
+	ARRAYLIST_OF_SHORT39 BLOB,
+	ARRAYLIST_OF_SHORT40 BLOB,
+    CONSTRAINT ALC_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE ARRAYLIST_OF_OBJECT0
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_OBJECT1
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_OBJECT2
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_CLASS3
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_CLASS4
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_CLASS5
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_INTERFACE6
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_INTERFACE7
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_INTERFACE8
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_STRING11
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    STRINGVAL VARCHAR(1024),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_DATE14
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    DATEVAL DATE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_LOCALE17
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    LOCALEVAL CHAR(20),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_BIG_DECIMAL20
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_BIG_INTEGER23
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    BIG_INTEGERVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_BYTE26
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    BYTEVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_DOUBLE29
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    DOUBLEVAL DOUBLE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_FLOAT32
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    FLOATVAL FLOAT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_INTEGER35
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    INTEGERVAL INTEGER,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_LONG38
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    LONGVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SHORT41
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
     SHORTVAL SMALLINT,
     INDEX INTEGER NOT NULL
 );

Modified: incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql?rev=169754&r1=169753&r2=169754&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql Wed May 11 20:30:26 2005
@@ -630,7 +630,7 @@
 DROP TABLE TREEMAPSTRINGVALUE_COLLECTIONS;
 
 DROP TABLE FIELDSOFSIMPLECLASS;
-DROP TABLE SIMPLE_CLASS;
+DROP TABLE ALLTYPES;
 DROP TABLE FIELDSOFBYTE;
 DROP TABLE FIELDSOFBIGDECIMAL;
 DROP TABLE FIELDSOFBIGINTEGER;
@@ -643,6 +643,7 @@
 DROP TABLE FIELDSOFLOCALE;
 DROP TABLE FIELDSOFLONG;
 DROP TABLE FIELDSOFOBJECT;
+DROP TABLE FIELDSOFSIMPLEINTERFACE;
 DROP TABLE FIELDSOFPRIMITIVEBOOLEAN;
 DROP TABLE FIELDSOFPRIMITIVEBYTE;
 DROP TABLE FIELDSOFPRIMITIVECHAR;
@@ -654,6 +655,36 @@
 DROP TABLE FIELDSOFSHORT;
 DROP TABLE FIELDSOFSTRING;
 
+DROP TABLE SIMPLE_CLASS;
+
+CREATE TABLE ALLTYPES
+(
+    ID INTEGER NOT NULL,
+    PRIMITIVEBOOLEAN CHAR(1) NOT NULL CHECK (PRIMITIVEBOOLEAN IN ('Y','N')),
+    PRIMITIVEBYTE SMALLINT NOT NULL,
+    PRIMITIVECHAR INTEGER NOT NULL,
+    PRIMITIVEDOUBLE DOUBLE NOT NULL,
+    PRIMITIVEFLOAT FLOAT NOT NULL,
+    PRIMITIVEINT INTEGER NOT NULL,
+    PRIMITIVELONG BIGINT NOT NULL,
+    PRIMITIVESHORT SMALLINT NOT NULL,
+    BOOLEANVAL CHAR(1) NOT NULL CHECK (BOOLEANVAL IN ('Y','N')),
+    BYTEVAL SMALLINT NOT NULL,
+    CHARACTERVAL CHAR(1) NOT NULL,
+    DOUBLEVAL DOUBLE NOT NULL,
+    FLOATVAL FLOAT NOT NULL,
+    INTEGERVAL INTEGER NOT NULL,
+    LONGVAL BIGINT NOT NULL,
+    SHORTVAL SMALLINT NOT NULL,
+    STRINGVAL VARCHAR(255) NOT NULL,
+    LOCALEVAL CHAR(20) NOT NULL,
+    DATEVAL DATE NOT NULL,
+    BIGDECIMALVAL DECIMAL(19),
+    BIGINTEGERVAL BIGINT
+);
+
+ALTER TABLE ALLTYPES ADD CONSTRAINT ALLTYPES_PK PRIMARY KEY (ID);
+
 CREATE TABLE FIELDSOFBIGDECIMAL
 (
     IDENTIFIER INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
@@ -1515,6 +1546,77 @@
 
 ALTER TABLE FIELDSOFOBJECT ADD CONSTRAINT FIELDSOFOBJECT_PK PRIMARY KEY (IDENTIFIER);
 
+CREATE TABLE FIELDSOFSIMPLEINTERFACE
+(
+    IDENTIFIER INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    SIMPLEINTERFACE1 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE102 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE103 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE104 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE109 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE11 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE110 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE112 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE113 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE114 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE119 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE12 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE120 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE121 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE125 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE126 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE128 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE129 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE13 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE130 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE138 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE139 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE140 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE17 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE18 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE2 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE20 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE21 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE22 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE30 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE31 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE32 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE37 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE38 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE4 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE40 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE41 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE42 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE47 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE48 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE49 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE5 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE53 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE54 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE56 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE57 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE58 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE6 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE66 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE67 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE68 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE73 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE74 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE76 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE77 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE78 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE83 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE84 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE85 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE89 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE90 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE92 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE93 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE94 LONG VARCHAR FOR BIT DATA
+);
+
+ALTER TABLE FIELDSOFSIMPLEINTERFACE ADD CONSTRAINT FOSI_PK PRIMARY KEY (IDENTIFIER);
+
 CREATE TABLE FIELDSOFPRIMITIVEBOOLEAN
 (
     IDENTIFIER INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
@@ -2848,6 +2950,176 @@
 CREATE TABLE LIST_OF_SHORT41
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL GENERATED ALWAYS AS IDENTITY,
+    SHORTVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+--ArrayListCollections
+
+CREATE TABLE ARRAYLIST_COLLECTIONS
+(
+    IDENTIFIER INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+	ARRAYLIST_OF_STRING9 BLOB,
+	ARRAYLIST_OF_STRING10 BLOB,
+	ARRAYLIST_OF_DATE12 BLOB,
+	ARRAYLIST_OF_DATE13 BLOB,
+	ARRAYLIST_OF_LOCALE15 BLOB,
+	ARRAYLIST_OF_LOCALE16 BLOB,
+	ARRAYLIST_OF_BIG_DECIMAL18 BLOB,
+	ARRAYLIST_OF_BIG_DECIMAL19 BLOB,
+	ARRAYLIST_OF_BIG_INTEGER21 BLOB,
+	ARRAYLIST_OF_BIG_INTEGER22 BLOB,
+	ARRAYLIST_OF_BYTE24 BLOB,
+	ARRAYLIST_OF_BYTE25 BLOB,
+	ARRAYLIST_OF_DOUBLE27 BLOB,
+	ARRAYLIST_OF_DOUBLE28 BLOB,
+	ARRAYLIST_OF_FLOAT30 BLOB,
+	ARRAYLIST_OF_FLOAT31 BLOB,
+	ARRAYLIST_OF_INTEGER33 BLOB,
+	ARRAYLIST_OF_INTEGER34 BLOB,
+	ARRAYLIST_OF_LONG36 BLOB,
+	ARRAYLIST_OF_LONG37 BLOB,
+	ARRAYLIST_OF_SHORT39 BLOB,
+	ARRAYLIST_OF_SHORT40 BLOB,
+    CONSTRAINT ALC_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE ARRAYLIST_OF_OBJECT0
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_OBJECT1
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_OBJECT2
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_CLASS3
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_CLASS4
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_CLASS5
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_INTERFACE6
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_INTERFACE7
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLE_INTERFACE8
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_STRING11
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    STRINGVAL VARCHAR(1024),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_DATE14
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    DATEVAL DATE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_LOCALE17
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    LOCALEVAL CHAR(20),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_BIG_DECIMAL20
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_BIG_INTEGER23
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    BIG_INTEGERVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_BYTE26
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    BYTEVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_DOUBLE29
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    DOUBLEVAL DOUBLE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_FLOAT32
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    FLOATVAL FLOAT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_INTEGER35
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    INTEGERVAL INTEGER,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_LONG38
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+    LONGVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SHORT41
+(
+    IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
     SHORTVAL SMALLINT,
     INDEX INTEGER NOT NULL
 );



Mime
View raw message