Debian Codegraph @

mysql-test/suite/perfschema/t/dml_table_handles.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.table_handles;
8 --enable_result_log
9
10 select * from performance_schema.table_handles
11 where object_name='foo';
12
13 --error ER_TABLEACCESS_DENIED_ERROR
14 insert into performance_schema.table_handles
15 set object_name='FOO', owner_event_id=1;
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 update performance_schema.table_handles
19 set owner_event_id=12 where object_name='foo';
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 delete from performance_schema.table_handles;
23
24 --error ER_TABLEACCESS_DENIED_ERROR
25 delete from performance_schema.table_handles
26 where timer_name='CYCLE';
27
28 -- error ER_TABLEACCESS_DENIED_ERROR
29 LOCK TABLES performance_schema.table_handles READ;
30 UNLOCK TABLES;
31
32 -- error ER_TABLEACCESS_DENIED_ERROR
33 LOCK TABLES performance_schema.table_handles WRITE;
34 UNLOCK TABLES;
35