Debian Codegraph @

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

raw
1 ##
2 ## Test the Performance Schema-based implementation of SHOW PROCESSLIST.
3 ## Verify behavior for regular users and PROCESS_ACL.
4 ##
5 SELECT @@global.performance_schema_show_processlist INTO @save_processlist;
6 SET @@global.performance_schema_show_processlist = OFF;
7 CREATE USER 'regular'@'localhost';
8 SHOW GRANTS;
9 Grants for regular@localhost
10 GRANT USAGE ON *.* TO 'regular'@'localhost'
11 SELECT USER, INFO FROM INFORMATION_SCHEMA.PROCESSLIST;
12 USER INFO
13 regular SELECT USER, INFO FROM INFORMATION_SCHEMA.PROCESSLIST
14 SELECT USER, INFO FROM performance_schema.processlist;
15 USER INFO
16 regular SELECT USER, INFO FROM performance_schema.processlist
17 SHOW PROCESSLIST;
18 SELECT "Previous statement is now completed." as status;
19 status
20 Previous statement is now completed.
21 SELECT EVENT_NAME, SQL_TEXT, ROWS_SENT as BROKEN_ROWS_SENT
22 FROM performance_schema.events_statements_history
23 WHERE SQL_TEXT = "SHOW PROCESSLIST";
24 EVENT_NAME SQL_TEXT BROKEN_ROWS_SENT
25 statement/sql/show_processlist SHOW PROCESSLIST 0
26 TRUNCATE TABLE performance_schema.events_statements_history;
27 SET @@global.performance_schema_show_processlist = ON;
28 SHOW GRANTS;
29 Grants for regular@localhost
30 GRANT USAGE ON *.* TO 'regular'@'localhost'
31 SELECT USER, INFO FROM INFORMATION_SCHEMA.PROCESSLIST;
32 USER INFO
33 regular SELECT USER, INFO FROM INFORMATION_SCHEMA.PROCESSLIST
34 SELECT USER, INFO FROM performance_schema.processlist;
35 USER INFO
36 regular SELECT USER, INFO FROM performance_schema.processlist
37 SHOW PROCESSLIST;
38 SELECT "Previous statement is now completed." as status;
39 status
40 Previous statement is now completed.
41 SELECT EVENT_NAME, SQL_TEXT, ROWS_SENT
42 FROM performance_schema.events_statements_history
43 WHERE SQL_TEXT = "SHOW PROCESSLIST";
44 EVENT_NAME SQL_TEXT ROWS_SENT
45 statement/sql/show_processlist SHOW PROCESSLIST 1
46 TRUNCATE TABLE performance_schema.events_statements_history;
47 GRANT PROCESS ON *.* TO 'regular'@'localhost';
48 SET @@global.performance_schema_show_processlist = OFF;
49 SHOW GRANTS;
50 Grants for regular@localhost
51 GRANT PROCESS ON *.* TO 'regular'@'localhost'
52 SELECT count(*) >= 2 FROM INFORMATION_SCHEMA.PROCESSLIST;
53 count(*) >= 2
54 1
55 SELECT count(*) >= 2 FROM performance_schema.processlist;
56 count(*) >= 2
57 1
58 SHOW PROCESSLIST;
59 SELECT "Previous statement is now completed." as status;
60 status
61 Previous statement is now completed.
62 SELECT EVENT_NAME, SQL_TEXT, ROWS_SENT as BROKEN_ROWS_SENT
63 FROM performance_schema.events_statements_history
64 WHERE SQL_TEXT = "SHOW PROCESSLIST";
65 EVENT_NAME SQL_TEXT BROKEN_ROWS_SENT
66 statement/sql/show_processlist SHOW PROCESSLIST 0
67 TRUNCATE TABLE performance_schema.events_statements_history;
68 SET @@global.performance_schema_show_processlist = ON;
69 SHOW GRANTS;
70 Grants for regular@localhost
71 GRANT PROCESS ON *.* TO 'regular'@'localhost'
72 SELECT count(*) >= 2 FROM INFORMATION_SCHEMA.PROCESSLIST;
73 count(*) >= 2
74 1
75 SELECT count(*) >= 2 FROM performance_schema.processlist;
76 count(*) >= 2
77 1
78 SHOW PROCESSLIST;
79 SELECT "Previous statement is now completed." as status;
80 status
81 Previous statement is now completed.
82 SELECT EVENT_NAME, SQL_TEXT, ROWS_SENT >= 2
83 FROM performance_schema.events_statements_history
84 WHERE SQL_TEXT = "SHOW PROCESSLIST";
85 EVENT_NAME SQL_TEXT ROWS_SENT >= 2
86 statement/sql/show_processlist SHOW PROCESSLIST 1
87 TRUNCATE TABLE performance_schema.events_statements_history;
88 SET @@global.performance_schema_show_processlist = @save_processlist;
89 DROP USER 'regular'@'localhost';