You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
create or alter view v
as
select 1 id from rdb$database
commit
create or alter procedure p_v as
declare x int;
begin
select id from v into :x;
select 1 from rdb$database into :x;
end
commit
select dep.*, typ.rdb$type_name
from rdb$dependencies dep join rdb$types typ
on dep.rdb$depended_on_type = typ.rdb$type
and typ.rdb$field_name = 'RDB$OBJECT_TYPE'
where dep.rdb$dependent_name = 'P_V'
You see type_name = 'RELATION' and rdb$depended_on_type = 0 for all three rows, while for two of them there must be 'VIEW' and 1 correspondingly
Submitted by: @hvlad
Is related to QA383
create or alter view v
as
select 1 id from rdb$database
commit
create or alter procedure p_v as
declare x int;
begin
select id from v into :x;
select 1 from rdb$database into :x;
end
commit
select dep.*, typ.rdb$type_name
from rdb$dependencies dep join rdb$types typ
on dep.rdb$depended_on_type = typ.rdb$type
and typ.rdb$field_name = 'RDB$OBJECT_TYPE'
where dep.rdb$dependent_name = 'P_V'
You see type_name = 'RELATION' and rdb$depended_on_type = 0 for all three rows, while for two of them there must be 'VIEW' and 1 correspondingly
Commits: 5a1aac3
The text was updated successfully, but these errors were encountered: