From a175314c3e5827eb193872241446f2f8f5c9d33c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:07:14 +0200 Subject: Adding upstream version 1:10.5.12. Signed-off-by: Daniel Baumann --- .../suite/perfschema/t/pfs_upgrade_proc.test | 24 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_proc.test (limited to 'mysql-test/suite/perfschema/t/pfs_upgrade_proc.test') diff --git a/mysql-test/suite/perfschema/t/pfs_upgrade_proc.test b/mysql-test/suite/perfschema/t/pfs_upgrade_proc.test new file mode 100644 index 00000000..69250734 --- /dev/null +++ b/mysql-test/suite/perfschema/t/pfs_upgrade_proc.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 PROCEDURE performance_schema.user_proc + +create procedure test.user_proc() + select "Not supposed to be here"; + +update mysql.proc set db='performance_schema' where name='user_proc'; + +--source suite/perfschema/include/upgrade_check.inc + +select name from mysql.proc where db='performance_schema'; + +update mysql.proc set db='test' where name='user_proc'; +drop procedure test.user_proc; -- cgit v1.2.3