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
create table pk (a integer primary key);
create table fk (b d1 references pk on delete set default);
alter domain d1 set default 2;
-- Optional reconnection
exit;
isql t.fdb
--
insert into pk values (1);
insert into pk values (2);
insert into pk values (3);
insert into fk values (1);
insert into fk values (2);
delete from pk where a = 1;
-- Displays: "3; 2" instead of "2; 2"
select * from fk;
-----------------
The problem is that there is no BLR verb to modify a field to its default value, so the cascade trigger is created with the current default value of the field.
Submitted by: @asfernandes
Depends on CORE1311
Test case:
-----------------
isql
create database 't.fdb';
create domain d1 integer default 3;
create table pk (a integer primary key);
create table fk (b d1 references pk on delete set default);
alter domain d1 set default 2;
-- Optional reconnection
exit;
isql t.fdb
--
insert into pk values (1);
insert into pk values (2);
insert into pk values (3);
insert into fk values (1);
insert into fk values (2);
delete from pk where a = 1;
-- Displays: "3; 2" instead of "2; 2"
select * from fk;
-----------------
The problem is that there is no BLR verb to modify a field to its default value, so the cascade trigger is created with the current default value of the field.
Commits: 7bb6ceb
The text was updated successfully, but these errors were encountered: