Wrong dependencies of stored function on view after backup and restore
----------------------------------------------------------------------
Key: CORE-6233
URL: http://tracker.firebirdsql.org/browse/CORE-6233
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.5
Reporter: Vlad Khorsun
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
--
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
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
