Debian Codegraph @

mysql-test/suite/perfschema/t/pfs_upgrade_table.test

raw
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 --source include/have_innodb.inc
9
10 let $MYSQLD_DATADIR= `SELECT @@datadir`;
11
12 --echo # Testing mysql_upgrade with TABLE performance_schema.user_table
13
14 create table test.user_table(a int);
15
16 --copy_file $MYSQLD_DATADIR/test/user_table.frm $MYSQLD_DATADIR/performance_schema/user_table.frm
17
18 # Make sure the table is visible
19 use performance_schema;
20 show tables like "user_table";
21
22 --source suite/perfschema/include/upgrade_check.inc
23
24 # Make sure the table is still visible
25 show tables like "user_table";
26
27 use test;
28
29 --remove_file $MYSQLD_DATADIR/performance_schema/user_table.frm
30 drop table test.user_table;