Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --disable_result_log
4 select * from performance_schema.user_variables_by_thread
5 where variable_name like 'foo%' limit 1;
6
7 select * from performance_schema.user_variables_by_thread
8 where variable_name='FOO';
9 --enable_result_log
10
11 --error ER_TABLEACCESS_DENIED_ERROR
12 insert into performance_schema.user_variables_by_thread
13 set thread_id=12, variable_name='foo', variable_value='bar';
14
15 --error ER_TABLEACCESS_DENIED_ERROR
16 update performance_schema.user_variables_by_thread
17 set thread_id=12;
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 update performance_schema.user_variables_by_thread
21 set thread_id=12 where variable_name like "FOO";
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 delete from performance_schema.user_variables_by_thread
25 where thread_id=1;
26
27 --error ER_TABLEACCESS_DENIED_ERROR
28 delete from performance_schema.user_variables_by_thread;
29
30 -- error ER_TABLEACCESS_DENIED_ERROR
31 LOCK TABLES performance_schema.user_variables_by_thread READ;
32 UNLOCK TABLES;
33
34 -- error ER_TABLEACCESS_DENIED_ERROR
35 LOCK TABLES performance_schema.user_variables_by_thread WRITE;
36 UNLOCK TABLES;
37
38 DELIMITER |;
39 -- error ER_DBACCESS_DENIED_ERROR
40 CREATE TRIGGER test_uvar_trigger
41 AFTER INSERT ON performance_schema.user_variables_by_thread
42 FOR EACH ROW BEGIN
43 set @a='OK';
44 END|
45 DELIMITER ;|