| 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; |