db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From m..@apache.org
Subject svn commit: r358029 - in /db/jdo/trunk/tck20/test/sql/derby: applicationidentity/schema.sql datastoreidentity/schema.sql
Date Tue, 20 Dec 2005 16:21:28 GMT
Author: mbo
Date: Tue Dec 20 08:21:23 2005
New Revision: 358029

URL: http://svn.apache.org/viewcvs?rev=358029&view=rev
Log:
JDO-206: change the derby schema by using the column type REAL for all float fields. 
This also fixes a bug in the table PrimitiveTypes: the type of columns doubleNull 
and doubleNotNull should be DOUBLE instead of FLOAT.

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

Modified: db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql
URL: http://svn.apache.org/viewcvs/db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql?rev=358029&r1=358028&r2=358029&view=diff
==============================================================================
--- db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (original)
+++ db/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql Tue Dec 20 08:21:23 2005
@@ -48,10 +48,10 @@
     intNull INTEGER,
     longNotNull INTEGER NOT NULL,
     longNull INTEGER,
-    floatNotNull FLOAT NOT NULL,
-    floatNull FLOAT,
-    doubleNotNull FLOAT NOT NULL,
-    doubleNull FLOAT,
+    floatNotNull REAL NOT NULL,
+    floatNull REAL,
+    doubleNotNull DOUBLE NOT NULL,
+    doubleNull DOUBLE,
     charNotNull CHAR NOT NULL,
     charNull CHAR,
     dateNull TIMESTAMP,
@@ -197,14 +197,14 @@
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS REAL,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES persons,
     MENTOR INTEGER REFERENCES persons,
     HRADVISOR INTEGER REFERENCES persons,
-    SALARY FLOAT,
-    WAGE FLOAT,
+    SALARY REAL,
+    WAGE REAL,
     DISCRIMINATOR varchar(64) NOT NULL,
     CONSTRAINT EMPS_PK PRIMARY KEY (PERSONID)
 );
@@ -1239,7 +1239,7 @@
     PRIMITIVEBYTE SMALLINT,
     PRIMITIVECHAR INTEGER,
     PRIMITIVEDOUBLE DOUBLE,
-    PRIMITIVEFLOAT FLOAT,
+    PRIMITIVEFLOAT REAL,
     PRIMITIVEINT INTEGER,
     PRIMITIVELONG BIGINT,
     PRIMITIVESHORT SMALLINT,
@@ -1247,7 +1247,7 @@
     BYTEVAL SMALLINT,
     CHARACTERVAL INTEGER,
     DOUBLEVAL DOUBLE,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INTEGERVAL INTEGER,
     LONGVAL BIGINT,
     SHORTVAL SMALLINT,
