Issue Details (XML | Word | Printable)

Key: CORE-5410
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Blocker Blocker
Assignee: Adriano dos Santos Fernandes
Reporter: Gabor Boros
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Dependencies are not stored when using some type of constructions in subroutines

Created: 30/Nov/16 06:29 PM   Updated: 29/Dec/16 09:34 AM
Component/s: Engine
Affects Version/s: 4.0 Initial, 3.0.1, 3.0.2
Fix Version/s: 3.0.2, 4.0 Alpha 1

Environment: Win32 - 3.0.1.32609 and 3.0.2.32641 snapshot

QA Status: Done successfully


 Description  « Hide
In the below isql test case the NEW_PROCEDURE stored procedure (with PROC1 sub-procedure) depend on the NEW_TABLE table which can be dropped without any error
SELECT * FROM RDB$DEPENDENCIES; returns nothing.

SQL> CREATE DATABASE 'SUB_DEPEND.FDB'
CON> user 'SYSDBA' password 'masterkey';

isql -i SUB_DEPEND.sql -user SYSDBA 'SUB_DEPEND.FDB'

SUB_DEPEND.sql:

CREATE TABLE NEW_TABLE (NEW_FIELD INTEGER);

COMMIT;

SET TERM ^;

CREATE PROCEDURE NEW_PROCEDURE
AS

DECLARE PROCEDURE PROC1
AS
DECLARE VARIABLE VAR1 INTEGER;
BEGIN
  SELECT NEW_FIELD FROM NEW_TABLE INTO VAR1;
END

BEGIN
  EXECUTE PROCEDURE PROC1;
END;
^

SET TERM ;^

COMMIT;

DROP TABLE NEW_TABLE;

COMMIT;

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.