← Back to branch summary

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

« back to all changes in this revision

Viewing changes to storage/tokudb/mysql-test/tokudb/t/locks-select-update-1.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
http://bugs.debian.org/737597
http://bugs.debian.org/733002
http://bugs.debian.org/734426
http://bugs.debian.org/735284
http://bugs.debian.org/736480
http://bugs.debian.org/732967
[ 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:
storage/tokudb/mysql-test/tokudb/t/locks-select-update-1.test
 
1
# test that select for update is executed with serializable isolation
 
2
 
 
3
SET DEFAULT_STORAGE_ENGINE='tokudb';
 
4
 
 
5
--disable_warnings
 
6
drop table if exists t;
 
7
--enable_warnings
 
8
create table t (a int primary key, b int);
 
9
insert into t values (1,0);
 
10
set session transaction isolation level repeatable read;
 
11
begin;
 
12
# t1 select for update
 
13
select * from t where a=1 for update;
 
14
# t2 update
 
15
update t set b=b+1 where a=1;
 
16
connect(conn1,localhost,root);
 
17
set session transaction isolation level repeatable read;
 
18
begin;
 
19
# t2 select for update, should hang until t1 commits
 
20
send select * from t where a=1 for update;
 
21
connection default;
 
22
# t1 commit
 
23
commit;
 
24
connection conn1;
 
25
# t2 select for update returns
 
26
reap;
 
27
# t2 update
 
28
update t set b=b+1 where a=1;
 
29
select * from t;
 
30
commit;
 
31
connection default;
 
32
disconnect conn1;
 
33
drop table t;
 
34