@@ -1737,78 +1737,78 @@
 CREATE TABLE FIELDSOFFLOAT
 (
     IDENTIFIER INTEGER NOT NULL,
-    FLOAT0 FLOAT,
-    FLOAT1 FLOAT,
-    FLOAT102 FLOAT,
-    FLOAT103 FLOAT,
-    FLOAT104 FLOAT,
-    FLOAT108 FLOAT,
-    FLOAT109 FLOAT,
-    FLOAT11 FLOAT,
-    FLOAT110 FLOAT,
-    FLOAT112 FLOAT,
-    FLOAT113 FLOAT,
-    FLOAT114 FLOAT,
-    FLOAT119 FLOAT,
-    FLOAT12 FLOAT,
-    FLOAT120 FLOAT,
-    FLOAT121 FLOAT,
-    FLOAT124 FLOAT,
-    FLOAT125 FLOAT,
-    FLOAT126 FLOAT,
-    FLOAT128 FLOAT,
-    FLOAT129 FLOAT,
-    FLOAT13 FLOAT,
-    FLOAT130 FLOAT,
-    FLOAT138 FLOAT,
-    FLOAT139 FLOAT,
-    FLOAT140 FLOAT,
-    FLOAT16 FLOAT,
-    FLOAT17 FLOAT,
-    FLOAT18 FLOAT,
-    FLOAT2 FLOAT,
-    FLOAT20 FLOAT,
-    FLOAT21 FLOAT,
-    FLOAT22 FLOAT,
-    FLOAT30 FLOAT,
-    FLOAT31 FLOAT,
-    FLOAT32 FLOAT,
-    FLOAT36 FLOAT,
-    FLOAT37 FLOAT,
-    FLOAT38 FLOAT,
-    FLOAT4 FLOAT,
-    FLOAT40 FLOAT,
-    FLOAT41 FLOAT,
-    FLOAT42 FLOAT,
-    FLOAT47 FLOAT,
-    FLOAT48 FLOAT,
-    FLOAT49 FLOAT,
-    FLOAT5 FLOAT,
-    FLOAT52 FLOAT,
-    FLOAT53 FLOAT,
-    FLOAT54 FLOAT,
-    FLOAT56 FLOAT,
-    FLOAT57 FLOAT,
-    FLOAT58 FLOAT,
-    FLOAT6 FLOAT,
-    FLOAT66 FLOAT,
-    FLOAT67 FLOAT,
-    FLOAT68 FLOAT,
-    FLOAT72 FLOAT,
-    FLOAT73 FLOAT,
-    FLOAT74 FLOAT,
-    FLOAT76 FLOAT,
-    FLOAT77 FLOAT,
-    FLOAT78 FLOAT,
-    FLOAT83 FLOAT,
-    FLOAT84 FLOAT,
-    FLOAT85 FLOAT,
-    FLOAT88 FLOAT,
-    FLOAT89 FLOAT,
-    FLOAT90 FLOAT,
-    FLOAT92 FLOAT,
-    FLOAT93 FLOAT,
-    FLOAT94 FLOAT
+    FLOAT0 REAL,
+    FLOAT1 REAL,
+    FLOAT102 REAL,
+    FLOAT103 REAL,
+    FLOAT104 REAL,
+    FLOAT108 REAL,
+    FLOAT109 REAL,
+    FLOAT11 REAL,
+    FLOAT110 REAL,
+    FLOAT112 REAL,
+    FLOAT113 REAL,
+    FLOAT114 REAL,
+    FLOAT119 REAL,
+    FLOAT12 REAL,
+    FLOAT120 REAL,
+    FLOAT121 REAL,
+    FLOAT124 REAL,
+    FLOAT125 REAL,
+    FLOAT126 REAL,
+    FLOAT128 REAL,
+    FLOAT129 REAL,
+    FLOAT13 REAL,
+    FLOAT130 REAL,
+    FLOAT138 REAL,
+    FLOAT139 REAL,
+    FLOAT140 REAL,
+    FLOAT16 REAL,
+    FLOAT17 REAL,
+    FLOAT18 REAL,
+    FLOAT2 REAL,
+    FLOAT20 REAL,
+    FLOAT21 REAL,
+    FLOAT22 REAL,
+    FLOAT30 REAL,
+    FLOAT31 REAL,
+    FLOAT32 REAL,
+    FLOAT36 REAL,
+    FLOAT37 REAL,
+    FLOAT38 REAL,
+    FLOAT4 REAL,
+    FLOAT40 REAL,
+    FLOAT41 REAL,
+    FLOAT42 REAL,
+    FLOAT47 REAL,
+    FLOAT48 REAL,
+    FLOAT49 REAL,
+    FLOAT5 REAL,
+    FLOAT52 REAL,
+    FLOAT53 REAL,
+    FLOAT54 REAL,
+    FLOAT56 REAL,
+    FLOAT57 REAL,
+    FLOAT58 REAL,
+    FLOAT6 REAL,
+    FLOAT66 REAL,
+    FLOAT67 REAL,
+    FLOAT68 REAL,
+    FLOAT72 REAL,
+    FLOAT73 REAL,
+    FLOAT74 REAL,
+    FLOAT76 REAL,
+    FLOAT77 REAL,
+    FLOAT78 REAL,
+    FLOAT83 REAL,
+    FLOAT84 REAL,
+    FLOAT85 REAL,
+    FLOAT88 REAL,
+    FLOAT89 REAL,
+    FLOAT90 REAL,
+    FLOAT92 REAL,
+    FLOAT93 REAL,
+    FLOAT94 REAL
 );
 
 ALTER TABLE FIELDSOFFLOAT ADD CONSTRAINT FIELDSOFFLOAT_PK PRIMARY KEY (IDENTIFIER);
