diff options
Diffstat (limited to 'mysql-test/suite/perfschema/t/start_server_off.test')
-rw-r--r-- | mysql-test/suite/perfschema/t/start_server_off.test | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/suite/perfschema/t/start_server_off.test b/mysql-test/suite/perfschema/t/start_server_off.test index 400303e05d2..6fdc02acf9b 100644 --- a/mysql-test/suite/perfschema/t/start_server_off.test +++ b/mysql-test/suite/perfschema/t/start_server_off.test @@ -5,6 +5,9 @@ --source ../include/start_server_common.inc +select * from information_schema.engines + where engine = "PERFORMANCE_SCHEMA"; + # Expecting all off / zero show status like "performance_schema%"; show variables like "performance_schema"; @@ -27,7 +30,7 @@ select * from performance_schema.setup_timers; insert into performance_schema.setup_objects values ('TABLE', 'myschema', 'myobject', 'YES', 'YES'); --error ER_WRONG_PERFSCHEMA_USAGE -insert into performance_schema.setup_actors values ('myhost', 'mysuser', 'myrole'); +insert into performance_schema.setup_actors values ('myhost', 'mysuser', 'myrole', 'YES', 'YES'); # Expect SELECT, UPDATE, DELETE and TRUNCATE to affect 0 rows, but with # no error because the target row(s) will not be found @@ -45,3 +48,9 @@ truncate performance_schema.events_statements_history_long; truncate performance_schema.events_waits_history_long; truncate performance_schema.setup_objects; truncate performance_schema.setup_actors; + +--disable_warnings +# Expect that status variables are still accessible +show global status like "performance_schema%"; +show session status like "performance_schema%"; +--enable_warnings |