Debian Codegraph @

mysql-test/suite/perfschema/t/dml_session_connect_attrs.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.session_connect_attrs
8 LIMIT 1;
9
10 SELECT * FROM performance_schema.session_connect_attrs
11 where ATTR_NAME='FOO' OR ATTR_VALUE='BAR';
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 INSERT INTO performance_schema.session_connect_attrs
16 SET ATTR_NAME='FOO', ATTR_VALUE='BAR',
17 ORDINAL_POSITION=100, PROCESS_ID=102;
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 UPDATE performance_schema.session_connect_attrs
21 SET ATTR_NAME='FOO';
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 UPDATE performance_schema.session_connect_attrs
25 SET ATTR_NAME='FOO' WHERE ATTR_VALUE='BAR';
26
27 --error ER_TABLEACCESS_DENIED_ERROR
28 DELETE FROM performance_schema.session_connect_attrs
29 WHERE ATTR_VALUE='BAR';
30
31 --error ER_TABLEACCESS_DENIED_ERROR
32 DELETE FROM performance_schema.session_connect_attrs;
33
34 -- error ER_TABLEACCESS_DENIED_ERROR
35 LOCK TABLES performance_schema.session_connect_attrs READ;
36 UNLOCK TABLES;
37
38 -- error ER_TABLEACCESS_DENIED_ERROR
39 LOCK TABLES performance_schema.session_connect_attrs WRITE;
40 UNLOCK TABLES;
41
42 --echo #
43 --echo # MDEV-25325 column_comment for performance_schema tables
44 --echo #
45 select column_name, column_comment
46 from information_schema.columns
47 where table_schema='performance_schema' and table_name='session_connect_attrs';