New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Increase number of formats/versions of views from 255 to 32K [CORE5647] #5913
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] summary: Enable views to support unlimited multply formats / versions => Increase number of formats/versions of views from 255 to 32K |
Commented by: @asfernandes Please test next snapshot version for v4, so we can see to backport the fix to v3. |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Beta 1 [ 10750 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Hi! |
Hi All, And the tables? Are they play in a different league? Gabor |
Every record has a reference to the table's format used and this reference is a single byte, so it cannot be done without ODS change that will make all records bigger. |
Ok Adriano, thank you! It helps us much, we are altering views more offen than tables. |
3.0.8.33467 works fine too. Thanks! |
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
The text was updated successfully, but these errors were encountered: