Edit File: pfs_upgrade_proc.test
# Tests for PERFORMANCE_SCHEMA # Make sure mysql_upgrade does not destroy data in a 'performance_schema' # database. # --source include/not_embedded.inc --source include/have_perfschema.inc # Some initial settings + Preemptive cleanup let $MYSQLD_DATADIR= `SELECT @@datadir`; let $err_file= $MYSQLTEST_VARDIR/tmp/pfs_upgrade_proc.err; let $out_file= $MYSQLTEST_VARDIR/tmp/pfs_upgrade_proc.out; --error 0,1 --remove_file $out_file --error 0,1 --remove_file $err_file --disable_warnings drop procedure if exists test.user_proc; --enable_warnings --echo "Testing mysql_upgrade with PROCEDURE performance_schema.user_proc" create procedure test.user_proc() select "Not supposed to be here"; update mysql.proc set db='performance_schema' where name='user_proc'; --source suite/perfschema/include/upgrade_check.inc select name from mysql.proc where db='performance_schema'; update mysql.proc set db='test' where name='user_proc'; drop procedure test.user_proc;