UNIQUE CONSTRAINT violation
----------------------------
Key: CORE-6252
URL: http://tracker.firebirdsql.org/browse/CORE-6252
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.5
Environment: Server Version : Ubuntu 16.04.6 LTS Linux Diesel2
4.15.18-24-pve
Firebird Version : LI-V3.0.5.33220 Firebird 3.0
Reporter: Mattia Rosin
Updating the data of a table with non-unique data and the creation of a unique
costraint on the same table in the same transaction, does not result in the
exception of non-unique records
Example :
SET TERM ^;
/* Creating simple stucture */
DROP TABLE test_table
^
CREATE TABLE test_table(
a integer,
b integer
)
^
COMMIT
^
/* Simple Data*/
INSERT INTO test_table(a, b) VALUES (1,1)
^
INSERT INTO test_table(a, b) VALUES (1,2)
^
COMMIT
^
/* Problem start here */
UPDATE test_table
SET b = -999
^
ALTER TABLE TEST_TABLE
ADD CONSTRAINT UNQ1_TEST_TABLE
UNIQUE (A)
^
COMMIT
^
/* Now test_table have a unique costraint on column a but column a not contains
unique value */
--
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
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
