~ubuntu-branches/ubuntu/trusty/mariadb-5.5/trusty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/t/userstat-badlogin-4824.test

  • Committer: Package Import Robot
  • Author(s): James Page, Otto Kekäläinen
  • Date: 2014-02-17 16:51:52 UTC
  • mfrom: (2.1.1 sid)
  • Revision ID: package-import@ubuntu.com-20140217165152-k315d3175g865kkx
Tags: 5.5.35-1
[ Otto Kekäläinen ]
* New upstream release, fixing the following security issues:
  - Buffer overflow in client/mysql.cc (Closes: #737597).
    - CVE-2014-0001
  - http://www.oracle.com/technetwork/topics/security/cpujan2014-1972949.html
    - CVE-2013-5891
    - CVE-2013-5908
    - CVE-2014-0386
    - CVE-2014-0393
    - CVE-2014-0401
    - CVE-2014-0402
    - CVE-2014-0412
    - CVE-2014-0420
    - CVE-2014-0437
* Upstream https://mariadb.atlassian.net/browse/MDEV-4902
  fixes compatibility with Bison 3.0 (Closes: #733002)
* Updated Russian debconf translation (Closes: #734426)
* Updated Japanese debconf translation (Closes: #735284)
* Updated French debconf translation (Closes: #736480)
* Renamed SONAME properly (Closes: #732967)

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
#
 
2
# MDEV-4824 userstats - wrong user statistics
 
3
#
 
4
--source include/not_embedded.inc
 
5
 
 
6
create user foo@localhost identified by 'foo';
 
7
flush user_statistics;
 
8
set global userstat=1;
 
9
 
 
10
connect(foo, localhost, foo, foo);
 
11
select 1;
 
12
disconnect foo;
 
13
connection default;
 
14
 
 
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
 
18
 
 
19
# 41 is for ps-procotol
 
20
--replace_result 41 18
 
21
select user, bytes_received from information_schema.user_statistics where user = 'foo';
 
22
 
 
23
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
 
24
--error ER_ACCESS_DENIED_ERROR
 
25
connect(foo, localhost, foo, bar);
 
26
 
 
27
connection default;
 
28
 
 
29
--replace_result 41 18
 
30
select user, bytes_received from information_schema.user_statistics where user = 'foo';
 
31
 
 
32
drop user foo@localhost;
 
33
set global userstat=0;