Debian Codegraph @

mysql-test/suite/perfschema/t/dml_metadata_locks.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.metadata_locks;
8 --enable_result_log
9
10 select * from performance_schema.metadata_locks
11 where object_name='foo';
12
13 --error ER_TABLEACCESS_DENIED_ERROR
14 insert into performance_schema.metadata_locks
15 set object_name='FOO', owner_thread_id=1;
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 update performance_schema.metadata_locks
19 set owner_thread_id=12 where object_name='foo';
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 delete from performance_schema.metadata_locks;
23
24 --error ER_TABLEACCESS_DENIED_ERROR
25 delete from performance_schema.metadata_locks
26 where timer_name='CYCLE';
27
28 -- error ER_TABLEACCESS_DENIED_ERROR
29 LOCK TABLES performance_schema.metadata_locks READ;
30 UNLOCK TABLES;
31
32 -- error ER_TABLEACCESS_DENIED_ERROR
33 LOCK TABLES performance_schema.metadata_locks WRITE;
34 UNLOCK TABLES;
35
36 --echo #
37 --echo # MDEV-25325 column_comment for performance_schema tables
38 --echo #
39 select column_name, column_comment
40 from information_schema.columns
41 where table_schema='performance_schema' and table_name='metadata_locks';