Debian Codegraph @

mysql-test/suite/perfschema/t/dml_tlws_by_table.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_lock_waits_summary_by_table
8 limit 1;
9
10 select * from performance_schema.table_lock_waits_summary_by_table
11 where object_name='FOO';
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 insert into performance_schema.table_lock_waits_summary_by_table
16 set object_type='TABLE', object_name='FOO', object_schema='BAR',
17 count_star=1, sum_timer_wait=2, min_timer_wait=3,
18 avg_timer_wait=4, max_timer_wait=5;
19
20 --error ER_TABLEACCESS_DENIED_ERROR
21 update performance_schema.table_lock_waits_summary_by_table
22 set count_star=12;
23
24 --error ER_TABLEACCESS_DENIED_ERROR
25 update performance_schema.table_lock_waits_summary_by_table
26 set count_star=12 where object_name like "FOO";
27
28 --error ER_TABLEACCESS_DENIED_ERROR
29 delete from performance_schema.table_lock_waits_summary_by_table
30 where count_star=1;
31
32 --error ER_TABLEACCESS_DENIED_ERROR
33 delete from performance_schema.table_lock_waits_summary_by_table;
34
35 -- error ER_TABLEACCESS_DENIED_ERROR
36 LOCK TABLES performance_schema.table_lock_waits_summary_by_table READ;
37 UNLOCK TABLES;
38
39 -- error ER_TABLEACCESS_DENIED_ERROR
40 LOCK TABLES performance_schema.table_lock_waits_summary_by_table WRITE;
41 UNLOCK TABLES;
42
43 --echo #
44 --echo # MDEV-25325 column_comment for performance_schema tables
45 --echo #
46 select column_name, column_comment
47 from information_schema.columns
48 where table_schema='performance_schema' and table_name='table_lock_waits_summary_by_table';