
If you were logged in you would be able to see more operations.
|
|
|
QA Status: |
Done successfully
|
1. Create database and run script
set term ^;
create or alter view v1
as
select 1 as n from rdb$database
^
create or alter function f1
returns integer
as
declare ret integer;
begin
select n from v1 into ret;
return ret;
end
^
create or alter procedure p1
returns (ret integer)
as
begin
select n from v1 into ret;
end
^
set term ;^
2. Check dependencies:
SQL> show function;
Global functions
Function Name Invalid Dependency, Type
================================= ======= =====================================
F1 V1, View
SQL> show procedure;
Global procedures
Procedure Name Invalid Dependency, Type
================================= ======= =====================================
P1 V1, View
Result: dependencies is OK
3. backup database and restore backup into new database (using gbak)
4. connect to the restored database and check dependencies
SQL> show function;
Global functions
Function Name Invalid Dependency, Type
================================= ======= =====================================
F1 RDB$PAGES, Table
SQL> show procedure;
Global procedures
Procedure Name Invalid Dependency, Type
================================= ======= =====================================
P1 V1, View
Result: dependencies of function F1 is wrong, while dependencies of procedure P1 is OK
|
Description
|
1. Create database and run script
set term ^;
create or alter view v1
as
select 1 as n from rdb$database
^
create or alter function f1
returns integer
as
declare ret integer;
begin
select n from v1 into ret;
return ret;
end
^
create or alter procedure p1
returns (ret integer)
as
begin
select n from v1 into ret;
end
^
set term ;^
2. Check dependencies:
SQL> show function;
Global functions
Function Name Invalid Dependency, Type
================================= ======= =====================================
F1 V1, View
SQL> show procedure;
Global procedures
Procedure Name Invalid Dependency, Type
================================= ======= =====================================
P1 V1, View
Result: dependencies is OK
3. backup database and restore backup into new database (using gbak)
4. connect to the restored database and check dependencies
SQL> show function;
Global functions
Function Name Invalid Dependency, Type
================================= ======= =====================================
F1 RDB$PAGES, Table
SQL> show procedure;
Global procedures
Procedure Name Invalid Dependency, Type
================================= ======= =====================================
P1 V1, View
Result: dependencies of function F1 is wrong, while dependencies of procedure P1 is OK
|
Show » |
|
Is it possible to backport this fix to 3.0.6.?
Thanks!
András