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 mb...@apache.org on 2005/12/20 23:57:33 UTC
svn commit: r358134 - in /db/jdo/trunk/tck20/test/sql/derby:
applicationidentity/ datastoreidentity/
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