Hello Ivan,

Of course its very simple test, and try:

select rdb$relation_id from rdb$database
union all
select rdb$relation_id from rdb$database
...
...
129 times and You recive an error (bad blr), while for 128 times all works fine.

Second example:
create view test1 (id) as
select rdb$relation_id from rdb$database
union all
select rdb$relation_id from rdb$database
...
...
100 times - OK

select * from test1 - OK

create view test2 (id) as
select rdb$relation_id from rdb$database
union all
select rdb$relation_id from rdb$database
...
...
100 times

select * from test2 - OK

and finally

create view testALL (id) as
select id from test1
union all

select id from test2

select * from testALL - bad BLR

I,ve made tests for combination of simple selects, selects with joins and nested views, and every time there is limit for 128 streams in Fb 1.5.3

The same limitation - 128 - exists in FB2.0 but error info is:
Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255.


Many thanks
Jacek Borowski



[Non-text portions of this message have been removed]