Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wrong error message with UNIQUE BOOLEAN field [CORE5166] #5449

Closed
firebird-issue-importer opened this issue Mar 24, 2016 · 5 comments
Closed

Comments

@firebird-issue-importer

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 24, 2016

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 27, 2016

Modified by: @dyemanov

Fix Version: 3.0.0 [ 10740 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 28, 2016

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 30, 2016

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 30, 2016

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment