|
From: <no...@so...> - 2002-04-23 03:32:23
|
Bugs item #545515, was opened at 2002-04-18 07:16 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=109028&aid=545515&group_id=9028 Category: Core Engine Group: None Status: Open Resolution: None Priority: 5 Submitted By: Willo van der Merwe (willo) Assigned to: Nobody/Anonymous (nobody) Summary: SP's do not recompile dependands Initial Comment: Hi, Found an issue: create procedure foo returns( v varchar(40) ) as begin v = 'bar'; suspend; end !! create procedure bar returns( v varchar(40) ) as begin for select v from foo into :v do suspend; end !! alter procedure foo returns( v varchar(40) ) as begin v = 'foo'; suspend; end !! select * from foo value ------- foo select * from bar value ------- bar if you were to do: alter procedure bar returns( v varchar(40) ) as begin for select v from foo into :v do suspend; end !! then you get select * from bar value ------- foo Regards, Willo ---------------------------------------------------------------------- >Comment By: Helen Borrie (helebor) Date: 2002-04-23 03:32 Message: Logged In: YES user_id=60469 Worse, if you don't recompile the dependent procedures yourself manually, e.g. with RECREATE PROCEDURE, and then you gbak the database, you will be unable to restore the gbak. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=109028&aid=545515&group_id=9028 |