[Firebird-devel] [ firebird-Bugs-545515 ] SP's do not recompile dependands

[<no...@so...>]

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