Debian Codegraph @

mysql-test/suite/perfschema/t/dml_uvar_by_thread.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.user_variables_by_thread
8 where variable_name like 'foo%' limit 1;
9
10 select * from performance_schema.user_variables_by_thread
11 where variable_name='FOO';
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 insert into performance_schema.user_variables_by_thread
16 set thread_id=12, variable_name='foo', variable_value='bar';
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 update performance_schema.user_variables_by_thread
20 set thread_id=12;
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 update performance_schema.user_variables_by_thread
24 set thread_id=12 where variable_name like "FOO";
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 delete from performance_schema.user_variables_by_thread
28 where thread_id=1;
29
30 --error ER_TABLEACCESS_DENIED_ERROR
31 delete from performance_schema.user_variables_by_thread;
32
33 -- error ER_TABLEACCESS_DENIED_ERROR
34 LOCK TABLES performance_schema.user_variables_by_thread READ;
35 UNLOCK TABLES;
36
37 -- error ER_TABLEACCESS_DENIED_ERROR
38 LOCK TABLES performance_schema.user_variables_by_thread WRITE;
39 UNLOCK TABLES;
40
41 DELIMITER |;
42 -- error ER_DBACCESS_DENIED_ERROR
43 CREATE TRIGGER test_uvar_trigger
44 AFTER INSERT ON performance_schema.user_variables_by_thread
45 FOR EACH ROW BEGIN
46 set @a='OK';
47 END|
48 DELIMITER ;|