Debian Codegraph @

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

raw
1 # This line and the line below is a temporary line for tests that do not need MyISAM in future, but need to be kept for tests that need it.
2 #--source include/have_myisam.inc
3
4 # Tests for PERFORMANCE_SCHEMA
5
6 --source include/not_embedded.inc
7 --source include/have_perfschema.inc
8
9 #--disable_result_log
10 select * from performance_schema.events_statements_summary_by_program
11 where object_name like 'XXYYZZ%' limit 1;
12
13 select * from performance_schema.events_statements_summary_by_program
14 where object_name='XXYYZZ';
15 #--enable_result_log
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 insert into performance_schema.events_statements_summary_by_program
19 set object_name='XXYYZZ', count_star=1, sum_timer_wait=2, min_timer_wait=3,
20 avg_timer_wait=4, max_timer_wait=5;
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 update performance_schema.events_statements_summary_by_program
24 set count_star=12;
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 update performance_schema.events_statements_summary_by_program
28 set count_star=12 where object_name like "XXYYZZ";
29
30 --error ER_TABLEACCESS_DENIED_ERROR
31 delete from performance_schema.events_statements_summary_by_program
32 where count_star=1;
33
34 --error ER_TABLEACCESS_DENIED_ERROR
35 delete from performance_schema.events_statements_summary_by_program;
36
37 -- error ER_TABLEACCESS_DENIED_ERROR
38 LOCK TABLES performance_schema.events_statements_summary_by_program READ;
39 UNLOCK TABLES;
40
41 -- error ER_TABLEACCESS_DENIED_ERROR
42 LOCK TABLES performance_schema.events_statements_summary_by_program WRITE;
43 UNLOCK TABLES;
44