mysql-test/suite/perfschema/t/pfs_upgrade_proc.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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;