Debian Codegraph @

mysql-test/suite/perfschema/t/pfs_upgrade_func.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 FUNCTION performance_schema.user_func
13
14 create function test.user_func() returns integer
15 return 0;
16
17 update mysql.proc set db='performance_schema' where name='user_func';
18
19 --source suite/perfschema/include/upgrade_check.inc
20
21 select name from mysql.proc where db='performance_schema';
22
23 update mysql.proc set db='test' where name='user_func';
24 drop function test.user_func;