Debian Codegraph @

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

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