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