@@ -2511,78 +2511,78 @@
 CREATE TABLE FIELDSOFPRIMITIVEFLOAT
 (
     IDENTIFIER INTEGER NOT NULL,
-    FLOAT0 FLOAT NOT NULL,
-    FLOAT1 FLOAT NOT NULL,
-    FLOAT102 FLOAT NOT NULL,
-    FLOAT103 FLOAT NOT NULL,
-    FLOAT104 FLOAT NOT NULL,
-    FLOAT108 FLOAT NOT NULL,
-    FLOAT109 FLOAT NOT NULL,
-    FLOAT11 FLOAT NOT NULL,
-    FLOAT110 FLOAT NOT NULL,
-    FLOAT112 FLOAT NOT NULL,
-    FLOAT113 FLOAT NOT NULL,
-    FLOAT114 FLOAT NOT NULL,
-    FLOAT119 FLOAT NOT NULL,
-    FLOAT12 FLOAT NOT NULL,
-    FLOAT120 FLOAT NOT NULL,
-    FLOAT121 FLOAT NOT NULL,
-    FLOAT124 FLOAT NOT NULL,
-    FLOAT125 FLOAT NOT NULL,
-    FLOAT126 FLOAT NOT NULL,
-    FLOAT128 FLOAT NOT NULL,
-    FLOAT129 FLOAT NOT NULL,
-    FLOAT13 FLOAT NOT NULL,
-    FLOAT130 FLOAT NOT NULL,
-    FLOAT138 FLOAT NOT NULL,
-    FLOAT139 FLOAT NOT NULL,
-    FLOAT140 FLOAT NOT NULL,
-    FLOAT16 FLOAT NOT NULL,
-    FLOAT17 FLOAT NOT NULL,
-    FLOAT18 FLOAT NOT NULL,
-    FLOAT2 FLOAT NOT NULL,
-    FLOAT20 FLOAT NOT NULL,
-    FLOAT21 FLOAT NOT NULL,
-    FLOAT22 FLOAT NOT NULL,
-    FLOAT30 FLOAT NOT NULL,
-    FLOAT31 FLOAT NOT NULL,
-    FLOAT32 FLOAT NOT NULL,
-    FLOAT36 FLOAT NOT NULL,
-    FLOAT37 FLOAT NOT NULL,
-    FLOAT38 FLOAT NOT NULL,
-    FLOAT4 FLOAT NOT NULL,
-    FLOAT40 FLOAT NOT NULL,
-    FLOAT41 FLOAT NOT NULL,
-    FLOAT42 FLOAT NOT NULL,
-    FLOAT47 FLOAT NOT NULL,
-    FLOAT48 FLOAT NOT NULL,
-    FLOAT49 FLOAT NOT NULL,
-    FLOAT5 FLOAT NOT NULL,
-    FLOAT52 FLOAT NOT NULL,
-    FLOAT53 FLOAT NOT NULL,
-    FLOAT54 FLOAT NOT NULL,
-    FLOAT56 FLOAT NOT NULL,
-    FLOAT57 FLOAT NOT NULL,
-    FLOAT58 FLOAT NOT NULL,
-    FLOAT6 FLOAT NOT NULL,
-    FLOAT66 FLOAT NOT NULL,
-    FLOAT67 FLOAT NOT NULL,
-    FLOAT68 FLOAT NOT NULL,
-    FLOAT72 FLOAT NOT NULL,
-    FLOAT73 FLOAT NOT NULL,
-    FLOAT74 FLOAT NOT NULL,
-    FLOAT76 FLOAT NOT NULL,
-    FLOAT77 FLOAT NOT NULL,
-    FLOAT78 FLOAT NOT NULL,
-    FLOAT83 FLOAT NOT NULL,
-    FLOAT84 FLOAT NOT NULL,
-    FLOAT85 FLOAT NOT NULL,
-    FLOAT88 FLOAT NOT NULL,
-    FLOAT89 FLOAT NOT NULL,
-    FLOAT90 FLOAT NOT NULL,
-    FLOAT92 FLOAT NOT NULL,
-    FLOAT93 FLOAT NOT NULL,
-    FLOAT94 FLOAT NOT NULL
+    FLOAT0 REAL NOT NULL,
+    FLOAT1 REAL NOT NULL,
+    FLOAT102 REAL NOT NULL,
+    FLOAT103 REAL NOT NULL,
+    FLOAT104 REAL NOT NULL,
+    FLOAT108 REAL NOT NULL,
+    FLOAT109 REAL NOT NULL,
+    FLOAT11 REAL NOT NULL,
+    FLOAT110 REAL NOT NULL,
+    FLOAT112 REAL NOT NULL,
+    FLOAT113 REAL NOT NULL,
+    FLOAT114 REAL NOT NULL,
+    FLOAT119 REAL NOT NULL,
+    FLOAT12 REAL NOT NULL,
+    FLOAT120 REAL NOT NULL,
+    FLOAT121 REAL NOT NULL,
+    FLOAT124 REAL NOT NULL,
+    FLOAT125 REAL NOT NULL,
+    FLOAT126 REAL NOT NULL,
+    FLOAT128 REAL NOT NULL,
+    FLOAT129 REAL NOT NULL,
+    FLOAT13 REAL NOT NULL,
+    FLOAT130 REAL NOT NULL,
+    FLOAT138 REAL NOT NULL,
+    FLOAT139 REAL NOT NULL,
+    FLOAT140 REAL NOT NULL,
+    FLOAT16 REAL NOT NULL,
+    FLOAT17 REAL NOT NULL,
+    FLOAT18 REAL NOT NULL,
+    FLOAT2 REAL NOT NULL,
+    FLOAT20 REAL NOT NULL,
+    FLOAT21 REAL NOT NULL,
+    FLOAT22 REAL NOT NULL,
+    FLOAT30 REAL NOT NULL,
+    FLOAT31 REAL NOT NULL,
+    FLOAT32 REAL NOT NULL,
+    FLOAT36 REAL NOT NULL,
+    FLOAT37 REAL NOT NULL,
+    FLOAT38 REAL NOT NULL,
+    FLOAT4 REAL NOT NULL,
+    FLOAT40 REAL NOT NULL,
+    FLOAT41 REAL NOT NULL,
+    FLOAT42 REAL NOT NULL,
+    FLOAT47 REAL NOT NULL,
+    FLOAT48 REAL NOT NULL,
+    FLOAT49 REAL NOT NULL,
+    FLOAT5 REAL NOT NULL,
+    FLOAT52 REAL NOT NULL,
+    FLOAT53 REAL NOT NULL,
+    FLOAT54 REAL NOT NULL,
+    FLOAT56 REAL NOT NULL,
+    FLOAT57 REAL NOT NULL,
+    FLOAT58 REAL NOT NULL,
+    FLOAT6 REAL NOT NULL,
+    FLOAT66 REAL NOT NULL,
+    FLOAT67 REAL NOT NULL,
+    FLOAT68 REAL NOT NULL,
+    FLOAT72 REAL NOT NULL,
+    FLOAT73 REAL NOT NULL,
+    FLOAT74 REAL NOT NULL,
+    FLOAT76 REAL NOT NULL,
+    FLOAT77 REAL NOT NULL,
+    FLOAT78 REAL NOT NULL,
+    FLOAT83 REAL NOT NULL,
+    FLOAT84 REAL NOT NULL,
+    FLOAT85 REAL NOT NULL,
+    FLOAT88 REAL NOT NULL,
+    FLOAT89 REAL NOT NULL,
+    FLOAT90 REAL NOT NULL,
+    FLOAT92 REAL NOT NULL,
+    FLOAT93 REAL NOT NULL,
+    FLOAT94 REAL NOT NULL
 );
 
 ALTER TABLE FIELDSOFPRIMITIVEFLOAT ADD CONSTRAINT FIELDSOFPRIMR3_PK PRIMARY KEY (IDENTIFIER);
