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

Reply via email to