Bug #33289 Stored Procedure: bad data if view is replaced within a iteration

Description:
In some circumstances if a view is replaced within a iteration inside a stored procedure, selects from the view will always return the same value.

How to repeat:
create view v1 as select 1;
delimiter |;
create procedure bad_data()
begin
  declare iteration integer default 0;
  while iteration < 10 do
    if iteration = 1 then
      drop view v1;
      create view v1 as select 2;
    end if;
    select * from v1;
    set iteration= iteration+1;
  end while;
end|
delimiter ;|
call bad_data();
select * from v1;

The expected result is that after the view is replaced, it should only return values from the new view, not from the old dropped one, yet this only return values from the old view.

Thank you for the bug report.

Noted in 5.6.6 changelog.

Bad data could be returned from a view used within a stored program
if the view definition was changed between executions of the program
or while the view was used within a program loop.