@@ -3275,7 +3275,7 @@
 (
     IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
     ORDER_COL BIGINT,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE ARRAY_OF_INTEGER23
@@ -3490,14 +3490,14 @@
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE COLLECTION_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE COLLECTION_OF_INTEGER33
@@ -3733,14 +3733,14 @@
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE LIST_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE LIST_OF_INTEGER33
@@ -3968,14 +3968,14 @@
 CREATE TABLE ARRAYLIST_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE ARRAYLIST_OF_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INDEX INTEGER NOT NULL
 );
 
@@ -4212,14 +4212,14 @@
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE LINKEDLIST_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE LINKEDLIST_OF_INTEGER33
@@ -4455,14 +4455,14 @@
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE VECTOR_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE VECTOR_OF_INTEGER33
@@ -4659,13 +4659,13 @@
 CREATE TABLE SET_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE SET_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE SET_OF_INTEGER33
@@ -4856,13 +4856,13 @@
 CREATE TABLE HASHSET_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE HASHSET_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE HASHSET_OF_INTEGER33
@@ -5069,14 +5069,14 @@
 CREATE TABLE TREESET_OF_FLOAT27
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREESET_OF_FLOAT29
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INDEX INTEGER NOT NULL
 );
 
@@ -5358,21 +5358,21 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_INTEGER33
@@ -5594,14 +5594,14 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_FLOAT73
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_INTEGER75
@@ -5720,7 +5720,7 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_INTEGER117
@@ -5980,21 +5980,21 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_INTEGER33
@@ -6216,14 +6216,14 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_FLOAT73
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_INTEGER75
@@ -6342,7 +6342,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_INTEGER117
@@ -6602,21 +6602,21 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_INTEGER33
@@ -6838,14 +6838,14 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_FLOAT73
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_INTEGER75
@@ -6964,7 +6964,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_INTEGER117
@@ -7353,37 +7353,37 @@
 CREATE TABLE HASHMAP_FLOAT81_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_FLOAT82_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_FLOAT83_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_FLOAT84_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_FLOAT85_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_FLOAT87_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_INTEGER90_STR (
@@ -7859,37 +7859,37 @@
 CREATE TABLE HASHTBL_FLOAT81_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_FLOAT82_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_FLOAT83_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_FLOAT84_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_FLOAT85_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_FLOAT87_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_INTEGER90_STR (
@@ -8365,37 +8365,37 @@
 CREATE TABLE TREEMAP_FLOAT81_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_FLOAT82_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_FLOAT83_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_FLOAT84_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_FLOAT85_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_FLOAT87_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_INTEGER90_STR (
@@ -8871,37 +8871,37 @@
 CREATE TABLE MAP_FLOAT81_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_FLOAT82_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_FLOAT83_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_FLOAT84_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_FLOAT85_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_FLOAT87_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_INTEGER90_STR (
@@ -9248,21 +9248,21 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_INTEGER33
@@ -9484,14 +9484,14 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_FLOAT73
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_INTEGER75
@@ -9610,7 +9610,7 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_INTEGER117
@@ -9647,7 +9647,7 @@
     KEY_VALUE INTEGER NOT NULL,
     DOUBLE_B DOUBLE,
     INT_B INTEGER,
-    FLOAT_E FLOAT,
+    FLOAT_E REAL,
     SHORT_F SMALLINT,
     SECOND_OBJ INTEGER,
     THIRD_OBJ INTEGER,
@@ -9662,7 +9662,7 @@
     KEY_VALUE INTEGER NOT NULL,
     DOUBLE_B DOUBLE,
     INT_B INTEGER,
-    FLOAT_E FLOAT,
+    FLOAT_E REAL,
     SHORT_F SMALLINT,
     SECOND_OBJ INTEGER,
     THIRD_OBJ INTEGER,
@@ -9677,7 +9677,7 @@
     KEY_VALUE INTEGER NOT NULL,
     DOUBLE_B DOUBLE,
     INT_B INTEGER,
-    FLOAT_E FLOAT,
+    FLOAT_E REAL,
     SHORT_F SMALLINT,
     SECOND_OBJ INTEGER,
     THIRD_OBJ INTEGER,
@@ -9692,7 +9692,7 @@
     KEY_VALUE INTEGER NOT NULL,
     N2 DOUBLE,
     N3 INTEGER,
-    FSN2_N3 FLOAT,
+    FSN2_N3 REAL,
     FSN3_N1 SMALLINT,
     FSN3_N2 INTEGER,
     FSN3_N3 INTEGER,
@@ -9714,7 +9714,7 @@
     ICKEY INTEGER NOT NULL,
     D DOUBLE,
     S SMALLINT,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INTVAL INTEGER,
     CONSTRAINT ICNP_PK PRIMARY KEY (ICKEY)
 );

Modified: db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql
URL: http://svn.apache.org/viewcvs/db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql?rev=358029&r1=358028&r2=358029&view=diff
==============================================================================
--- db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (original)
+++ db/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql Tue Dec 20 08:21:23 2005
@@ -52,10 +52,10 @@
     intNull INTEGER,
     longNotNull INTEGER NOT NULL,
     longNull INTEGER,
-    floatNotNull FLOAT NOT NULL,
-    floatNull FLOAT,
-    doubleNotNull FLOAT NOT NULL,
-    doubleNull FLOAT,
+    floatNotNull REAL NOT NULL,
+    floatNull REAL,
+    doubleNotNull DOUBLE  NOT NULL,
+    doubleNull DOUBLE,
     charNotNull CHAR NOT NULL,
     charNull CHAR,
     dateNull TIMESTAMP,
@@ -146,14 +146,14 @@
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
     HIREDATE VARCHAR(32),
-    WEEKLYHOURS FLOAT,
+    WEEKLYHOURS REAL,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
     MANAGER INTEGER REFERENCES persons,
     MENTOR INTEGER REFERENCES persons,
     HRADVISOR INTEGER REFERENCES persons,
-    SALARY FLOAT,
-    WAGE FLOAT,
+    SALARY REAL,
+    WAGE REAL,
     DISCRIMINATOR varchar(64) NOT NULL,
     CONSTRAINT EMPS_PK PRIMARY KEY (DATASTORE_IDENTITY)
 );
@@ -1201,7 +1201,7 @@
     PRIMITIVEBYTE SMALLINT,
     PRIMITIVECHAR INTEGER,
     PRIMITIVEDOUBLE DOUBLE,
-    PRIMITIVEFLOAT FLOAT,
+    PRIMITIVEFLOAT REAL,
     PRIMITIVEINT INTEGER,
     PRIMITIVELONG BIGINT,
     PRIMITIVESHORT SMALLINT,
@@ -1209,7 +1209,7 @@
     BYTEVAL SMALLINT,
     CHARACTERVAL INTEGER,
     DOUBLEVAL DOUBLE,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INTEGERVAL INTEGER,
     LONGVAL BIGINT,
     SHORTVAL SMALLINT,
@@ -1706,78 +1706,78 @@
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     IDENTIFIER INTEGER,
-    FLOAT0 FLOAT,
-    FLOAT1 FLOAT,
-    FLOAT102 FLOAT,
-    FLOAT103 FLOAT,
-    FLOAT104 FLOAT,
-    FLOAT108 FLOAT,
-    FLOAT109 FLOAT,
-    FLOAT11 FLOAT,
-    FLOAT110 FLOAT,
-    FLOAT112 FLOAT,
-    FLOAT113 FLOAT,
-    FLOAT114 FLOAT,
-    FLOAT119 FLOAT,
-    FLOAT12 FLOAT,
-    FLOAT120 FLOAT,
-    FLOAT121 FLOAT,
-    FLOAT124 FLOAT,
-    FLOAT125 FLOAT,
-    FLOAT126 FLOAT,
-    FLOAT128 FLOAT,
-    FLOAT129 FLOAT,
-    FLOAT13 FLOAT,
-    FLOAT130 FLOAT,
-    FLOAT138 FLOAT,
-    FLOAT139 FLOAT,
-    FLOAT140 FLOAT,
-    FLOAT16 FLOAT,
-    FLOAT17 FLOAT,
-    FLOAT18 FLOAT,
-    FLOAT2 FLOAT,
-    FLOAT20 FLOAT,
-    FLOAT21 FLOAT,
-    FLOAT22 FLOAT,
-    FLOAT30 FLOAT,
-    FLOAT31 FLOAT,
-    FLOAT32 FLOAT,
-    FLOAT36 FLOAT,
-    FLOAT37 FLOAT,
-    FLOAT38 FLOAT,
-    FLOAT4 FLOAT,
-    FLOAT40 FLOAT,
-    FLOAT41 FLOAT,
-    FLOAT42 FLOAT,
-    FLOAT47 FLOAT,
-    FLOAT48 FLOAT,
-    FLOAT49 FLOAT,
-    FLOAT5 FLOAT,
-    FLOAT52 FLOAT,
-    FLOAT53 FLOAT,
-    FLOAT54 FLOAT,
-    FLOAT56 FLOAT,
-    FLOAT57 FLOAT,
-    FLOAT58 FLOAT,
-    FLOAT6 FLOAT,
-    FLOAT66 FLOAT,
-    FLOAT67 FLOAT,
-    FLOAT68 FLOAT,
-    FLOAT72 FLOAT,
-    FLOAT73 FLOAT,
-    FLOAT74 FLOAT,
-    FLOAT76 FLOAT,
-    FLOAT77 FLOAT,
-    FLOAT78 FLOAT,
-    FLOAT83 FLOAT,
-    FLOAT84 FLOAT,
-    FLOAT85 FLOAT,
-    FLOAT88 FLOAT,
-    FLOAT89 FLOAT,
-    FLOAT90 FLOAT,
-    FLOAT92 FLOAT,
-    FLOAT93 FLOAT,
-    FLOAT94 FLOAT
+    FLOAT0 REAL,
+    FLOAT1 REAL,
+    FLOAT102 REAL,
+    FLOAT103 REAL,
+    FLOAT104 REAL,
+    FLOAT108 REAL,
+    FLOAT109 REAL,
+    FLOAT11 REAL,
+    FLOAT110 REAL,
+    FLOAT112 REAL,
+    FLOAT113 REAL,
+    FLOAT114 REAL,
+    FLOAT119 REAL,
+    FLOAT12 REAL,
+    FLOAT120 REAL,
+    FLOAT121 REAL,
+    FLOAT124 REAL,
+    FLOAT125 REAL,
+    FLOAT126 REAL,
+    FLOAT128 REAL,
+    FLOAT129 REAL,
+    FLOAT13 REAL,
+    FLOAT130 REAL,
+    FLOAT138 REAL,
+    FLOAT139 REAL,
+    FLOAT140 REAL,
+    FLOAT16 REAL,
+    FLOAT17 REAL,
+    FLOAT18 REAL,
+    FLOAT2 REAL,
+    FLOAT20 REAL,
+    FLOAT21 REAL,
+    FLOAT22 REAL,
+    FLOAT30 REAL,
+    FLOAT31 REAL,
+    FLOAT32 REAL,
+    FLOAT36 REAL,
+    FLOAT37 REAL,
+    FLOAT38 REAL,
+    FLOAT4 REAL,
+    FLOAT40 REAL,
+    FLOAT41 REAL,
+    FLOAT42 REAL,
+    FLOAT47 REAL,
+    FLOAT48 REAL,
+    FLOAT49 REAL,
+    FLOAT5 REAL,
+    FLOAT52 REAL,
+    FLOAT53 REAL,
+    FLOAT54 REAL,
+    FLOAT56 REAL,
+    FLOAT57 REAL,
+    FLOAT58 REAL,
+    FLOAT6 REAL,
+    FLOAT66 REAL,
+    FLOAT67 REAL,
+    FLOAT68 REAL,
+    FLOAT72 REAL,
+    FLOAT73 REAL,
+    FLOAT74 REAL,
+    FLOAT76 REAL,
+    FLOAT77 REAL,
+    FLOAT78 REAL,
+    FLOAT83 REAL,
+    FLOAT84 REAL,
+    FLOAT85 REAL,
+    FLOAT88 REAL,
+    FLOAT89 REAL,
+    FLOAT90 REAL,
+    FLOAT92 REAL,
+    FLOAT93 REAL,
+    FLOAT94 REAL
 );
 
 ALTER TABLE FIELDSOFFLOAT ADD CONSTRAINT FIELDSOFFLOAT_PK PRIMARY KEY (DATASTORE_IDENTITY);
@@ -2490,78 +2490,78 @@
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     IDENTIFIER INTEGER,
-    FLOAT0 FLOAT NOT NULL,
-    FLOAT1 FLOAT NOT NULL,
-    FLOAT102 FLOAT NOT NULL,
-    FLOAT103 FLOAT NOT NULL,
-    FLOAT104 FLOAT NOT NULL,
-    FLOAT108 FLOAT NOT NULL,
-    FLOAT109 FLOAT NOT NULL,
-    FLOAT11 FLOAT NOT NULL,
-    FLOAT110 FLOAT NOT NULL,
-    FLOAT112 FLOAT NOT NULL,
-    FLOAT113 FLOAT NOT NULL,
-    FLOAT114 FLOAT NOT NULL,
-    FLOAT119 FLOAT NOT NULL,
-    FLOAT12 FLOAT NOT NULL,
-    FLOAT120 FLOAT NOT NULL,
-    FLOAT121 FLOAT NOT NULL,
-    FLOAT124 FLOAT NOT NULL,
-    FLOAT125 FLOAT NOT NULL,
-    FLOAT126 FLOAT NOT NULL,
-    FLOAT128 FLOAT NOT NULL,
-    FLOAT129 FLOAT NOT NULL,
-    FLOAT13 FLOAT NOT NULL,
-    FLOAT130 FLOAT NOT NULL,
-    FLOAT138 FLOAT NOT NULL,
-    FLOAT139 FLOAT NOT NULL,
-    FLOAT140 FLOAT NOT NULL,
-    FLOAT16 FLOAT NOT NULL,
-    FLOAT17 FLOAT NOT NULL,
-    FLOAT18 FLOAT NOT NULL,
-    FLOAT2 FLOAT NOT NULL,
-    FLOAT20 FLOAT NOT NULL,
-    FLOAT21 FLOAT NOT NULL,
-    FLOAT22 FLOAT NOT NULL,
-    FLOAT30 FLOAT NOT NULL,
-    FLOAT31 FLOAT NOT NULL,
-    FLOAT32 FLOAT NOT NULL,
-    FLOAT36 FLOAT NOT NULL,
-    FLOAT37 FLOAT NOT NULL,
-    FLOAT38 FLOAT NOT NULL,
-    FLOAT4 FLOAT NOT NULL,
-    FLOAT40 FLOAT NOT NULL,
-    FLOAT41 FLOAT NOT NULL,
-    FLOAT42 FLOAT NOT NULL,
-    FLOAT47 FLOAT NOT NULL,
-    FLOAT48 FLOAT NOT NULL,
-    FLOAT49 FLOAT NOT NULL,
-    FLOAT5 FLOAT NOT NULL,
-    FLOAT52 FLOAT NOT NULL,
-    FLOAT53 FLOAT NOT NULL,
-    FLOAT54 FLOAT NOT NULL,
-    FLOAT56 FLOAT NOT NULL,
-    FLOAT57 FLOAT NOT NULL,
-    FLOAT58 FLOAT NOT NULL,
-    FLOAT6 FLOAT NOT NULL,
-    FLOAT66 FLOAT NOT NULL,
-    FLOAT67 FLOAT NOT NULL,
-    FLOAT68 FLOAT NOT NULL,
-    FLOAT72 FLOAT NOT NULL,
-    FLOAT73 FLOAT NOT NULL,
-    FLOAT74 FLOAT NOT NULL,
-    FLOAT76 FLOAT NOT NULL,
-    FLOAT77 FLOAT NOT NULL,
-    FLOAT78 FLOAT NOT NULL,
-    FLOAT83 FLOAT NOT NULL,
-    FLOAT84 FLOAT NOT NULL,
-    FLOAT85 FLOAT NOT NULL,
-    FLOAT88 FLOAT NOT NULL,
-    FLOAT89 FLOAT NOT NULL,
-    FLOAT90 FLOAT NOT NULL,
-    FLOAT92 FLOAT NOT NULL,
-    FLOAT93 FLOAT NOT NULL,
-    FLOAT94 FLOAT NOT NULL
+    FLOAT0 REAL NOT NULL,
+    FLOAT1 REAL NOT NULL,
+    FLOAT102 REAL NOT NULL,
+    FLOAT103 REAL NOT NULL,
+    FLOAT104 REAL NOT NULL,
+    FLOAT108 REAL NOT NULL,
+    FLOAT109 REAL NOT NULL,
+    FLOAT11 REAL NOT NULL,
+    FLOAT110 REAL NOT NULL,
+    FLOAT112 REAL NOT NULL,
+    FLOAT113 REAL NOT NULL,
+    FLOAT114 REAL NOT NULL,
+    FLOAT119 REAL NOT NULL,
+    FLOAT12 REAL NOT NULL,
+    FLOAT120 REAL NOT NULL,
+    FLOAT121 REAL NOT NULL,
+    FLOAT124 REAL NOT NULL,
+    FLOAT125 REAL NOT NULL,
+    FLOAT126 REAL NOT NULL,
+    FLOAT128 REAL NOT NULL,
+    FLOAT129 REAL NOT NULL,
+    FLOAT13 REAL NOT NULL,
+    FLOAT130 REAL NOT NULL,
+    FLOAT138 REAL NOT NULL,
+    FLOAT139 REAL NOT NULL,
+    FLOAT140 REAL NOT NULL,
+    FLOAT16 REAL NOT NULL,
+    FLOAT17 REAL NOT NULL,
+    FLOAT18 REAL NOT NULL,
+    FLOAT2 REAL NOT NULL,
+    FLOAT20 REAL NOT NULL,
+    FLOAT21 REAL NOT NULL,
+    FLOAT22 REAL NOT NULL,
+    FLOAT30 REAL NOT NULL,
+    FLOAT31 REAL NOT NULL,
+    FLOAT32 REAL NOT NULL,
+    FLOAT36 REAL NOT NULL,
+    FLOAT37 REAL NOT NULL,
+    FLOAT38 REAL NOT NULL,
+    FLOAT4 REAL NOT NULL,
+    FLOAT40 REAL NOT NULL,
+    FLOAT41 REAL NOT NULL,
+    FLOAT42 REAL NOT NULL,
+    FLOAT47 REAL NOT NULL,
+    FLOAT48 REAL NOT NULL,
+    FLOAT49 REAL NOT NULL,
+    FLOAT5 REAL NOT NULL,
+    FLOAT52 REAL NOT NULL,
+    FLOAT53 REAL NOT NULL,
+    FLOAT54 REAL NOT NULL,
+    FLOAT56 REAL NOT NULL,
+    FLOAT57 REAL NOT NULL,
+    FLOAT58 REAL NOT NULL,
+    FLOAT6 REAL NOT NULL,
+    FLOAT66 REAL NOT NULL,
+    FLOAT67 REAL NOT NULL,
+    FLOAT68 REAL NOT NULL,
+    FLOAT72 REAL NOT NULL,
+    FLOAT73 REAL NOT NULL,
+    FLOAT74 REAL NOT NULL,
+    FLOAT76 REAL NOT NULL,
+    FLOAT77 REAL NOT NULL,
+    FLOAT78 REAL NOT NULL,
+    FLOAT83 REAL NOT NULL,
+    FLOAT84 REAL NOT NULL,
+    FLOAT85 REAL NOT NULL,
+    FLOAT88 REAL NOT NULL,
+    FLOAT89 REAL NOT NULL,
+    FLOAT90 REAL NOT NULL,
+    FLOAT92 REAL NOT NULL,
+    FLOAT93 REAL NOT NULL,
+    FLOAT94 REAL NOT NULL
 );
 
 ALTER TABLE FIELDSOFPRIMITIVEFLOAT ADD CONSTRAINT FIELDSOFPRIMR3_PK PRIMARY KEY (DATASTORE_IDENTITY);
