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 # must return 1
29 SELECT COUNT(DISTINCT PROCESSLIST_ID)
30 FROM performance_schema.session_account_connect_attrs;
31 COUNT(DISTINCT PROCESSLIST_ID)
32 1
33 # must return 2
34 SELECT COUNT(DISTINCT PROCESSLIST_ID)
35 FROM performance_schema.session_connect_attrs;
36 COUNT(DISTINCT PROCESSLIST_ID)
37 2
38 # must return 1
39 SELECT COUNT(DISTINCT PROCESSLIST_ID)
40 FROM performance_schema.session_account_connect_attrs;
41 COUNT(DISTINCT PROCESSLIST_ID)
42 1
43 SELECT COUNT(DISTINCT PROCESSLIST_ID)
44 FROM performance_schema.session_connect_attrs;
45 ERROR 42000: SELECT command denied to user 'wl5924'@'localhost' for table 'session_connect_attrs'
46 DROP USER wl5924@localhost;