For starters, your script does not run on H2 because it is using weird
syntax.
However, if I fix it, H2 correctly throws a constraint violated exception.
CREATE TABLE SOMETHING_TABLE
(
COLUMN1 CHAR(10),
COLUMN2 CHAR(10),
COLUMN3 CHAR(2),
COLUMN4 VARCHAR2(9)
);
CREATE UNIQUE INDEX PK_SOMETHING_TABLE ON SOMETHING_TABLE
(
COLUMN1, COLUMN2, COLUMN3
);
insert into SOMETHING_TABLE values(1, 1, 1, 1) ;
insert into SOMETHING_TABLE values(1, 1, 1, 1) ;
--
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
