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
