Debian Codegraph @

mysql-test/suite/perfschema/t/pfs_upgrade_view.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 VIEW performance_schema.user_view
13
14 create view test.user_view as select "Not supposed to be here";
15
16 --copy_file $MYSQLD_DATADIR/test/user_view.frm $MYSQLD_DATADIR/performance_schema/user_view.frm
17
18 # Make sure the view is visible
19 use performance_schema;
20 show tables like "user_view";
21
22 --source suite/perfschema/include/upgrade_check.inc
23
24 # Make sure the view is still visible
25 show tables like "user_view";
26
27 use test;
28
29 --remove_file $MYSQLD_DATADIR/performance_schema/user_view.frm
30 drop view test.user_view;