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