db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From m..@apache.org
Subject svn commit: r358134 - in /db/jdo/trunk/tck20/test/sql/derby: applicationidentity/ datastoreidentity/
Date Tue, 20 Dec 2005 22:57:33 GMT
Author: mbo
Date: Tue Dec 20 14:57:22 2005
New Revision: 358134

URL: http://svn.apache.org/viewcvs?rev=358134&view=rev
Log:
JDO-206: update the derby schema files schema[1-4].sql to use the type DOUBLE
(instead of FLOAT) for all columns that are used to map double fields. 

Modified:
    db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema1.sql
    db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema2.sql
    db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema3.sql
    db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema4.sql
    db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema1.sql
    db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema2.sql
    db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema3.sql
    db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema4.sql

Modified: db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema1.sql
URL: http://svn.apache.org/viewcvs/db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema1.sql?rev=358134&r1=358133&r2=358134&view=diff
==============================================================================
--- db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema1.sql (original)
+++ db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema1.sql Tue Dec 20 14:57:22
2005
@@ -71,7 +71,7 @@
 CREATE TABLE employees (
     PERSONID INTEGER NOT NULL,
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES persons,
@@ -83,14 +83,14 @@
 
 CREATE TABLE parttimeemployees (
     PERSONID INTEGER NOT NULL,
-    WAGE FLOAT,
+    WAGE DOUBLE,
     CONSTRAINT PTEMPS_PK PRIMARY KEY (PERSONID),
     CONSTRAINT PTEMPS_FK FOREIGN KEY (PERSONID) REFERENCES persons (PERSONID)
 );
 
 CREATE TABLE fulltimeemployees (
     PERSONID INTEGER NOT NULL,
-    SALARY FLOAT,
+    SALARY DOUBLE,
     CONSTRAINT FTEMPS_PK PRIMARY KEY (PERSONID),
     CONSTRAINT FTEMPS_FK FOREIGN KEY (PERSONID) REFERENCES persons (PERSONID)
 );

Modified: db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema2.sql
URL: http://svn.apache.org/viewcvs/db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema2.sql?rev=358134&r1=358133&r2=358134&view=diff
==============================================================================
--- db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema2.sql (original)
+++ db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema2.sql Tue Dec 20 14:57:22
2005
@@ -89,13 +89,13 @@
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES fulltimeemployees,
     MENTOR INTEGER REFERENCES fulltimeemployees,
     HRADVISOR INTEGER REFERENCES fulltimeemployees,
-    SALARY FLOAT,
+    SALARY DOUBLE,
     CONSTRAINT FTEMPS_PK PRIMARY KEY (PERSONID)
 );
 
@@ -112,13 +112,13 @@
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES fulltimeemployees,
     MENTOR INTEGER REFERENCES fulltimeemployees,
     HRADVISOR INTEGER REFERENCES fulltimeemployees,
-    WAGE FLOAT,
+    WAGE DOUBLE,
     CONSTRAINT PTEMPS_PK PRIMARY KEY (PERSONID)
 );
 

Modified: db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema3.sql
URL: http://svn.apache.org/viewcvs/db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema3.sql?rev=358134&r1=358133&r2=358134&view=diff
==============================================================================
--- db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema3.sql (original)
+++ db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema3.sql Tue Dec 20 14:57:22
2005
@@ -72,13 +72,13 @@
 CREATE TABLE parttimeemployees (
     PERSONID INTEGER NOT NULL,
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES persons,
     MENTOR INTEGER REFERENCES persons,
     HRADVISOR INTEGER REFERENCES persons,
-    WAGE FLOAT,
+    WAGE DOUBLE,
     CONSTRAINT PTEMPS_PK PRIMARY KEY (PERSONID),
     CONSTRAINT PTEMPS_FK FOREIGN KEY (PERSONID) REFERENCES persons (PERSONID)
 );
@@ -86,13 +86,13 @@
 CREATE TABLE fulltimeemployees (
     PERSONID INTEGER NOT NULL,
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES persons,
     MENTOR INTEGER REFERENCES persons,
     HRADVISOR INTEGER REFERENCES persons,
-    SALARY FLOAT,
+    SALARY DOUBLE,
     CONSTRAINT FTEMPS_PK PRIMARY KEY (PERSONID),
     CONSTRAINT FTEMPS_FK FOREIGN KEY (PERSONID) REFERENCES persons (PERSONID)
 );

