Debian Codegraph @

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

raw
1 # must return 0, 6
2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*)
3 FROM performance_schema.session_connect_attrs
4 WHERE ATTR_NAME IN ('_os', '_client_name', '_pid',
5 '_client_version', '_platform', 'program_name')
6 AND PROCESSLIST_ID = CONNECTION_ID();
7 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
8 0 6
9 # must return 1
10 SELECT COUNT(DISTINCT PROCESSLIST_ID)
11 FROM performance_schema.session_connect_attrs;
12 COUNT(DISTINCT PROCESSLIST_ID)
13 1
14 # must return 0, 6
15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*)
16 FROM performance_schema.session_account_connect_attrs
17 WHERE ATTR_NAME IN ('_os', '_client_name', '_pid',
18 '_client_version', '_platform', 'program_name')
19 AND PROCESSLIST_ID = CONNECTION_ID();
20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
21 0 6
22 # must return 1
23 SELECT COUNT(DISTINCT PROCESSLIST_ID)
24 FROM performance_schema.session_account_connect_attrs;
25 COUNT(DISTINCT PROCESSLIST_ID)
26 1
27 CREATE USER wl5924@localhost;
28 connect non_privileged_user,localhost,wl5924,,"*NO-ONE*";
29 connection default;
30 # must return 1
31 SELECT COUNT(DISTINCT PROCESSLIST_ID)
32 FROM performance_schema.session_account_connect_attrs;
33 COUNT(DISTINCT PROCESSLIST_ID)
34 1
35 # must return 2
36 SELECT COUNT(DISTINCT PROCESSLIST_ID)
37 FROM performance_schema.session_connect_attrs;
38 COUNT(DISTINCT PROCESSLIST_ID)
39 2
40 connection non_privileged_user;
41 # must return 1
42 SELECT COUNT(DISTINCT PROCESSLIST_ID)
43 FROM performance_schema.session_account_connect_attrs;
44 COUNT(DISTINCT PROCESSLIST_ID)
45 1
46 SELECT COUNT(DISTINCT PROCESSLIST_ID)
47 FROM performance_schema.session_connect_attrs;
48 ERROR 42000: SELECT command denied to user 'wl5924'@'localhost' for table `performance_schema`.`session_connect_attrs`
49 connection default;
50 disconnect non_privileged_user;
51 grant select on performance_schema.* to wl5924@localhost;
52 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*)
53 FROM performance_schema.session_account_connect_attrs
54 WHERE ATTR_NAME IN ('_os', '_client_name', '_pid',
55 '_client_version', '_platform', 'program_name')
56 AND PROCESSLIST_ID = CONNECTION_ID();
57 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
58 0 6
59 DROP USER wl5924@localhost;