Debian Codegraph @

mysql-test/suite/perfschema/r/dml_session_connect_attrs.result

raw
1 SELECT * FROM performance_schema.session_connect_attrs
2 LIMIT 1;
3 SELECT * FROM performance_schema.session_connect_attrs
4 where ATTR_NAME='FOO' OR ATTR_VALUE='BAR';
5 INSERT INTO performance_schema.session_connect_attrs
6 SET ATTR_NAME='FOO', ATTR_VALUE='BAR',
7 ORDINAL_POSITION=100, PROCESS_ID=102;
8 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table `performance_schema`.`session_connect_attrs`
9 UPDATE performance_schema.session_connect_attrs
10 SET ATTR_NAME='FOO';
11 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`session_connect_attrs`
12 UPDATE performance_schema.session_connect_attrs
13 SET ATTR_NAME='FOO' WHERE ATTR_VALUE='BAR';
14 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`session_connect_attrs`
15 DELETE FROM performance_schema.session_connect_attrs
16 WHERE ATTR_VALUE='BAR';
17 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`session_connect_attrs`
18 DELETE FROM performance_schema.session_connect_attrs;
19 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`session_connect_attrs`
20 LOCK TABLES performance_schema.session_connect_attrs READ;
21 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`session_connect_attrs`
22 UNLOCK TABLES;
23 LOCK TABLES performance_schema.session_connect_attrs WRITE;
24 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`session_connect_attrs`
25 UNLOCK TABLES;
26 #
27 # MDEV-25325 column_comment for performance_schema tables
28 #
29 select column_name, column_comment
30 from information_schema.columns
31 where table_schema='performance_schema' and table_name='session_connect_attrs';
32 column_name column_comment
33 PROCESSLIST_ID Session connection identifier.
34 ATTR_NAME Attribute name.
35 ATTR_VALUE Attribute value.
36 ORDINAL_POSITION Order in which attribute was added to the connection attributes.