Debian Codegraph @

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

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