summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/t/read_only.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/perfschema/t/read_only.test')
-rw-r--r--mysql-test/suite/perfschema/t/read_only.test3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/t/read_only.test b/mysql-test/suite/perfschema/t/read_only.test
index 0020c64937b..48b7354138f 100644
--- a/mysql-test/suite/perfschema/t/read_only.test
+++ b/mysql-test/suite/perfschema/t/read_only.test
@@ -6,10 +6,12 @@
--source include/not_embedded.inc
--source include/have_perfschema.inc
+--enable_connect_log
use performance_schema;
set @start_read_only= @@global.read_only;
+set @start_super_read_only= @@global.super_read_only;
create user pfsuser@localhost;
grant SELECT, UPDATE on performance_schema.* to pfsuser@localhost;
@@ -26,6 +28,7 @@ connection con1;
select @@global.read_only;
show grants;
--disable_result_log
+--echo # Update on perf_schema is allowed in read_only mode.
select * from performance_schema.setup_instruments;
update performance_schema.setup_instruments set enabled='NO';
update performance_schema.setup_instruments set enabled='YES';