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/11/10 21:57:21 UTC

svn commit: r332368 - in /incubator/jdo/trunk/tck20/test/sql/derby: applicationidentity/schema.sql datastoreidentity/schema.sql

Author: mcaisse
Date: Thu Nov 10 12:57:19 2005
New Revision: 332368

URL: http://svn.apache.org/viewcvs?rev=332368&view=rev
Log:
JDO-210

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=332368&r1=332367&r2=332368&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql Thu Nov 10 12:57:19 2005
@@ -1269,78 +1269,78 @@
 CREATE TABLE FIELDSOFBIGDECIMAL
 (
     IDENTIFIER INTEGER NOT NULL,
-    BIG_DECIMAL0 DECIMAL(17,6),
-    BIG_DECIMAL1 DECIMAL(17,6),
-    BIG_DECIMAL102 DECIMAL(17,6),
-    BIG_DECIMAL103 DECIMAL(17,6),
-    BIG_DECIMAL104 DECIMAL(17,6),
-    BIG_DECIMAL108 DECIMAL(17,6),
-    BIG_DECIMAL109 DECIMAL(17,6),
-    BIG_DECIMAL11 DECIMAL(17,6),
-    BIG_DECIMAL110 DECIMAL(17,6),
-    BIG_DECIMAL112 DECIMAL(17,6),
-    BIG_DECIMAL113 DECIMAL(17,6),
-    BIG_DECIMAL114 DECIMAL(17,6),
-    BIG_DECIMAL119 DECIMAL(17,6),
-    BIG_DECIMAL12 DECIMAL(17,6),
-    BIG_DECIMAL120 DECIMAL(17,6),
-    BIG_DECIMAL121 DECIMAL(17,6),
-    BIG_DECIMAL124 DECIMAL(17,6),
-    BIG_DECIMAL125 DECIMAL(17,6),
-    BIG_DECIMAL126 DECIMAL(17,6),
-    BIG_DECIMAL128 DECIMAL(17,6),
-    BIG_DECIMAL129 DECIMAL(17,6),
-    BIG_DECIMAL13 DECIMAL(17,6),
-    BIG_DECIMAL130 DECIMAL(17,6),
-    BIG_DECIMAL138 DECIMAL(17,6),
-    BIG_DECIMAL139 DECIMAL(17,6),
-    BIG_DECIMAL140 DECIMAL(17,6),
-    BIG_DECIMAL16 DECIMAL(17,6),
-    BIG_DECIMAL17 DECIMAL(17,6),
-    BIG_DECIMAL18 DECIMAL(17,6),
-    BIG_DECIMAL2 DECIMAL(17,6),
-    BIG_DECIMAL20 DECIMAL(17,6),
-    BIG_DECIMAL21 DECIMAL(17,6),
-    BIG_DECIMAL22 DECIMAL(17,6),
-    BIG_DECIMAL30 DECIMAL(17,6),
-    BIG_DECIMAL31 DECIMAL(17,6),
-    BIG_DECIMAL32 DECIMAL(17,6),
-    BIG_DECIMAL36 DECIMAL(17,6),
-    BIG_DECIMAL37 DECIMAL(17,6),
-    BIG_DECIMAL38 DECIMAL(17,6),
-    BIG_DECIMAL4 DECIMAL(17,6),
-    BIG_DECIMAL40 DECIMAL(17,6),
-    BIG_DECIMAL41 DECIMAL(17,6),
-    BIG_DECIMAL42 DECIMAL(17,6),
-    BIG_DECIMAL47 DECIMAL(17,6),
-    BIG_DECIMAL48 DECIMAL(17,6),
-    BIG_DECIMAL49 DECIMAL(17,6),
-    BIG_DECIMAL5 DECIMAL(17,6),
-    BIG_DECIMAL52 DECIMAL(17,6),
-    BIG_DECIMAL53 DECIMAL(17,6),
-    BIG_DECIMAL54 DECIMAL(17,6),
-    BIG_DECIMAL56 DECIMAL(17,6),
-    BIG_DECIMAL57 DECIMAL(17,6),
-    BIG_DECIMAL58 DECIMAL(17,6),
-    BIG_DECIMAL6 DECIMAL(17,6),
-    BIG_DECIMAL66 DECIMAL(17,6),
-    BIG_DECIMAL67 DECIMAL(17,6),
-    BIG_DECIMAL68 DECIMAL(17,6),
-    BIG_DECIMAL72 DECIMAL(17,6),
-    BIG_DECIMAL73 DECIMAL(17,6),
-    BIG_DECIMAL74 DECIMAL(17,6),
-    BIG_DECIMAL76 DECIMAL(17,6),
-    BIG_DECIMAL77 DECIMAL(17,6),
-    BIG_DECIMAL78 DECIMAL(17,6),
-    BIG_DECIMAL83 DECIMAL(17,6),
-    BIG_DECIMAL84 DECIMAL(17,6),
-    BIG_DECIMAL85 DECIMAL(17,6),
-    BIG_DECIMAL88 DECIMAL(17,6),
-    BIG_DECIMAL89 DECIMAL(17,6),
-    BIG_DECIMAL90 DECIMAL(17,6),
-    BIG_DECIMAL92 DECIMAL(17,6),
-    BIG_DECIMAL93 DECIMAL(17,6),
-    BIG_DECIMAL94 DECIMAL(17,6)
+    BIG_DECIMAL0 DECIMAL(27,16),
+    BIG_DECIMAL1 DECIMAL(27,16),
+    BIG_DECIMAL102 DECIMAL(27,16),
+    BIG_DECIMAL103 DECIMAL(27,16),
+    BIG_DECIMAL104 DECIMAL(27,16),
+    BIG_DECIMAL108 DECIMAL(27,16),
+    BIG_DECIMAL109 DECIMAL(27,16),
+    BIG_DECIMAL11 DECIMAL(27,16),
+    BIG_DECIMAL110 DECIMAL(27,16),
+    BIG_DECIMAL112 DECIMAL(27,16),
+    BIG_DECIMAL113 DECIMAL(27,16),
+    BIG_DECIMAL114 DECIMAL(27,16),
+    BIG_DECIMAL119 DECIMAL(27,16),
+    BIG_DECIMAL12 DECIMAL(27,16),
+    BIG_DECIMAL120 DECIMAL(27,16),
+    BIG_DECIMAL121 DECIMAL(27,16),
+    BIG_DECIMAL124 DECIMAL(27,16),
+    BIG_DECIMAL125 DECIMAL(27,16),
+    BIG_DECIMAL126 DECIMAL(27,16),
+    BIG_DECIMAL128 DECIMAL(27,16),
+    BIG_DECIMAL129 DECIMAL(27,16),
+    BIG_DECIMAL13 DECIMAL(27,16),
+    BIG_DECIMAL130 DECIMAL(27,16),
+    BIG_DECIMAL138 DECIMAL(27,16),
+    BIG_DECIMAL139 DECIMAL(27,16),
+    BIG_DECIMAL140 DECIMAL(27,16),
+    BIG_DECIMAL16 DECIMAL(27,16),
+    BIG_DECIMAL17 DECIMAL(27,16),
+    BIG_DECIMAL18 DECIMAL(27,16),
+    BIG_DECIMAL2 DECIMAL(27,16),
+    BIG_DECIMAL20 DECIMAL(27,16),
+    BIG_DECIMAL21 DECIMAL(27,16),
+    BIG_DECIMAL22 DECIMAL(27,16),
+    BIG_DECIMAL30 DECIMAL(27,16),
+    BIG_DECIMAL31 DECIMAL(27,16),
+    BIG_DECIMAL32 DECIMAL(27,16),
+    BIG_DECIMAL36 DECIMAL(27,16),
+    BIG_DECIMAL37 DECIMAL(27,16),
+    BIG_DECIMAL38 DECIMAL(27,16),
+    BIG_DECIMAL4 DECIMAL(27,16),
+    BIG_DECIMAL40 DECIMAL(27,16),
+    BIG_DECIMAL41 DECIMAL(27,16),
+    BIG_DECIMAL42 DECIMAL(27,16),
+    BIG_DECIMAL47 DECIMAL(27,16),
+    BIG_DECIMAL48 DECIMAL(27,16),
+    BIG_DECIMAL49 DECIMAL(27,16),
+    BIG_DECIMAL5 DECIMAL(27,16),
+    BIG_DECIMAL52 DECIMAL(27,16),
+    BIG_DECIMAL53 DECIMAL(27,16),
+    BIG_DECIMAL54 DECIMAL(27,16),
+    BIG_DECIMAL56 DECIMAL(27,16),
+    BIG_DECIMAL57 DECIMAL(27,16),
+    BIG_DECIMAL58 DECIMAL(27,16),
+    BIG_DECIMAL6 DECIMAL(27,16),
+    BIG_DECIMAL66 DECIMAL(27,16),
+    BIG_DECIMAL67 DECIMAL(27,16),
+    BIG_DECIMAL68 DECIMAL(27,16),
+    BIG_DECIMAL72 DECIMAL(27,16),
+    BIG_DECIMAL73 DECIMAL(27,16),
+    BIG_DECIMAL74 DECIMAL(27,16),
+    BIG_DECIMAL76 DECIMAL(27,16),
+    BIG_DECIMAL77 DECIMAL(27,16),
+    BIG_DECIMAL78 DECIMAL(27,16),
+    BIG_DECIMAL83 DECIMAL(27,16),
+    BIG_DECIMAL84 DECIMAL(27,16),
+    BIG_DECIMAL85 DECIMAL(27,16),
+    BIG_DECIMAL88 DECIMAL(27,16),
+    BIG_DECIMAL89 DECIMAL(27,16),
+    BIG_DECIMAL90 DECIMAL(27,16),
+    BIG_DECIMAL92 DECIMAL(27,16),
+    BIG_DECIMAL93 DECIMAL(27,16),
+    BIG_DECIMAL94 DECIMAL(27,16)
 );
 
 ALTER TABLE FIELDSOFBIGDECIMAL ADD CONSTRAINT FIELDSOFBIGDPP_PK PRIMARY KEY (IDENTIFIER);
@@ -5372,21 +5372,21 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_INTEGER21
@@ -5636,14 +5636,14 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_DECIMAL61
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_INTEGER63
@@ -5748,6 +5748,7 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
+	VALUEVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS87
@@ -5789,7 +5790,7 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_INTEGER105
@@ -5993,21 +5994,21 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_INTEGER21
@@ -6257,14 +6258,14 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_DECIMAL61
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_INTEGER63
@@ -6411,7 +6412,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_INTEGER105
@@ -6615,21 +6616,21 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_INTEGER21
@@ -6879,14 +6880,14 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_DECIMAL61
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_INTEGER63
@@ -7033,7 +7034,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_INTEGER105
@@ -9261,21 +9262,21 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_INTEGER21
@@ -9525,14 +9526,14 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_DECIMAL61
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_INTEGER63
@@ -9679,7 +9680,7 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_INTEGER105

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=332368&r1=332367&r2=332368&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql Thu Nov 10 12:57:19 2005
@@ -5367,21 +5367,21 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_INTEGER21
@@ -5631,14 +5631,14 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_DECIMAL61
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_INTEGER63
@@ -5785,7 +5785,7 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_INTEGER105
@@ -5990,21 +5990,21 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_INTEGER21
@@ -6254,14 +6254,14 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_DECIMAL61
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_INTEGER63
@@ -6408,7 +6408,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_BIG_INTEGER105
@@ -6613,21 +6613,21 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_INTEGER21
@@ -6877,14 +6877,14 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_DECIMAL61
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_INTEGER63
@@ -7031,7 +7031,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_BIG_INTEGER105
@@ -9265,21 +9265,21 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_INTEGER21
@@ -9529,14 +9529,14 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_DECIMAL61
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_INTEGER63
@@ -9683,7 +9683,7 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    VALUEVAL DECIMAL(17,6) NOT NULL
+    VALUEVAL DECIMAL(27,16) NOT NULL
 );
 
 CREATE TABLE TREEMAP_STR_BIG_INTEGER105