1# Tests for PERFORMANCE_SCHEMA 2# Make sure mysql_upgrade does not destroy data in a 'performance_schema' 3# database. 4# 5 6--source include/not_embedded.inc 7--source include/have_perfschema.inc 8 9# Some initial settings + Preemptive cleanup 10let $MYSQLD_DATADIR= `SELECT @@datadir`; 11let $err_file= $MYSQLTEST_VARDIR/tmp/pfs_upgrade_view.err; 12let $out_file= $MYSQLTEST_VARDIR/tmp/pfs_upgrade_view.out; 13--error 0,1 14--remove_file $out_file 15--error 0,1 16--remove_file $err_file 17 18--disable_warnings 19drop view if exists test.user_view; 20--enable_warnings 21 22--echo "Testing mysql_upgrade with VIEW performance_schema.user_view" 23 24create view test.user_view as select "Not supposed to be here"; 25 26--error 0,1 27--remove_file $MYSQLD_DATADIR/performance_schema/user_view.frm 28--copy_file $MYSQLD_DATADIR/test/user_view.frm $MYSQLD_DATADIR/performance_schema/user_view.frm 29 30# Make sure the view is visible 31use performance_schema; 32show tables like "user_view"; 33 34--source suite/perfschema/include/upgrade_check.inc 35 36# Make sure the view is still visible 37show tables like "user_view"; 38 39use test; 40 41--remove_file $MYSQLD_DATADIR/performance_schema/user_view.frm 42drop view test.user_view; 43 44