Debian Codegraph @

mysql-test/suite/perfschema/t/dml_socket_summary_by_instance.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --disable_result_log
4 select * from performance_schema.socket_summary_by_instance
5 limit 1;
6
7 select * from performance_schema.socket_summary_by_instance
8 where object_instance_begin='FOO';
9 --enable_result_log
10
11 --error ER_TABLEACCESS_DENIED_ERROR
12 insert into performance_schema.socket_summary_by_instance
13 set object_instance_begin=1,
14 count_star=1, sum_timer_wait=2, min_timer_wait=3,
15 avg_timer_wait=4, max_timer_wait=5;
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 update performance_schema.socket_summary_by_instance
19 set count_star=12;
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 update performance_schema.socket_summary_by_instance
23 set count_star=12 where object_instance_begin like "FOO";
24
25 --error ER_TABLEACCESS_DENIED_ERROR
26 delete from performance_schema.socket_summary_by_instance
27 where count_star=1;
28
29 --error ER_TABLEACCESS_DENIED_ERROR
30 delete from performance_schema.socket_summary_by_instance;
31
32 -- error ER_TABLEACCESS_DENIED_ERROR
33 LOCK TABLES performance_schema.socket_summary_by_instance READ;
34 UNLOCK TABLES;
35
36 -- error ER_TABLEACCESS_DENIED_ERROR
37 LOCK TABLES performance_schema.socket_summary_by_instance WRITE;
38 UNLOCK TABLES;
39