Debian Codegraph @

mysql-test/suite/perfschema/t/dml_events_transactions_current.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.events_transactions_current
8 where event_name in ('transaction') limit 1;
9
10 select * from performance_schema.events_transactions_current
11 where event_name='FOO';
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 insert into performance_schema.events_transactions_current
16 set thread_id='1', event_id=1,
17 event_name='FOO', timer_start=1, timer_end=2, timer_wait=3;
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 update performance_schema.events_transactions_current
21 set timer_start=12;
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 update performance_schema.events_transactions_current
25 set timer_start=12 where thread_id=0;
26
27 --error ER_TABLEACCESS_DENIED_ERROR
28 delete from performance_schema.events_transactions_current
29 where thread_id=1;
30
31 --error ER_TABLEACCESS_DENIED_ERROR
32 delete from performance_schema.events_transactions_current;
33
34 -- error ER_TABLEACCESS_DENIED_ERROR
35 LOCK TABLES performance_schema.events_transactions_current READ;
36 UNLOCK TABLES;
37
38 -- error ER_TABLEACCESS_DENIED_ERROR
39 LOCK TABLES performance_schema.events_transactions_current WRITE;
40 UNLOCK TABLES;
41