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/10/04 22:32:50 UTC
svn commit: r294910 - in /incubator/jdo/trunk/tck20/test/sql/derby: applicationidentity/schema.sql datastoreidentity/schema.sql

Author: mcaisse
Date: Tue Oct  4 13:32:47 2005
New Revision: 294910

URL: http://svn.apache.org/viewcvs?rev=294910&view=rev
Log:
JDO-144 partial fix, plus several other test failures resolved. Map java.util.date to an SQL TIMESTAMP column.

Modified:
    incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql
    incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql

Modified: incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql?rev=294910&r1=294909&r2=294910&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql Tue Oct  4 13:32:47 2005
@@ -53,7 +53,7 @@
     doubleNull FLOAT,
     charNotNull CHAR NOT NULL,
     charNull CHAR,
-    dateNull DATE,
+    dateNull TIMESTAMP,
     stringNull VARCHAR (256),
     bigDecimal DECIMAL,
     bigInteger INTEGER,
@@ -839,7 +839,7 @@
     SHORTVAL SMALLINT,
     STRINGVAL VARCHAR(255),
     LOCALEVAL CHAR(20),
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     BIGDECIMALVAL DECIMAL(25,10),
     BIGINTEGERVAL BIGINT
 );
@@ -2796,7 +2796,7 @@
 CREATE TABLE ARRAY_OF_DATE9
 (
     IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE ARRAY_OF_LOCALE11
@@ -2960,14 +2960,14 @@
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE COLLECTION_OF_DATE13
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE COLLECTION_OF_LOCALE15
@@ -3195,14 +3195,14 @@
 CREATE TABLE LIST_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LIST_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -3431,14 +3431,14 @@
 CREATE TABLE ARRAYLIST_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE ARRAYLIST_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -3667,14 +3667,14 @@
 CREATE TABLE LINKEDLIST_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -3903,14 +3903,14 @@
 CREATE TABLE VECTOR_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -4128,13 +4128,13 @@
 CREATE TABLE SET_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE SET_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE SET_OF_LOCALE15
@@ -4333,13 +4333,13 @@
 CREATE TABLE HASHSET_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE HASHSET_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE HASHSET_OF_LOCALE15
@@ -4548,14 +4548,14 @@
 CREATE TABLE TREESET_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREESET_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -4925,7 +4925,7 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE MAP_OF_STRING_LOCALE101
@@ -5245,7 +5245,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE HASHMAP_STR_LOCALE101
@@ -5565,7 +5565,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE HASHTBL_STR_LOCALE101
@@ -5853,7 +5853,7 @@
 CREATE TABLE HASHMAP_DATE44_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL DATE
+    KEYVAL TIMESTAMP
 );
 
 CREATE TABLE HASHMAP_BIG_DECIMAL53_STR (
@@ -6138,7 +6138,7 @@
 CREATE TABLE HASHTBL_DATE44_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL DATE
+    KEYVAL TIMESTAMP
 );
 
 CREATE TABLE HASHTBL_BIG_DECIMAL53_STR (
@@ -6433,7 +6433,7 @@
 CREATE TABLE TREEMAP_DATE44_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -6721,7 +6721,7 @@
 CREATE TABLE MAP_OF_DATE44_STRING (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL DATE
+    KEYVAL TIMESTAMP
 );
 
 CREATE TABLE MAP_OF_BIG_DECIMAL53_STRING (
@@ -7048,7 +7048,7 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 

Modified: incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql?rev=294910&r1=294909&r2=294910&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql Tue Oct  4 13:32:47 2005
@@ -57,7 +57,7 @@
     doubleNull FLOAT,
     charNotNull CHAR NOT NULL,
     charNull CHAR,
-    dateNull DATE,
+    dateNull TIMESTAMP,
     stringNull VARCHAR (256),
     bigDecimal DECIMAL,
     bigInteger INTEGER,
@@ -797,7 +797,7 @@
     SHORTVAL SMALLINT,
     STRINGVAL VARCHAR(255),
     LOCALEVAL CHAR(20),
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     BIGDECIMALVAL DECIMAL(25,10),
     BIGINTEGERVAL BIGINT
 );
@@ -2779,7 +2779,7 @@
 CREATE TABLE ARRAY_OF_DATE9
 (
     IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE ARRAY_OF_LOCALE11
@@ -2944,14 +2944,14 @@
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE COLLECTION_OF_DATE13
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE COLLECTION_OF_LOCALE15
@@ -3180,14 +3180,14 @@
 CREATE TABLE LIST_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LIST_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -3417,14 +3417,14 @@
 CREATE TABLE ARRAYLIST_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE ARRAYLIST_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -3654,14 +3654,14 @@
 CREATE TABLE LINKEDLIST_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -3891,14 +3891,14 @@
 CREATE TABLE VECTOR_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -4117,13 +4117,13 @@
 CREATE TABLE SET_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE SET_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE SET_OF_LOCALE15
@@ -4323,13 +4323,13 @@
 CREATE TABLE HASHSET_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE HASHSET_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE HASHSET_OF_LOCALE15
@@ -4539,14 +4539,14 @@
 CREATE TABLE TREESET_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREESET_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -4917,7 +4917,7 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE MAP_OF_STRING_LOCALE101
@@ -5238,7 +5238,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE HASHMAP_STR_LOCALE101
@@ -5559,7 +5559,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    DATEVAL DATE
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE HASHTBL_STR_LOCALE101
@@ -5848,7 +5848,7 @@
 CREATE TABLE HASHMAP_DATE44_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL DATE
+    KEYVAL TIMESTAMP
 );
 
 CREATE TABLE HASHMAP_BIG_DECIMAL53_STR (
@@ -6134,7 +6134,7 @@
 CREATE TABLE HASHTBL_DATE44_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL DATE
+    KEYVAL TIMESTAMP
 );
 
 CREATE TABLE HASHTBL_BIG_DECIMAL53_STR (
@@ -6430,7 +6430,7 @@
 CREATE TABLE TREEMAP_DATE44_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );
 
@@ -6719,7 +6719,7 @@
 CREATE TABLE MAP_OF_DATE44_STRING (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL DATE
+    KEYVAL TIMESTAMP
 );
 
 CREATE TABLE MAP_OF_BIG_DECIMAL53_STRING (
@@ -7047,7 +7047,7 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    DATEVAL DATE,
+    DATEVAL TIMESTAMP,
     INDEX INTEGER NOT NULL
 );