mirror of
https://github.com/MariaDB/server.git
synced 2025-02-13 17:05:35 +01:00
24 lines
707 B
Text
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;
|