1# must return 0, 6 2SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 3FROM performance_schema.session_connect_attrs 4WHERE ATTR_NAME IN ('_os', '_client_name', '_pid', 5'_client_version', '_platform', 'program_name') 6AND PROCESSLIST_ID = CONNECTION_ID(); 7SUM(ISNULL(ATTR_VALUE)) COUNT(*) 80 6 9# must return 1 10SELECT COUNT(DISTINCT PROCESSLIST_ID) 11FROM performance_schema.session_connect_attrs; 12COUNT(DISTINCT PROCESSLIST_ID) 131 14# must return 0, 6 15SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 16FROM performance_schema.session_account_connect_attrs 17WHERE ATTR_NAME IN ('_os', '_client_name', '_pid', 18'_client_version', '_platform', 'program_name') 19AND PROCESSLIST_ID = CONNECTION_ID(); 20SUM(ISNULL(ATTR_VALUE)) COUNT(*) 210 6 22# must return 1 23SELECT COUNT(DISTINCT PROCESSLIST_ID) 24FROM performance_schema.session_account_connect_attrs; 25COUNT(DISTINCT PROCESSLIST_ID) 261 27CREATE USER wl5924@localhost; 28# must return 1 29SELECT COUNT(DISTINCT PROCESSLIST_ID) 30FROM performance_schema.session_account_connect_attrs; 31COUNT(DISTINCT PROCESSLIST_ID) 321 33# must return 2 34SELECT COUNT(DISTINCT PROCESSLIST_ID) 35FROM performance_schema.session_connect_attrs; 36COUNT(DISTINCT PROCESSLIST_ID) 372 38# must return 1 39SELECT COUNT(DISTINCT PROCESSLIST_ID) 40FROM performance_schema.session_account_connect_attrs; 41COUNT(DISTINCT PROCESSLIST_ID) 421 43SELECT COUNT(DISTINCT PROCESSLIST_ID) 44FROM performance_schema.session_connect_attrs; 45ERROR 42000: SELECT command denied to user 'wl5924'@'localhost' for table 'session_connect_attrs' 46DROP USER wl5924@localhost; 47