Backport to 2.5 ability of ISQL to proper extract metadata with VIEW that 
depends on PROCEDURE (by generating empty headers of all SP *before* any 
'CREATE VIEW')
-----------------------------------------------------------------------------------------------------------------------------------------------------------------

                 Key: CORE-5076
                 URL: http://tracker.firebirdsql.org/browse/CORE-5076
             Project: Firebird Core
          Issue Type: Improvement
          Components: ISQL
    Affects Versions: 2.5.5
            Reporter: Pavel Zotov
            Priority: Trivial


Apply following scripton empty DB:

set term ^; 
create procedure sp_test returns(y int) as begin y = 2; suspend; end^
create view v_test as select y from sp_test 
^
exit
^

The run ISQL -X.

On 3.0 it will issue:
===
COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;

CREATE OR ALTER PROCEDURE SP_TEST RETURNS (Y INTEGER)
AS
BEGIN SUSPEND; END ^

SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;

CREATE VIEW V_TEST (Y) AS
select y from sp_test;

COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;

ALTER PROCEDURE SP_TEST RETURNS (Y INTEGER)
AS
begin y = 2; suspend; end ^

SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;
===

On 2.5 it will be INVALID:
===
SET SQL DIALECT 3;
CREATE VIEW V_TEST (Y) AS
 select y from sp_test ; ------------------------- forward reference!
COMMIT WORK;

SET AUTODDL OFF;
SET TERM ^ ;

CREATE PROCEDURE SP_TEST RETURNS (Y INTEGER)
AS
BEGIN SUSPEND; END ^

ALTER PROCEDURE SP_TEST RETURNS (Y INTEGER)
AS
 begin y = 2; suspend; end ^
SET TERM ; ^
COMMIT WORK ;
SET AUTODDL ON;
===

It will be nice if extracting empty procedure header before any view will be 
backported to FB 2.5.x.

PS. Sorry if this ticket is duplicate (in what I almost have no doubt).

-- 
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

        

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to