--source include/protocol.inc create procedure p1() select 1; flush status; show status like 'handler_read_key'; call p1; show status like 'handler_read_key'; call p1; show status like 'handler_read_key'; set global stored_program_cache=0; call p1; show status like 'handler_read_key'; call p1; show status like 'handler_read_key'; drop procedure p1; set global stored_program_cache=default; # Test for missing SP automatic reparsing. # when MDEV-5816 is implemented, it should be removed. --delimiter | create procedure pr(i int) begin create table t1 (a int, b int); if (i = 1) then alter table t1 drop a; else alter table t1 drop b; end if; select * from t1; drop table t1; end | --delimiter ; call pr(1); #--error ER_BAD_FIELD_ERROR # MDEV-5816 added support for recompilation of statements # inside a stored routine so the error ER_BAD_FIELD_ERROR is # no more expcted call pr(2); set global stored_program_cache=0; call pr(1); call pr(2); drop procedure pr; set global stored_program_cache=default;