Index and BLOBs garbage collection doesn't work for update_in_place() [CORE4383] #4705
Labels
affect-version: 2.5.0
affect-version: 2.5.1
affect-version: 2.5.2 Update 1
affect-version: 2.5.2
affect-version: 2.5.3 Update 1
affect-version: 2.5.3
affect-version: 3.0 Alpha 1
affect-version: 3.0 Alpha 2
affect-version: 3.0 Beta 1
component: engine
fix-version: 2.5.4
fix-version: 3.0 Beta 2
priority: major
qa: covered by another tests
type: bug
Submitted by: @aafemt
Following script leaves orphan nodes in index even if CORE4382 is fixed because jrd_tra uses static buffer for undo data.
create database "g_test";
create table g_test (f integer);
create index g_ind on g_test (f);
insert into g_test values (1);
commit;
update g_test set f=2;
savepoint a;
update g_test set f=3;
savepoint b;
update g_test set f=4;
savepoint c;
update g_test set f=5;
savepoint d;
update g_test set f=6;
savepoint e;
update g_test set f=7;
commit;
select * from g_test;
Commits: 6ae3e2c 8dc2bca f1d60b9 FirebirdSQL/fbt-repository@9bd920a FirebirdSQL/fbt-repository@47a2e72 FirebirdSQL/fbt-repository@8faacb6
====== Test Details ======
Could not reproduce. Test for CORE4382 shows that now all works fine.
The text was updated successfully, but these errors were encountered: