Enable views to support unlimited multply formats / versions
------------------------------------------------------------
Key: CORE-5647
URL: http://tracker.firebirdsql.org/browse/CORE-5647
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 2.5.7, 2.5.8, 3.0.3, 4.0 Beta 1
Reporter: Omacht AndrĂ¡s
Priority: Minor
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel