Submitted by: Gabor Boros (gaborboros)

With BIGINT field the message is correct:

CREATE TABLE TABLE1 (
FIELD1 BIGINT NOT NULL,
CONSTRAINT UNQ1_TABLE1 UNIQUE (FIELD1)
);

COMMIT;

INSERT INTO TABLE1 (FIELD1) VALUES (1);
INSERT INTO TABLE1 (FIELD1) VALUES (1);

COMMIT;

Statement failed, SQLSTATE = 23000
violation of PRIMARY or UNIQUE KEY constraint "UNQ1_TABLE1" on table "TABLE1"
-Problematic key value is ("FIELD1" = 1)

With BOOLEAN field the message is wrong:

CREATE TABLE TABLE1 (
FIELD1 BOOLEAN NOT NULL,
CONSTRAINT UNQ1_TABLE1 UNIQUE (FIELD1)
);

COMMIT;

INSERT INTO TABLE1 (FIELD1) VALUES (TRUE);
INSERT INTO TABLE1 (FIELD1) VALUES (TRUE);

COMMIT;

Statement failed, SQLSTATE = 23000
violation of PRIMARY or UNIQUE KEY constraint "UNQ1_TABLE1" on table "TABLE1"
-conversion error from string "BOOLEAN"

Commits: f58ecf7 3dc7f79