@@ -3261,7 +3261,7 @@
 (
     IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
     ORDER_COL BIGINT,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE ARRAY_OF_INTEGER23
@@ -3477,14 +3477,14 @@
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE COLLECTION_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE COLLECTION_OF_INTEGER33
@@ -3721,14 +3721,14 @@
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE LIST_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE LIST_OF_INTEGER33
@@ -3957,14 +3957,14 @@
 CREATE TABLE ARRAYLIST_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE ARRAYLIST_OF_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INDEX INTEGER NOT NULL
 );
 
@@ -4202,14 +4202,14 @@
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE LINKEDLIST_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE LINKEDLIST_OF_INTEGER33
@@ -4446,14 +4446,14 @@
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE VECTOR_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE VECTOR_OF_INTEGER33
@@ -4651,13 +4651,13 @@
 CREATE TABLE SET_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE SET_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE SET_OF_INTEGER33
@@ -4849,13 +4849,13 @@
 CREATE TABLE HASHSET_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE HASHSET_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT
+    FLOATVAL REAL
 );
 
 CREATE TABLE HASHSET_OF_INTEGER33
@@ -5063,14 +5063,14 @@
 CREATE TABLE TREESET_OF_FLOAT27
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREESET_OF_FLOAT29
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INDEX INTEGER NOT NULL
 );
 
