mariadb/mysql-test/suite/perfschema/t/pfs_upgrade_event.test
2020-03-14 09:51:36 +01:00

24 lines
707 B
Text

# Tests for PERFORMANCE_SCHEMA
# Make sure mysql_upgrade does not destroy data in a 'performance_schema'
# database.
#
--source include/not_embedded.inc
--source include/have_perfschema.inc
--source include/have_innodb.inc
let $MYSQLD_DATADIR= `SELECT @@datadir`;
--echo # Testing mysql_upgrade with EVENT performance_schema.user_event
create event test.user_event on schedule every 1 day do
select "not supposed to be here";
update mysql.event set db='performance_schema' where name='user_event';
--source suite/perfschema/include/upgrade_check.inc
select name from mysql.event where db='performance_schema';
update mysql.event set db='test' where name='user_event';
drop event test.user_event;