2
# MDEV-4824 userstats - wrong user statistics
4
--source include/not_embedded.inc
6
create user foo@localhost identified by 'foo';
10
connect(foo, localhost, foo, foo);
15
# wait for user_statistics changes to become visible
16
let $wait_condition= select count(*) = 1 from information_schema.processlist;
17
--source include/wait_condition.inc
19
# 41 is for ps-procotol
20
--replace_result 41 18
21
select user, bytes_received from information_schema.user_statistics where user = 'foo';
23
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
24
--error ER_ACCESS_DENIED_ERROR
25
connect(foo, localhost, foo, bar);
29
--replace_result 41 18
30
select user, bytes_received from information_schema.user_statistics where user = 'foo';
32
drop user foo@localhost;
33
set global userstat=0;