@@ -5353,21 +5353,21 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_INTEGER33
@@ -5589,14 +5589,14 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_FLOAT73
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_INTEGER75
@@ -5715,7 +5715,7 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_INTEGER117
@@ -5976,21 +5976,21 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_INTEGER33
@@ -6212,14 +6212,14 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_FLOAT73
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_INTEGER75
@@ -6338,7 +6338,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_INTEGER117
@@ -6599,21 +6599,21 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_INTEGER33
@@ -6835,14 +6835,14 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_FLOAT73
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_INTEGER75
@@ -6961,7 +6961,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_INTEGER117
@@ -7352,37 +7352,37 @@
 CREATE TABLE HASHMAP_FLOAT81_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_FLOAT82_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_FLOAT83_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_FLOAT84_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_FLOAT85_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_FLOAT87_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHMAP_INTEGER90_STR (
@@ -7859,37 +7859,37 @@
 CREATE TABLE HASHTBL_FLOAT81_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_FLOAT82_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_FLOAT83_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_FLOAT84_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_FLOAT85_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_FLOAT87_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE HASHTBL_INTEGER90_STR (
@@ -8366,37 +8366,37 @@
 CREATE TABLE TREEMAP_FLOAT81_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_FLOAT82_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_FLOAT83_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_FLOAT84_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_FLOAT85_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_FLOAT87_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE TREEMAP_INTEGER90_STR (
@@ -8873,37 +8873,37 @@
 CREATE TABLE MAP_FLOAT81_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_FLOAT82_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_FLOAT83_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_FLOAT84_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_FLOAT85_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_FLOAT87_STR (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL FLOAT
+    KEYVAL REAL
 );
 
 CREATE TABLE MAP_INTEGER90_STR (
@@ -9251,21 +9251,21 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_INTEGER33
@@ -9487,14 +9487,14 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_FLOAT73
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_INTEGER75
@@ -9613,7 +9613,7 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL FLOAT NOT NULL
+    VALUEVAL REAL NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_INTEGER117
@@ -9651,7 +9651,7 @@
     KEY_VALUE INTEGER,
     DOUBLE_B DOUBLE,
     INT_B INTEGER,
-    FLOAT_E FLOAT,
+    FLOAT_E REAL,
     SHORT_F SMALLINT,
     SECOND_OBJ INTEGER,
     THIRD_OBJ INTEGER,
@@ -9667,7 +9667,7 @@
     KEY_VALUE INTEGER,
     DOUBLE_B DOUBLE,
     INT_B INTEGER,
-    FLOAT_E FLOAT,
+    FLOAT_E REAL,
     SHORT_F SMALLINT,
     SECOND_OBJ INTEGER,
     THIRD_OBJ INTEGER,
@@ -9683,7 +9683,7 @@
     KEY_VALUE INTEGER,
     DOUBLE_B DOUBLE,
     INT_B INTEGER,
-    FLOAT_E FLOAT,
+    FLOAT_E REAL,
     SHORT_F SMALLINT,
     SECOND_OBJ INTEGER,
     THIRD_OBJ INTEGER,
@@ -9699,7 +9699,7 @@
     KEY_VALUE INTEGER,
     N2 DOUBLE,
     N3 INTEGER,
-    FSN2_N3 FLOAT,
+    FSN2_N3 REAL,
     FSN3_N1 SMALLINT,
     FSN3_N2 INTEGER,
     FSN3_N3 INTEGER,
@@ -9722,7 +9722,7 @@
     ICKEY INTEGER,
     D DOUBLE,
     S SMALLINT,
-    FLOATVAL FLOAT,
+    FLOATVAL REAL,
     INTVAL INTEGER,
     CONSTRAINT ICNP_PK PRIMARY KEY (DATASTORE_IDENTITY)
 );



Mime
View raw message