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
Adriano dos Santos Fernandes made changes - 30/Nov/16 06:58 PM
Field Original Value New Value
Assignee Adriano dos Santos Fernandes [ asfernandes ]
Adriano dos Santos Fernandes made changes - 01/Dec/16 02:57 PM
Summary Subroutines not create dependencies Dependencies are not stored when using some type of contructions in subroutines
Affects Version/s 4.0 Initial [ 10621 ]
Adriano dos Santos Fernandes made changes - 01/Dec/16 03:06 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 4.0 Alpha 1 [ 10731 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 02/Dec/16 09:44 AM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status No test Done successfully
Pavel Zotov made changes - 02/Dec/16 09:44 AM
Status Resolved [ 5 ] Closed [ 6 ]
Fix Version/s 3.0.2 [ 10785 ]
Adriano dos Santos Fernandes made changes - 29/Dec/16 09:34 AM
Summary Dependencies are not stored when using some type of contructions in subroutines Dependencies are not stored when using some type of constructions in subroutines