You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-commits@db.apache.org by mc...@apache.org on 2005/05/12 05:30:28 UTC
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/
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
);