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