Debian Codegraph @

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

raw
1 --echo ##
2 --echo ## Test the Performance Schema-based implementation of SHOW PROCESSLIST.
3 --echo ## Verify behavior for anonymous users and PROCESS_ACL.
4 --echo ##
5
6 --source include/no_protocol.inc
7 --source include/not_embedded.inc
8
9 SELECT @@global.performance_schema_show_processlist INTO @save_processlist;
10
11 --source include/add_anonymous_users.inc
12
13 SET @@global.performance_schema_show_processlist = OFF;
14
15 connect (anon,localhost,test,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
16
17 SHOW GRANTS;
18
19 # Empty
20 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
21
22 # Empty
23 SELECT * FROM performance_schema.processlist;
24
25 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
26 SHOW PROCESSLIST;
27
28 connection default;
29
30 SET @@global.performance_schema_show_processlist = ON;
31
32 connection anon;
33
34 SHOW GRANTS;
35
36 # Empty
37 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
38
39 # Empty
40 SELECT * FROM performance_schema.processlist;
41
42 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
43 SHOW PROCESSLIST;
44
45 disconnect anon;
46 connection default;
47
48 GRANT PROCESS ON *.* TO ''@'localhost';
49
50 SET @@global.performance_schema_show_processlist = OFF;
51
52 connect (anon2,localhost,test,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
53
54 SHOW GRANTS;
55
56 # Full rows
57 SELECT count(*) >= 2 FROM INFORMATION_SCHEMA.PROCESSLIST;
58
59 # Full rows
60 SELECT count(*) >= 2 FROM performance_schema.processlist;
61
62 # Full rows
63 --disable_result_log
64 SHOW PROCESSLIST;
65 --enable_result_log
66
67 SELECT "Previous statement is now completed." as status;
68
69 connection default;
70 # Returns ROWS_SENT = 0 even when SHOW PROCESSLIST has rows
71 SELECT EVENT_NAME, SQL_TEXT, ROWS_SENT as BROKEN_ROWS_SENT
72 FROM performance_schema.events_statements_history
73 WHERE SQL_TEXT = "SHOW PROCESSLIST";
74 connection anon2;
75
76
77 connection default;
78
79 TRUNCATE TABLE performance_schema.events_statements_history;
80 set @@global.performance_schema_show_processlist = ON;
81
82
83 connection anon2;
84
85 SHOW GRANTS;
86
87 # Full rows
88 SELECT count(*) >= 2 FROM INFORMATION_SCHEMA.PROCESSLIST;
89
90 # Full rows
91 SELECT count(*) >= 2 FROM performance_schema.processlist;
92
93 # Full rows
94 --disable_result_log
95 SHOW PROCESSLIST;
96 --enable_result_log
97
98 SELECT "Previous statement is now completed." as status;
99
100 connection default;
101 SELECT EVENT_NAME, SQL_TEXT, ROWS_SENT >= 2
102 FROM performance_schema.events_statements_history
103 WHERE SQL_TEXT = "SHOW PROCESSLIST";
104
105 disconnect anon2;
106 connection default;
107
108 --source include/delete_anonymous_users.inc
109
110 SET @@global.performance_schema_show_processlist = @save_processlist;
111