Bug #11247 Stored procedures: Function calls in long loops leak memory

Description:
(This is a continuation of BUG#10968.)

When running nested loops with function invokations, the server is leaking memory
and eventually starts thrashing.

With the included test case, it takes about 6 minutes (on an old 1.3GHz machine),
or when the outer loop count passes about 3500.

How to repeat:
drop function if exists pt7;
drop function if exists pt8;
drop procedure if exists pt9;

delimiter //;

create function pt7(param1 int)
  returns int
return param1 + 1//

create function pt8(param1 int)
  returns int
begin
  declare v int default 0;

  while v < param1 do
    set v = pt7(v);
  end while;
  return v;
end//

create procedure pt9(lim int)
begin
  declare v int default 0;

  while v < lim do
    select pt8(v);
    set v = v + 1;
  end while;
end//

delimiter ;//

call pt9(10000);

I experience trouble with a built-in function too, and after an hour or two it crashes.
5.0.8-beta-debug

set sql_mode='traditional'//

create procedure pv4 () begin declare v1 int default 0; while v1 < 1000000 do set v1 = v1 + 1; select v1, repeat('*',0); end while; end//

call pv4()//

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28348

The fix will go into 5.0.12

Documented in 5.0.12 changelog:

<listitem><para>Stored procedures with particularly long loops could crash server due to memory leak. (Bug #12297, Bug #11247)</para></listitem>