Debian Codegraph @

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

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