Debian Codegraph @

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

raw
1 --disable_result_log
2 SELECT * FROM performance_schema.session_account_connect_attrs
3 LIMIT 1;
4
5 SELECT * FROM performance_schema.session_account_connect_attrs
6 where ATTR_NAME='FOO' OR ATTR_VALUE='BAR';
7 --enable_result_log
8
9 --error ER_TABLEACCESS_DENIED_ERROR
10 INSERT INTO performance_schema.session_account_connect_attrs
11 SET ATTR_NAME='FOO', ATTR_VALUE='BAR',
12 ORDINAL_POSITION=100, PROCESS_ID=102;
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 UPDATE performance_schema.session_account_connect_attrs
16 SET ATTR_NAME='FOO';
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 UPDATE performance_schema.session_account_connect_attrs
20 SET ATTR_NAME='FOO' WHERE ATTR_VALUE='BAR';
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 DELETE FROM performance_schema.session_account_connect_attrs
24 WHERE ATTR_VALUE='BAR';
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 DELETE FROM performance_schema.session_account_connect_attrs;
28
29 -- error ER_TABLEACCESS_DENIED_ERROR
30 LOCK TABLES performance_schema.session_account_connect_attrs READ;
31 UNLOCK TABLES;
32
33 -- error ER_TABLEACCESS_DENIED_ERROR
34 LOCK TABLES performance_schema.session_account_connect_attrs WRITE;
35 UNLOCK TABLES;