Modified: db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema4.sql
URL: http://svn.apache.org/viewcvs/db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema4.sql?rev=358134&r1=358133&r2=358134&view=diff
==============================================================================
--- db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema4.sql (original)
+++ db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema4.sql Tue Dec 20 14:57:22
2005
@@ -67,14 +67,14 @@
 CREATE TABLE employees (
     PERSONID INTEGER NOT NULL,
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES persons,
     MENTOR INTEGER REFERENCES persons,
     HRADVISOR INTEGER REFERENCES persons,
-    WAGE FLOAT,
-    SALARY FLOAT,
+    WAGE DOUBLE,
+    SALARY DOUBLE,
     DISCRIMINATOR varchar(64) NOT NULL,
     CONSTRAINT EMPS_PK PRIMARY KEY (PERSONID),
     CONSTRAINT EMPS_FK FOREIGN KEY (PERSONID) REFERENCES persons (PERSONID)

Modified: db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema1.sql
URL: http://svn.apache.org/viewcvs/db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema1.sql?rev=358134&r1=358133&r2=358134&view=diff
==============================================================================
--- db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema1.sql (original)
+++ db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema1.sql Tue Dec 20 14:57:22 2005
@@ -74,7 +74,7 @@
 CREATE TABLE employees (
     DATASTORE_IDENTITY INTEGER NOT NULL,
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES persons,
@@ -86,14 +86,14 @@
 
 CREATE TABLE parttimeemployees (
     DATASTORE_IDENTITY INTEGER NOT NULL,
-    WAGE FLOAT,
+    WAGE DOUBLE,
     CONSTRAINT PTEMPS_PK PRIMARY KEY (DATASTORE_IDENTITY),
     CONSTRAINT PTEMPS_FK FOREIGN KEY (DATASTORE_IDENTITY) REFERENCES persons (DATASTORE_IDENTITY)
 );
 
 CREATE TABLE fulltimeemployees (
     DATASTORE_IDENTITY INTEGER NOT NULL,
-    SALARY FLOAT,
+    SALARY DOUBLE,
     CONSTRAINT FTEMPS_PK PRIMARY KEY (DATASTORE_IDENTITY),
     CONSTRAINT FTEMPS_FK FOREIGN KEY (DATASTORE_IDENTITY) REFERENCES persons (DATASTORE_IDENTITY)
 );

Modified: db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema2.sql
URL: http://svn.apache.org/viewcvs/db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema2.sql?rev=358134&r1=358133&r2=358134&view=diff
==============================================================================
--- db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema2.sql (original)
+++ db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema2.sql Tue Dec 20 14:57:22 2005
@@ -93,13 +93,13 @@
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES fulltimeemployees,
     MENTOR INTEGER REFERENCES fulltimeemployees,
     HRADVISOR INTEGER REFERENCES fulltimeemployees,
-    SALARY FLOAT,
+    SALARY DOUBLE,
     CONSTRAINT FTEMPS_PK PRIMARY KEY (DATASTORE_IDENTITY)
 );
 
@@ -117,13 +117,13 @@
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES fulltimeemployees,
     MENTOR INTEGER REFERENCES fulltimeemployees,
     HRADVISOR INTEGER REFERENCES fulltimeemployees,
-    WAGE FLOAT,
+    WAGE DOUBLE,
     CONSTRAINT PTEMPS_PK PRIMARY KEY (DATASTORE_IDENTITY)
 );
 

Modified: db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema3.sql
URL: http://svn.apache.org/viewcvs/db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema3.sql?rev=358134&r1=358133&r2=358134&view=diff
==============================================================================
--- db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema3.sql (original)
+++ db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema3.sql Tue Dec 20 14:57:22 2005
@@ -75,13 +75,13 @@
 CREATE TABLE parttimeemployees (
     DATASTORE_IDENTITY INTEGER NOT NULL,
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES persons,
     MENTOR INTEGER REFERENCES persons,
     HRADVISOR INTEGER REFERENCES persons,
-    WAGE FLOAT,
+    WAGE DOUBLE,
     CONSTRAINT PTEMPS_PK PRIMARY KEY (DATASTORE_IDENTITY),
     CONSTRAINT PTEMPS_FK FOREIGN KEY (DATASTORE_IDENTITY) REFERENCES persons 
 );
@@ -89,13 +89,13 @@
 CREATE TABLE fulltimeemployees (
     DATASTORE_IDENTITY INTEGER NOT NULL,
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES persons,
     MENTOR INTEGER REFERENCES persons,
     HRADVISOR INTEGER REFERENCES persons,
-    SALARY FLOAT,
+    SALARY DOUBLE,
     CONSTRAINT FTEMPS_PK PRIMARY KEY (DATASTORE_IDENTITY),
     CONSTRAINT FTEMPS_FK FOREIGN KEY (DATASTORE_IDENTITY) REFERENCES persons 
 );

Modified: db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema4.sql
URL: http://svn.apache.org/viewcvs/db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema4.sql?rev=358134&r1=358133&r2=358134&view=diff
==============================================================================
--- db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema4.sql (original)
+++ db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema4.sql Tue Dec 20 14:57:22 2005
@@ -70,14 +70,14 @@
 CREATE TABLE employees (
     DATASTORE_IDENTITY INTEGER NOT NULL,
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES persons,
     MENTOR INTEGER REFERENCES persons,
     HRADVISOR INTEGER REFERENCES persons,
-    WAGE FLOAT,
-    SALARY FLOAT,
+    WAGE DOUBLE,
+    SALARY DOUBLE,
     DISCRIMINATOR varchar(64) NOT NULL,
     CONSTRAINT EMPS_PK PRIMARY KEY (DATASTORE_IDENTITY),
     CONSTRAINT EMPS_FK FOREIGN KEY (DATASTORE_IDENTITY) REFERENCES persons



Mime
View raw message