From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../suite/perfschema/t/pfs_upgrade_event.test | 24 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_event.test (limited to 'mysql-test/suite/perfschema/t/pfs_upgrade_event.test') diff --git a/mysql-test/suite/perfschema/t/pfs_upgrade_event.test b/mysql-test/suite/perfschema/t/pfs_upgrade_event.test new file mode 100644 index 00000000..809e5e05 --- /dev/null +++ b/mysql-test/suite/perfschema/t/pfs_upgrade_event.test @@ -0,0 +1,24 @@ +# 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; -- cgit v1.2.3