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