Skip to content

Increase number of formats/versions of views from 255 to 32K [CORE5647] #5913

@firebird-automations

Description

@firebird-automations

Submitted by: Omacht András (aomacht)

Altering views has the same limit (maximum 255 versions) like tables.
As we discussed in Prague and privatly with Vlad it is a non-necessary limitation in Firebird.

Please remove this limitation.

Here is a test case how to reproduce the problem:

execute block
as
declare variable i integer;
begin
i = 1;
while (i < 300) do
begin
if (mod(i, 2) = 0) then
begin
in autonomous transaction do
begin
execute statement 'create or alter view vw1 (dump1) as select 1 from rdb$database';
end
end
else
begin
in autonomous transaction do
begin
execute statement 'create or alter view vw1 (dump1, dump2) as select 1, 2 from rdb$database';
end
end
i = i + 1;
end
end

Commits: 3dd6a2f