Debian Codegraph @

mysql-test/suite/perfschema/t/dml_rwlock_instances.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.rwlock_instances limit 1;
8
9 select * from performance_schema.rwlock_instances
10 where name='FOO';
11 --enable_result_log
12
13 --error ER_TABLEACCESS_DENIED_ERROR
14 insert into performance_schema.rwlock_instances
15 set name='FOO', object_instance_begin=12;
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 update performance_schema.rwlock_instances
19 set name='FOO';
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 delete from performance_schema.rwlock_instances
23 where name like "wait/%";
24
25 --error ER_TABLEACCESS_DENIED_ERROR
26 delete from performance_schema.rwlock_instances;
27
28 -- error ER_TABLEACCESS_DENIED_ERROR
29 LOCK TABLES performance_schema.rwlock_instances READ;
30 UNLOCK TABLES;
31
32 -- error ER_TABLEACCESS_DENIED_ERROR
33 LOCK TABLES performance_schema.rwlock_instances 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='rwlock_instances';