Debian Codegraph @

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

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