You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
recreate table tfkself (col1 int primary key, col2 int references tfkself(col1) on update cascade);
insert into tfkself (col1, col2) values (1, null);
insert into tfkself (col1, col2) values (2, null);
insert into tfkself (col1, col2) values (3, 1);
commit;
update tfkself set col1 = -col1;
--violation of FOREIGN KEY constraint "".
--violation of FOREIGN KEY constraint "INTEG_14" on table "TFKSELF".
--Foreign key reference target does not exist.
--Problematic key value is ("COL2" = 1).
It appears that when the last row is being updated, it does not see the new (changed by casdade) value of the COL2 column.
Submitted by: Boltik Evgeny (bolt)
Relate to CORE3362
Votes: 2
Test case:
recreate table tfkself (col1 int primary key, col2 int references tfkself(col1) on update cascade);
insert into tfkself (col1, col2) values (1, null);
insert into tfkself (col1, col2) values (2, null);
insert into tfkself (col1, col2) values (3, 1);
commit;
update tfkself set col1 = -col1;
--violation of FOREIGN KEY constraint "".
--violation of FOREIGN KEY constraint "INTEG_14" on table "TFKSELF".
--Foreign key reference target does not exist.
--Problematic key value is ("COL2" = 1).
It appears that when the last row is being updated, it does not see the new (changed by casdade) value of the COL2 column.
Commits: 1db164a 90b35ad
The text was updated successfully, but these errors were encountered: