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 [5/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/datastoreidentity/schema.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql?rev=312732&r1=312731&r2=312732&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql Mon Oct 10 13:35:04 2005
@@ -808,78 +808,78 @@
(
DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
IDENTIFIER INTEGER,
- 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 (DATASTORE_IDENTITY);
@@ -2791,7 +2791,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
@@ -2972,14 +2972,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
@@ -3086,235 +3086,242 @@
(
DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
IDENTIFIER INTEGER,
- 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 (DATASTORE_IDENTITY)
);
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
@@ -3445,14 +3452,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
);
@@ -3560,235 +3567,242 @@
(
DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
IDENTIFIER INTEGER,
- 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 (DATASTORE_IDENTITY)
);
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
@@ -3797,235 +3811,242 @@
(
DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
IDENTIFIER INTEGER,
- 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 (DATASTORE_IDENTITY)
);
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
@@ -4034,203 +4055,241 @@
(
DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
IDENTIFIER INTEGER,
- 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 (DATASTORE_IDENTITY)
);
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
);
@@ -4240,203 +4299,241 @@
(
DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
IDENTIFIER INTEGER,
- 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 (DATASTORE_IDENTITY)
);
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
);
@@ -4553,14 +4650,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
);
@@ -4931,7 +5028,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
@@ -5252,7 +5349,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
@@ -5573,7 +5670,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
@@ -5854,7 +5951,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 (
@@ -6140,7 +6237,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 (
@@ -6437,7 +6534,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
);
@@ -6725,7 +6822,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 (
@@ -7063,7 +7160,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
);