# 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

# Some initial settings + Preemptive cleanup
let $MYSQLD_DATADIR= `SELECT @@datadir`;
let $err_file= $MYSQLTEST_VARDIR/tmp/pfs_upgrade_table.err;
let $out_file= $MYSQLTEST_VARDIR/tmp/pfs_upgrade_table.out;
--error 0,1
--remove_file $out_file
--error 0,1
--remove_file $err_file

--disable_warnings
drop table if exists test.user_table;
--enable_warnings

--echo "Testing mysql_upgrade with TABLE performance_schema.user_table"

create table test.user_table(a int);

--error 0,1
--remove_file $MYSQLD_DATADIR/performance_schema/user_table.frm
--copy_file $MYSQLD_DATADIR/test/user_table.frm $MYSQLD_DATADIR/performance_schema/user_table.frm

# Make sure the table is visible
use performance_schema;
show tables like "user_table";

--source suite/perfschema/include/upgrade_check.inc

# Make sure the table is still visible
show tables like "user_table";

use test;

--remove_file $MYSQLD_DATADIR/performance_schema/user_table.frm
drop table test.user_table;