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

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

Bugs item #545515, was opened at 2002-04-18 03:16
Message generated for change (Comment added) made by seanleyne
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=545515&group_id=9028

Category: Core Engine
>Group: Fixed v1.5.x
Status: Closed
Resolution: Fixed
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: Sean Leyne (seanleyne)
Date: 2005-01-08 13:19

Message:
Logged In: YES 
user_id=71163

Daniel Urban reports that this works correctly in v1.5.2

----------------------------------------------------------------------

Comment By: Sean Leyne (seanleyne)
Date: 2005-01-07 17:17

Message:
Logged In: YES 
user_id=71163

The first set of SELECT now correctly returns:

select * from foo
value
-------
foo

select * from bar
value
-------
foo

Additionally, the database can be GBAK'd and restored 
without problem.

----------------------------------------------------------------------

Comment By: Helen Borrie (helebor)
Date: 2002-04-22 23: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: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=545515&group_id=9028