EVOLUTION-MANAGER

Edit File: pfs_upgrade_view.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 --source include/have_innodb.inc let $MYSQLD_DATADIR= `SELECT @@datadir`; --echo "Testing mysql_upgrade with VIEW performance_schema.user_view" create view test.user_view as select "Not supposed to be here"; --copy_file $MYSQLD_DATADIR/test/user_view.frm $MYSQLD_DATADIR/performance_schema/user_view.frm # Make sure the view is visible use performance_schema; show tables like "user_view"; --source suite/perfschema/include/upgrade_check.inc # Make sure the view is still visible show tables like "user_view"; use test; --remove_file $MYSQLD_DATADIR/performance_schema/user_view.frm drop view test.user_view;