Wrong error message with UNIQUE BOOLEAN field
---------------------------------------------
Key: CORE-5166
URL: http://tracker.firebirdsql.org/browse/CORE-5166
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 RC2
Reporter: Gabor Boros
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"
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
