I have 2 tables:
CREATE CACHED TABLE SAB_UNITS(
ADDR INTEGER NOT NULL,
ORG INTEGER NOT NULL,
SCHEME INTEGER NOT NULL
);
ALTER TABLE SAB_UNITS ADD CONSTRAINT PK_SAB_UNITS PRIMARY KEY(ADDR);
CREATE CACHED TABLE SAB_MANAGE_ASSIGNMENT(
ADDR INTEGER NOT NULL,
IO INTEGER NOT NULL,
CFGNAME VARCHAR(1024),
CFGBY INTEGER NOT NULL,
IOONOFF INTEGER NOT NULL,
PATTERNA BOOLEAN NOT NULL,
PATTERNB BOOLEAN NOT NULL,
PATTERNC BOOLEAN NOT NULL
);
ALTER TABLE SAB_MANAGE_ASSIGNMENT ADD CONSTRAINT PK_SAB_MANAGE_ASSIGNMENT
PRIMARY KEY(ADDR, IO);
ALTER TABLE SAB_MANAGE_ASSIGNMENT ADD CONSTRAINT
FK_SAB_MANAGE_ASSIGNMENT_SAB_UNITS FOREIGN KEY(ADDR) REFERENCES
SAB_UNITS(ADDR) NOCHECK;
H2 will create the following index for the table 'SAB_MANAGE_ASSIGNMENT':
CREATE UNIQUE INDEX
PUBLIC.FK_SAB_MANAGE_ASSIGNMENT_CFG_SAB_MANAGE_ASSIGNMENT_INDEX_F ON
PUBLIC.SAB_MANAGE_ASSIGNMENT(ADDR);
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_NAME
ORDINAL_POSITION COLUMN_NAME CARDINALITY PRIMARY_KEY INDEX_TYPE_NAME
IS_GENERATED INDEX_TYPE ASC_OR_DESC PAGES FILTER_CONDITION REMARKS SQL ID
SORT_TYPE CONSTRAINT_NAME INDEX_CLASS
DB1 PUBLIC SAB_MANAGE_ASSIGNMENT false
FK_SAB_MANAGE_ASSIGNMENT_CFG_SAB_MANAGE_ASSIGNMENT_INDEX_F 1 ADDR 0 false
UNIQUE INDEX true 3 A 0 "" "" CREATE UNIQUE INDEX
PUBLIC.FK_SAB_MANAGE_ASSIGNMENT_CFG_SAB_MANAGE_ASSIGNMENT_INDEX_F
ON PUBLIC.SAB_MANAGE_ASSIGNMENT(ADDR) 244 0
FK_SAB_MANAGE_ASSIGNMENT_SAB_UNITS org.h2.index.PageBtreeIndex
The Problem is that the index is unique! I don't know how to fix that. I
can't drop the index nor change it:
Error code 90085, SQL state 90085: Index
"FK_SAB_MANAGE_ASSIGNMENT_CFG_SAB_MANAGE_ASSIGNMENT_INDEX_F" belongs to
constraint "FK_SAB_MANAGE_ASSIGNMENT_CFG_SAB_MANAGE_ASSIGNMENT"; SQL
statement:
Drop index FK_SAB_MANAGE_ASSIGNMENT_CFG_SAB_MANAGE_ASSIGNMENT_INDEX_F
[90085-176]
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
