Debian Codegraph @

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

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