Debian Codegraph @

mysql-test/suite/perfschema/t/dml_socket_summary_by_instance.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.socket_summary_by_instance
8 limit 1;
9
10 select * from performance_schema.socket_summary_by_instance
11 where object_instance_begin='FOO';
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 insert into performance_schema.socket_summary_by_instance
16 set object_instance_begin=1,
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.socket_summary_by_instance
22 set count_star=12;
23
24 --error ER_TABLEACCESS_DENIED_ERROR
25 update performance_schema.socket_summary_by_instance
26 set count_star=12 where object_instance_begin like "FOO";
27
28 --error ER_TABLEACCESS_DENIED_ERROR
29 delete from performance_schema.socket_summary_by_instance
30 where count_star=1;
31
32 --error ER_TABLEACCESS_DENIED_ERROR
33 delete from performance_schema.socket_summary_by_instance;
34
35 -- error ER_TABLEACCESS_DENIED_ERROR
36 LOCK TABLES performance_schema.socket_summary_by_instance READ;
37 UNLOCK TABLES;
38
39 -- error ER_TABLEACCESS_DENIED_ERROR
40 LOCK TABLES performance_schema.socket_summary_by_instance 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='socket_summary_by_instance';