Debian Codegraph @

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

raw
1 select * from performance_schema.users
2 limit 1;
3 select * from performance_schema.users
4 where user='FOO';
5 insert into performance_schema.users
6 set user='FOO',
7 current_connections=1, total_connections=2;
8 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table `performance_schema`.`users`
9 update performance_schema.users
10 set current_connections=12;
11 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`users`
12 update performance_schema.users
13 set current_connections=12 where user like "FOO";
14 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`users`
15 delete from performance_schema.users
16 where total_connections=1;
17 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`users`
18 delete from performance_schema.users;
19 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`users`
20 LOCK TABLES performance_schema.users READ;
21 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`users`
22 UNLOCK TABLES;
23 LOCK TABLES performance_schema.users WRITE;
24 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`users`
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='users';
32 column_name column_comment
33 USER The connection's client user name for the connection, or NULL if an internal thread.
34 CURRENT_CONNECTIONS Current connections for the user.
35 TOTAL_CONNECTIONS Total connections for the user.