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
When GLOBAL TEMPORARY TABLE's is re-created and sweep run at the same time wrong page type error may occurs.
To reproduce run following statement
execute block returns (sql varchar(255))
as
declare n int;
declare i int;
declare s varchar(256);
begin
n = 0;
while (n < 20) do
begin
i = 1;
while (i < 10) do
begin
s = 'tmp' || :i;
sql = 'create global temporary table ' || :s || ' (id int);';
execute statement sql with autonomous transaction;
suspend;
sql = 'drop table ' \|\| :s \|\| ';';
execute statement sql with autonomous transaction;
suspend;
i = i \+ 1;
end
n = n \+ 1;
end
end
and run gfix -sweep while statement above is executed.
Submitted by: @hvlad
When GLOBAL TEMPORARY TABLE's is re-created and sweep run at the same time wrong page type error may occurs.
To reproduce run following statement
execute block returns (sql varchar(255))
as
declare n int;
declare i int;
declare s varchar(256);
begin
n = 0;
while (n < 20) do
begin
i = 1;
while (i < 10) do
begin
s = 'tmp' || :i;
sql = 'create global temporary table ' || :s || ' (id int);';
execute statement sql with autonomous transaction;
suspend;
end
end
and run gfix -sweep while statement above is executed.
Commits: 521f7a5 12019b8 d940b8c
The text was updated successfully, but these errors were encountered: