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