Can't reference to key fields of active record in master table when they are not changed in WAIT transaction [CORE2604] #3014
Comments
|
Commented by: Sean Leyne (seanleyne) Petr, there is no column "f" in the master table, so this statement is not valid: update master set *f* = '111' where id = 1; Are you sure that the case details are valid? |
Modified by: @dyemanovassignee: Vlad Khorsun [ hvlad ] |
|
Commented by: @hvlad I can confirm the issue. The reason is that engine first check for state of concurrent transaction (update master ...) and used WAIT mode of current transaction while waiting for concurrent transaction lock. Therefore WAIT transaction will never see record, changed by still active concurrent transaction. The check for PK\UK values of master record (implemented by FK handling improvement) occurs after. |
|
Commented by: Joseba Nevado (j.nevado_speexx.com) Hi, this is still an ongoing issue in FB3, any chance this can be fixed? |
Submitted by: Petr Savelyev (petr.savelyev)
Is related to CORE1606
Votes: 2
Improvement foreign key handling is broken for WAIT transactions.
create table master (id int not null primary key, f varchar(20));
create table child (id int not null primary key, master_id int not null references master);
insert into master values(1, '1');
First connect:
update master set f = '111' where id = 1;
Second connect:
set transaction read write wait;
insert into child values (1, 1);
Now second connect waits for commit/rollback of first transaction instead of insert record immediately. In NO WAIT transactions insert works correct.
The text was updated successfully, but these errors were encountered: