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/10 22:35:15 UTC
svn commit: r312732 [4/5] - in /incubator/jdo/trunk/tck20/test:
java/org/apache/jdo/tck/models/fieldtypes/
java/org/apache/jdo/tck/pc/fieldtypes/
jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/
jdo/datastoreidentity/org/apache/jdo/tck/pc/fiel...
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=312732&r1=312731&r2=312732&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql Mon Oct 10 13:35:04 2005
@@ -2808,7 +2808,7 @@
CREATE TABLE ARRAY_OF_BIG_DECIMAL13
(
IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6)
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE ARRAY_OF_BIG_INTEGER15
@@ -2988,14 +2988,14 @@
(
IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
ALLOW_DUPLICATES BIGINT NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6)
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE COLLECTION_OF_BIG_DECIMAL19
(
IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
ALLOW_DUPLICATES BIGINT NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6)
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE COLLECTION_OF_BIG_INTEGER21
@@ -3101,235 +3101,242 @@
CREATE TABLE LIST_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- LIST_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- LIST_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- LIST_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- LIST_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- LIST_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- LIST_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- LIST_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- LIST_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- LIST_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- LIST_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- LIST_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_STRING11 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_DATE14 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_LOCALE17 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_BIG_DECIMAL20 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_BIG_INTEGER23 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_BYTE26 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_DOUBLE29 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_FLOAT32 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_INTEGER35 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_LONG38 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_SHORT41 LONG VARCHAR FOR BIT DATA,
+ LIST_OF_SIMPLE_CLASS42 LONG VARCHAR FOR BIT DATA,
CONSTRAINT LC_PK PRIMARY KEY (IDENTIFIER)
);
CREATE TABLE LIST_OF_OBJECT0
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE LIST_OF_OBJECT1
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE LIST_OF_OBJECT2
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE LIST_OF_SIMPLE_CLASS3
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE LIST_OF_SIMPLE_CLASS4
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE LIST_OF_SIMPLE_CLASS5
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE LIST_OF_SIMPLE_INTERFACE6
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE LIST_OF_SIMPLE_INTERFACE7
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE LIST_OF_SIMPLE_INTERFACE8
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE LIST_OF_STRING9
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- STRINGVAL VARCHAR(1024),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ STRINGVAL VARCHAR(1024)
);
-CREATE TABLE LIST_OF_STRING11
+CREATE TABLE LIST_OF_STRING10
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- STRINGVAL VARCHAR(1024),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ STRINGVAL VARCHAR(1024)
);
CREATE TABLE LIST_OF_DATE12
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- DATEVAL TIMESTAMP,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DATEVAL TIMESTAMP
);
-CREATE TABLE LIST_OF_DATE14
+CREATE TABLE LIST_OF_DATE13
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- DATEVAL TIMESTAMP,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DATEVAL TIMESTAMP
);
CREATE TABLE LIST_OF_LOCALE15
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- LOCALEVAL CHAR(20),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LOCALEVAL CHAR(20)
);
-CREATE TABLE LIST_OF_LOCALE17
+CREATE TABLE LIST_OF_LOCALE16
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- LOCALEVAL CHAR(20),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LOCALEVAL CHAR(20)
);
CREATE TABLE LIST_OF_BIG_DECIMAL18
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_DECIMALVAL DECIMAL(27,16)
);
-CREATE TABLE LIST_OF_BIG_DECIMAL20
+CREATE TABLE LIST_OF_BIG_DECIMAL19
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE LIST_OF_BIG_INTEGER21
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- BIG_INTEGERVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_INTEGERVAL BIGINT
);
-CREATE TABLE LIST_OF_BIG_INTEGER23
+CREATE TABLE LIST_OF_BIG_INTEGER22
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- BIG_INTEGERVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_INTEGERVAL BIGINT
);
CREATE TABLE LIST_OF_BYTE24
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- BYTEVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BYTEVAL SMALLINT
);
-CREATE TABLE LIST_OF_BYTE26
+CREATE TABLE LIST_OF_BYTE25
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- BYTEVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BYTEVAL SMALLINT
);
CREATE TABLE LIST_OF_DOUBLE27
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- DOUBLEVAL DOUBLE,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DOUBLEVAL DOUBLE
);
-CREATE TABLE LIST_OF_DOUBLE29
+CREATE TABLE LIST_OF_DOUBLE28
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- DOUBLEVAL DOUBLE,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DOUBLEVAL DOUBLE
);
CREATE TABLE LIST_OF_FLOAT30
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- FLOATVAL FLOAT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ FLOATVAL FLOAT
);
-CREATE TABLE LIST_OF_FLOAT32
+CREATE TABLE LIST_OF_FLOAT31
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- FLOATVAL FLOAT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ FLOATVAL FLOAT
);
CREATE TABLE LIST_OF_INTEGER33
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- INTEGERVAL INTEGER,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ INTEGERVAL INTEGER
);
-CREATE TABLE LIST_OF_INTEGER35
+CREATE TABLE LIST_OF_INTEGER34
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- INTEGERVAL INTEGER,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ INTEGERVAL INTEGER
);
CREATE TABLE LIST_OF_LONG36
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- LONGVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LONGVAL BIGINT
);
-CREATE TABLE LIST_OF_LONG38
+CREATE TABLE LIST_OF_LONG37
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- LONGVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LONGVAL BIGINT
);
CREATE TABLE LIST_OF_SHORT39
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- SHORTVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SHORTVAL SMALLINT
);
-CREATE TABLE LIST_OF_SHORT41
+CREATE TABLE LIST_OF_SHORT40
(
IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
- SHORTVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SHORTVAL SMALLINT
);
--ArrayListCollections
@@ -3459,14 +3466,14 @@
CREATE TABLE ARRAYLIST_OF_BIG_DECIMAL18
(
IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
+ BIG_DECIMALVAL DECIMAL(27,16),
INDEX INTEGER NOT NULL
);
CREATE TABLE ARRAYLIST_OF_BIG_DECIMAL20
(
IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
+ BIG_DECIMALVAL DECIMAL(27,16),
INDEX INTEGER NOT NULL
);
@@ -3573,235 +3580,242 @@
CREATE TABLE LINKEDLIST_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- LINKEDLIST_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- LINKEDLIST_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_STRING11 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_DATE14 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_LOCALE17 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_BIG_DECIMAL20 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_BIG_INTEGER23 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_BYTE26 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_DOUBLE29 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_FLOAT32 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_INTEGER35 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_LONG38 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_SHORT41 LONG VARCHAR FOR BIT DATA,
+ LINKEDLIST_OF_SIMPLE_CLASS42 LONG VARCHAR FOR BIT DATA,
CONSTRAINT LLC_PK PRIMARY KEY (IDENTIFIER)
);
CREATE TABLE LINKEDLIST_OF_OBJECT0
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE LINKEDLIST_OF_OBJECT1
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE LINKEDLIST_OF_OBJECT2
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE LINKEDLIST_OF_SIMPLE_CLASS3
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE LINKEDLIST_OF_SIMPLE_CLASS4
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE LINKEDLIST_OF_SIMPLE_CLASS5
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE LINKEDLIST_OF_SIMPLE_INTERFACE6
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE LINKEDLIST_OF_SIMPLE_INTERFACE7
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE LINKEDLIST_OF_SIMPLE_INTERFACE8
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE LINKEDLIST_OF_STRING9
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- STRINGVAL VARCHAR(1024),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ STRINGVAL VARCHAR(1024)
);
-CREATE TABLE LINKEDLIST_OF_STRING11
+CREATE TABLE LINKEDLIST_OF_STRING10
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- STRINGVAL VARCHAR(1024),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ STRINGVAL VARCHAR(1024)
);
CREATE TABLE LINKEDLIST_OF_DATE12
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- DATEVAL TIMESTAMP,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DATEVAL TIMESTAMP
);
-CREATE TABLE LINKEDLIST_OF_DATE14
+CREATE TABLE LINKEDLIST_OF_DATE13
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- DATEVAL TIMESTAMP,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DATEVAL TIMESTAMP
);
CREATE TABLE LINKEDLIST_OF_LOCALE15
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- LOCALEVAL CHAR(20),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LOCALEVAL CHAR(20)
);
-CREATE TABLE LINKEDLIST_OF_LOCALE17
+CREATE TABLE LINKEDLIST_OF_LOCALE16
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- LOCALEVAL CHAR(20),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LOCALEVAL CHAR(20)
);
CREATE TABLE LINKEDLIST_OF_BIG_DECIMAL18
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_DECIMALVAL DECIMAL(27,16)
);
-CREATE TABLE LINKEDLIST_OF_BIG_DECIMAL20
+CREATE TABLE LINKEDLIST_OF_BIG_DECIMAL19
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE LINKEDLIST_OF_BIG_INTEGER21
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- BIG_INTEGERVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_INTEGERVAL BIGINT
);
-CREATE TABLE LINKEDLIST_OF_BIG_INTEGER23
+CREATE TABLE LINKEDLIST_OF_BIG_INTEGER22
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- BIG_INTEGERVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_INTEGERVAL BIGINT
);
CREATE TABLE LINKEDLIST_OF_BYTE24
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- BYTEVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BYTEVAL SMALLINT
);
-CREATE TABLE LINKEDLIST_OF_BYTE26
+CREATE TABLE LINKEDLIST_OF_BYTE25
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- BYTEVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BYTEVAL SMALLINT
);
CREATE TABLE LINKEDLIST_OF_DOUBLE27
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- DOUBLEVAL DOUBLE,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DOUBLEVAL DOUBLE
);
-CREATE TABLE LINKEDLIST_OF_DOUBLE29
+CREATE TABLE LINKEDLIST_OF_DOUBLE28
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- DOUBLEVAL DOUBLE,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DOUBLEVAL DOUBLE
);
CREATE TABLE LINKEDLIST_OF_FLOAT30
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- FLOATVAL FLOAT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ FLOATVAL FLOAT
);
-CREATE TABLE LINKEDLIST_OF_FLOAT32
+CREATE TABLE LINKEDLIST_OF_FLOAT31
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- FLOATVAL FLOAT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ FLOATVAL FLOAT
);
CREATE TABLE LINKEDLIST_OF_INTEGER33
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- INTEGERVAL INTEGER,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ INTEGERVAL INTEGER
);
-CREATE TABLE LINKEDLIST_OF_INTEGER35
+CREATE TABLE LINKEDLIST_OF_INTEGER34
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- INTEGERVAL INTEGER,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ INTEGERVAL INTEGER
);
CREATE TABLE LINKEDLIST_OF_LONG36
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- LONGVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LONGVAL BIGINT
);
-CREATE TABLE LINKEDLIST_OF_LONG38
+CREATE TABLE LINKEDLIST_OF_LONG37
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- LONGVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LONGVAL BIGINT
);
CREATE TABLE LINKEDLIST_OF_SHORT39
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- SHORTVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SHORTVAL SMALLINT
);
-CREATE TABLE LINKEDLIST_OF_SHORT41
+CREATE TABLE LINKEDLIST_OF_SHORT40
(
IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
- SHORTVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SHORTVAL SMALLINT
);
--VectorCollections
@@ -3809,235 +3823,242 @@
CREATE TABLE VECTOR_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- VECTOR_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- VECTOR_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_STRING11 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_DATE14 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_LOCALE17 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_BIG_DECIMAL20 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_BIG_INTEGER23 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_BYTE26 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_DOUBLE29 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_FLOAT32 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_INTEGER35 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_LONG38 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_SHORT41 LONG VARCHAR FOR BIT DATA,
+ VECTOR_OF_SIMPLE_CLASS42 LONG VARCHAR FOR BIT DATA,
CONSTRAINT VC_PK PRIMARY KEY (IDENTIFIER)
);
CREATE TABLE VECTOR_OF_OBJECT0
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE VECTOR_OF_OBJECT1
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE VECTOR_OF_OBJECT2
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE VECTOR_OF_SIMPLE_CLASS3
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE VECTOR_OF_SIMPLE_CLASS4
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE VECTOR_OF_SIMPLE_CLASS5
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE VECTOR_OF_SIMPLE_INTERFACE6
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE VECTOR_OF_SIMPLE_INTERFACE7
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE VECTOR_OF_SIMPLE_INTERFACE8
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE VECTOR_OF_STRING9
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- STRINGVAL VARCHAR(1024),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ STRINGVAL VARCHAR(1024)
);
-CREATE TABLE VECTOR_OF_STRING11
+CREATE TABLE VECTOR_OF_STRING10
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- STRINGVAL VARCHAR(1024),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ STRINGVAL VARCHAR(1024)
);
CREATE TABLE VECTOR_OF_DATE12
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- DATEVAL TIMESTAMP,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DATEVAL TIMESTAMP
);
-CREATE TABLE VECTOR_OF_DATE14
+CREATE TABLE VECTOR_OF_DATE13
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- DATEVAL TIMESTAMP,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DATEVAL TIMESTAMP
);
CREATE TABLE VECTOR_OF_LOCALE15
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- LOCALEVAL CHAR(20),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LOCALEVAL CHAR(20)
);
-CREATE TABLE VECTOR_OF_LOCALE17
+CREATE TABLE VECTOR_OF_LOCALE16
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- LOCALEVAL CHAR(20),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LOCALEVAL CHAR(20)
);
CREATE TABLE VECTOR_OF_BIG_DECIMAL18
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_DECIMALVAL DECIMAL(27,16)
);
-CREATE TABLE VECTOR_OF_BIG_DECIMAL20
+CREATE TABLE VECTOR_OF_BIG_DECIMAL19
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE VECTOR_OF_BIG_INTEGER21
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- BIG_INTEGERVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_INTEGERVAL BIGINT
);
-CREATE TABLE VECTOR_OF_BIG_INTEGER23
+CREATE TABLE VECTOR_OF_BIG_INTEGER22
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- BIG_INTEGERVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_INTEGERVAL BIGINT
);
CREATE TABLE VECTOR_OF_BYTE24
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- BYTEVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BYTEVAL SMALLINT
);
-CREATE TABLE VECTOR_OF_BYTE26
+CREATE TABLE VECTOR_OF_BYTE25
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- BYTEVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BYTEVAL SMALLINT
);
CREATE TABLE VECTOR_OF_DOUBLE27
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- DOUBLEVAL DOUBLE,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DOUBLEVAL DOUBLE
);
-CREATE TABLE VECTOR_OF_DOUBLE29
+CREATE TABLE VECTOR_OF_DOUBLE28
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- DOUBLEVAL DOUBLE,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ DOUBLEVAL DOUBLE
);
CREATE TABLE VECTOR_OF_FLOAT30
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- FLOATVAL FLOAT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ FLOATVAL FLOAT
);
-CREATE TABLE VECTOR_OF_FLOAT32
+CREATE TABLE VECTOR_OF_FLOAT31
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- FLOATVAL FLOAT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ FLOATVAL FLOAT
);
CREATE TABLE VECTOR_OF_INTEGER33
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- INTEGERVAL INTEGER,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ INTEGERVAL INTEGER
);
-CREATE TABLE VECTOR_OF_INTEGER35
+CREATE TABLE VECTOR_OF_INTEGER34
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- INTEGERVAL INTEGER,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ INTEGERVAL INTEGER
);
CREATE TABLE VECTOR_OF_LONG36
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- LONGVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LONGVAL BIGINT
);
-CREATE TABLE VECTOR_OF_LONG38
+CREATE TABLE VECTOR_OF_LONG37
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- LONGVAL BIGINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ LONGVAL BIGINT
);
CREATE TABLE VECTOR_OF_SHORT39
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- SHORTVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SHORTVAL SMALLINT
);
-CREATE TABLE VECTOR_OF_SHORT41
+CREATE TABLE VECTOR_OF_SHORT40
(
IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
- SHORTVAL SMALLINT,
- INDEX INTEGER NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ SHORTVAL SMALLINT
);
--SetCollections
@@ -4045,203 +4066,241 @@
CREATE TABLE SET_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- SET_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- SET_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- SET_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- SET_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- SET_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- SET_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- SET_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- SET_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- SET_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- SET_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- SET_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+ SET_OF_STRING11 LONG VARCHAR FOR BIT DATA,
+ SET_OF_DATE14 LONG VARCHAR FOR BIT DATA,
+ SET_OF_LOCALE17 LONG VARCHAR FOR BIT DATA,
+ SET_OF_BIG_DECIMAL20 LONG VARCHAR FOR BIT DATA,
+ SET_OF_BIG_INTEGER23 LONG VARCHAR FOR BIT DATA,
+ SET_OF_BYTE26 LONG VARCHAR FOR BIT DATA,
+ SET_OF_DOUBLE29 LONG VARCHAR FOR BIT DATA,
+ SET_OF_FLOAT32 LONG VARCHAR FOR BIT DATA,
+ SET_OF_INTEGER35 LONG VARCHAR FOR BIT DATA,
+ SET_OF_LONG38 LONG VARCHAR FOR BIT DATA,
+ SET_OF_SHORT41 LONG VARCHAR FOR BIT DATA,
+ SET_OF_SIMPLE_CLASS42 LONG VARCHAR FOR BIT DATA,
CONSTRAINT SC_PK PRIMARY KEY (IDENTIFIER)
);
CREATE TABLE SET_OF_OBJECT0
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE SET_OF_OBJECT1
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE SET_OF_OBJECT2
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE SET_OF_SIMPLE_CLASS3
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE SET_OF_SIMPLE_CLASS4
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE SET_OF_SIMPLE_CLASS5
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE SET_OF_SIMPLE_INTERFACE6
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE SET_OF_SIMPLE_INTERFACE7
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE SET_OF_SIMPLE_INTERFACE8
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE SET_OF_STRING9
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
STRINGVAL VARCHAR(1024)
);
-CREATE TABLE SET_OF_STRING11
+CREATE TABLE SET_OF_STRING10
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
STRINGVAL VARCHAR(1024)
);
CREATE TABLE SET_OF_DATE12
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
DATEVAL TIMESTAMP
);
-CREATE TABLE SET_OF_DATE14
+CREATE TABLE SET_OF_DATE13
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
DATEVAL TIMESTAMP
);
CREATE TABLE SET_OF_LOCALE15
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
LOCALEVAL CHAR(20)
);
-CREATE TABLE SET_OF_LOCALE17
+CREATE TABLE SET_OF_LOCALE16
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
LOCALEVAL CHAR(20)
);
CREATE TABLE SET_OF_BIG_DECIMAL18
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6)
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_DECIMALVAL DECIMAL(27,16)
);
-CREATE TABLE SET_OF_BIG_DECIMAL20
+CREATE TABLE SET_OF_BIG_DECIMAL19
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6)
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE SET_OF_BIG_INTEGER21
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
BIG_INTEGERVAL BIGINT
);
-CREATE TABLE SET_OF_BIG_INTEGER23
+CREATE TABLE SET_OF_BIG_INTEGER22
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
BIG_INTEGERVAL BIGINT
);
CREATE TABLE SET_OF_BYTE24
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
BYTEVAL SMALLINT
);
-CREATE TABLE SET_OF_BYTE26
+CREATE TABLE SET_OF_BYTE25
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
BYTEVAL SMALLINT
);
CREATE TABLE SET_OF_DOUBLE27
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
DOUBLEVAL DOUBLE
);
-CREATE TABLE SET_OF_DOUBLE29
+CREATE TABLE SET_OF_DOUBLE28
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
DOUBLEVAL DOUBLE
);
CREATE TABLE SET_OF_FLOAT30
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
FLOATVAL FLOAT
);
-CREATE TABLE SET_OF_FLOAT32
+CREATE TABLE SET_OF_FLOAT31
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
FLOATVAL FLOAT
);
CREATE TABLE SET_OF_INTEGER33
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
INTEGERVAL INTEGER
);
-CREATE TABLE SET_OF_INTEGER35
+CREATE TABLE SET_OF_INTEGER34
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
INTEGERVAL INTEGER
);
CREATE TABLE SET_OF_LONG36
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
LONGVAL BIGINT
);
-CREATE TABLE SET_OF_LONG38
+CREATE TABLE SET_OF_LONG37
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
LONGVAL BIGINT
);
CREATE TABLE SET_OF_SHORT39
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
SHORTVAL SMALLINT
);
-CREATE TABLE SET_OF_SHORT41
+CREATE TABLE SET_OF_SHORT40
(
IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
SHORTVAL SMALLINT
);
@@ -4250,203 +4309,241 @@
CREATE TABLE HASHSET_COLLECTIONS
(
IDENTIFIER INTEGER NOT NULL,
- HASHSET_OF_STRING10 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_DATE13 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_LONG37 LONG VARCHAR FOR BIT DATA,
- HASHSET_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_STRING11 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_DATE14 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_LOCALE17 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_BIG_DECIMAL20 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_BIG_INTEGER23 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_BYTE26 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_DOUBLE29 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_FLOAT32 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_INTEGER35 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_LONG38 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_SHORT41 LONG VARCHAR FOR BIT DATA,
+ HASHSET_OF_SIMPLE_CLASS42 LONG VARCHAR FOR BIT DATA,
CONSTRAINT HSC_PK PRIMARY KEY (IDENTIFIER)
);
CREATE TABLE HASHSET_OF_OBJECT0
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE HASHSET_OF_OBJECT1
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE HASHSET_OF_OBJECT2
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
- OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE HASHSET_OF_SIMPLE_CLASS3
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE HASHSET_OF_SIMPLE_CLASS4
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE HASHSET_OF_SIMPLE_CLASS5
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
- SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE6
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
);
CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE7
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ ID BIGINT NOT NULL,
+ INTVAL INTEGER NOT NULL,
+ STRINGVAL VARCHAR(128) NOT NULL
);
CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE8
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
- SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ COLLVAL LONG VARCHAR FOR BIT DATA
);
CREATE TABLE HASHSET_OF_STRING9
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
STRINGVAL VARCHAR(1024)
);
-CREATE TABLE HASHSET_OF_STRING11
+CREATE TABLE HASHSET_OF_STRING10
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
STRINGVAL VARCHAR(1024)
);
CREATE TABLE HASHSET_OF_DATE12
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
DATEVAL TIMESTAMP
);
-CREATE TABLE HASHSET_OF_DATE14
+CREATE TABLE HASHSET_OF_DATE13
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
DATEVAL TIMESTAMP
);
CREATE TABLE HASHSET_OF_LOCALE15
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
LOCALEVAL CHAR(20)
);
-CREATE TABLE HASHSET_OF_LOCALE17
+CREATE TABLE HASHSET_OF_LOCALE16
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
LOCALEVAL CHAR(20)
);
CREATE TABLE HASHSET_OF_BIG_DECIMAL18
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6)
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_DECIMALVAL DECIMAL(27,16)
);
-CREATE TABLE HASHSET_OF_BIG_DECIMAL20
+CREATE TABLE HASHSET_OF_BIG_DECIMAL19
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6)
+ ALLOW_DUPLICATES BIGINT NOT NULL,
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE HASHSET_OF_BIG_INTEGER21
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
BIG_INTEGERVAL BIGINT
);
-CREATE TABLE HASHSET_OF_BIG_INTEGER23
+CREATE TABLE HASHSET_OF_BIG_INTEGER22
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
BIG_INTEGERVAL BIGINT
);
CREATE TABLE HASHSET_OF_BYTE24
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
BYTEVAL SMALLINT
);
-CREATE TABLE HASHSET_OF_BYTE26
+CREATE TABLE HASHSET_OF_BYTE25
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
BYTEVAL SMALLINT
);
CREATE TABLE HASHSET_OF_DOUBLE27
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
DOUBLEVAL DOUBLE
);
-CREATE TABLE HASHSET_OF_DOUBLE29
+CREATE TABLE HASHSET_OF_DOUBLE28
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
DOUBLEVAL DOUBLE
);
CREATE TABLE HASHSET_OF_FLOAT30
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
FLOATVAL FLOAT
);
-CREATE TABLE HASHSET_OF_FLOAT32
+CREATE TABLE HASHSET_OF_FLOAT31
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
FLOATVAL FLOAT
);
CREATE TABLE HASHSET_OF_INTEGER33
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
INTEGERVAL INTEGER
);
-CREATE TABLE HASHSET_OF_INTEGER35
+CREATE TABLE HASHSET_OF_INTEGER34
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
INTEGERVAL INTEGER
);
CREATE TABLE HASHSET_OF_LONG36
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
LONGVAL BIGINT
);
-CREATE TABLE HASHSET_OF_LONG38
+CREATE TABLE HASHSET_OF_LONG37
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
LONGVAL BIGINT
);
CREATE TABLE HASHSET_OF_SHORT39
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
SHORTVAL SMALLINT
);
-CREATE TABLE HASHSET_OF_SHORT41
+CREATE TABLE HASHSET_OF_SHORT40
(
IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+ ALLOW_DUPLICATES BIGINT NOT NULL,
SHORTVAL SMALLINT
);
@@ -4562,14 +4659,14 @@
CREATE TABLE TREESET_OF_BIG_DECIMAL15
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
+ BIG_DECIMALVAL DECIMAL(27,16),
INDEX INTEGER NOT NULL
);
CREATE TABLE TREESET_OF_BIG_DECIMAL17
(
IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
+ BIG_DECIMALVAL DECIMAL(27,16),
INDEX INTEGER NOT NULL
);
@@ -4939,7 +5036,7 @@
(
IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
KEYVAL VARCHAR(100) NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6)
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE MAP_OF_STRING_BIG_INTEGER107
@@ -5259,7 +5356,7 @@
(
IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
KEYVAL VARCHAR(100) NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6)
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE HASHMAP_STR_BIG_INTEGER107
@@ -5579,7 +5676,7 @@
(
IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
KEYVAL VARCHAR(100) NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6)
+ BIG_DECIMALVAL DECIMAL(27,16)
);
CREATE TABLE HASHTBL_STR_BIG_INTEGER107
@@ -5859,7 +5956,7 @@
CREATE TABLE HASHMAP_BIG_DECIMAL53_STR (
IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
VALUEVAL VARCHAR(100) NOT NULL,
- KEYVAL DECIMAL(17,6)
+ KEYVAL DECIMAL(27,16)
);
CREATE TABLE HASHMAP_BIG_INTEGER62_STR (
@@ -6144,7 +6241,7 @@
CREATE TABLE HASHTBL_BIG_DECIMAL53_STR (
IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
VALUEVAL VARCHAR(100) NOT NULL,
- KEYVAL DECIMAL(17,6)
+ KEYVAL DECIMAL(27,16)
);
CREATE TABLE HASHTBL_BIG_INTEGER62_STR (
@@ -6440,7 +6537,7 @@
CREATE TABLE TREEMAP_BIG_DECIMAL53_STR (
IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
VALUEVAL VARCHAR(100) NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
+ BIG_DECIMALVAL DECIMAL(27,16),
INDEX INTEGER NOT NULL
);
@@ -6727,7 +6824,7 @@
CREATE TABLE MAP_OF_BIG_DECIMAL53_STRING (
IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
VALUEVAL VARCHAR(100) NOT NULL,
- KEYVAL DECIMAL(17,6)
+ KEYVAL DECIMAL(27,16)
);
CREATE TABLE MAP_OF_BIG_INTEGER62_STRING (
@@ -7064,7 +7161,7 @@
(
IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
KEYVAL VARCHAR(100) NOT NULL,
- BIG_DECIMALVAL DECIMAL(17,6),
+ BIG_DECIMALVAL DECIMAL(27,16),
INDEX INTEGER NOT NULL
);