Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4 --source include/have_perfschema.inc
5
6 --disable_result_log
7 select * from performance_schema.global_variables
8 where variable_name like 'autocommit%' limit 1;
9
10 select * from performance_schema.global_variables
11 where variable_name='FOO';
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 insert into performance_schema.global_variables
16 set variable_name='FOO', variable_value='BAR';
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 update performance_schema.global_variables
20 set variable_name='FOO', variable_value='BAR';
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 delete from performance_schema.global_variables
24 where variable_name <> 'FOO';
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 delete from performance_schema.global_variables;
28
29 -- error ER_TABLEACCESS_DENIED_ERROR
30 LOCK TABLES performance_schema.global_variables READ;
31 UNLOCK TABLES;
32
33 -- error ER_TABLEACCESS_DENIED_ERROR
34 LOCK TABLES performance_schema.global_variables WRITE;
35 UNLOCK TABLES;
36