Debian Codegraph @

mysql-test/suite/perfschema/include/pfs_upgrade.inc

raw
1 # Tests for PERFORMANCE_SCHEMA
2 # Make sure mysql_upgrade does not destroy data in a 'performance_schema'
3 # database.
4 #
5
6 # Some initial settings + Preemptive cleanup
7 let $MYSQLD_DATADIR= `SELECT @@datadir`;
8 let $err_file= $MYSQLTEST_VARDIR/tmp/pfs_upgrade.err;
9 let $out_file= $MYSQLTEST_VARDIR/tmp/pfs_upgrade.out;
10 --error 0,1
11 --remove_file $out_file
12 --error 0,1
13 --remove_file $err_file
14
15 --disable_warnings
16 drop table if exists test.user_table;
17 drop procedure if exists test.user_proc;
18 drop function if exists test.user_func;
19 drop event if exists test.user_event;
20 --enable_warnings
21
22
23 --echo # Testing mysql_upgrade with TABLE performance_schema.user_table
24
25 create table test.user_table(a int);
26
27 --error 0,1
28 --remove_file $MYSQLD_DATADIR/performance_schema/user_table.frm
29 --copy_file $MYSQLD_DATADIR/test/user_table.frm $MYSQLD_DATADIR/performance_schema/user_table.frm
30
31 # Make sure the table is visible
32 use performance_schema;
33 show tables like "user_table";
34
35 --source suite/perfschema/include/upgrade_check.inc
36
37 # Make sure the table is still visible
38 show tables like "user_table";
39
40 use test;
41
42 --remove_file $MYSQLD_DATADIR/performance_schema/user_table.frm
43 drop table test.user_table;
44
45
46 --echo # Testing mysql_upgrade with VIEW performance_schema.user_view
47
48 create view test.user_view as select "Not supposed to be here";
49
50 --error 0,1
51 --remove_file $MYSQLD_DATADIR/performance_schema/user_view.frm
52 --copy_file $MYSQLD_DATADIR/test/user_view.frm $MYSQLD_DATADIR/performance_schema/user_view.frm
53
54 # Make sure the view is visible
55 use performance_schema;
56 show tables like "user_view";
57
58 --source suite/perfschema/include/upgrade_check.inc
59
60 # Make sure the view is still visible
61 show tables like "user_view";
62
63 use test;
64
65 --remove_file $MYSQLD_DATADIR/performance_schema/user_view.frm
66 drop view test.user_view;
67
68
69 --echo # Testing mysql_upgrade with PROCEDURE performance_schema.user_proc
70
71 create procedure test.user_proc()
72 select "Not supposed to be here";
73
74 update mysql.proc set db='performance_schema' where name='user_proc';
75
76 --source suite/perfschema/include/upgrade_check.inc
77
78 select name from mysql.proc where db='performance_schema';
79
80 update mysql.proc set db='test' where name='user_proc';
81 drop procedure test.user_proc;
82
83
84 --echo # Testing mysql_upgrade with FUNCTION performance_schema.user_func
85
86 create function test.user_func() returns integer
87 return 0;
88
89 update mysql.proc set db='performance_schema' where name='user_func';
90
91 --source suite/perfschema/include/upgrade_check.inc
92
93 select name from mysql.proc where db='performance_schema';
94
95 update mysql.proc set db='test' where name='user_func';
96 drop function test.user_func;
97
98
99 --echo # Testing mysql_upgrade with EVENT performance_schema.user_event
100
101 create event test.user_event on schedule every 1 day do
102 select "not supposed to be here";
103
104 update mysql.event set db='performance_schema' where name='user_event';
105
106 --source suite/perfschema/include/upgrade_check.inc
107
108 select name from mysql.event where db='performance_schema';
109
110 update mysql.event set db='test' where name='user_event';
111 drop event test.user_event;
112