Debian Codegraph @

mysql-test/suite/perfschema/t/pfs_upgrade_event.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 EVENT performance_schema.user_event
13
14 create event test.user_event on schedule every 1 day do
15 select "not supposed to be here";
16
17 update mysql.event set db='performance_schema' where name='user_event';
18
19 --source suite/perfschema/include/upgrade_check.inc
20
21 select name from mysql.event where db='performance_schema';
22
23 update mysql.event set db='test' where name='user_event';
24 drop event test.user_event;