diff options
author | Rich Prohaska <prohaska@tokutek.com> | 2015-01-22 07:21:52 -0500 |
---|---|---|
committer | Rich Prohaska <prohaska@tokutek.com> | 2015-01-22 07:21:52 -0500 |
commit | d8493f40ef981f63e8e6713b31f5f1159807b037 (patch) | |
tree | 439da683e77c239c4bb2a6d3632ba81491b5eebc | |
parent | c30c109302d9eeab3e3bd945797e3192f27a1816 (diff) | |
parent | 1abb2286faa625fb8a86b0350018f3acd2cc96e5 (diff) | |
download | mariadb-git-d8493f40ef981f63e8e6713b31f5f1159807b037.tar.gz |
Merge branch 'master' into releases/tokudb-7.5
-rw-r--r-- | mysql-test/suite/tokudb.bugs/r/db801.result | 18 | ||||
-rw-r--r-- | mysql-test/suite/tokudb.bugs/t/db801.test | 50 |
2 files changed, 68 insertions, 0 deletions
diff --git a/mysql-test/suite/tokudb.bugs/r/db801.result b/mysql-test/suite/tokudb.bugs/r/db801.result new file mode 100644 index 00000000000..800db69ba39 --- /dev/null +++ b/mysql-test/suite/tokudb.bugs/r/db801.result @@ -0,0 +1,18 @@ +set default_storage_engine=tokudb; +drop table if exists t; +create table t (id int not null primary key, c int not null) engine=tokudb; +insert into t values (1,0); +begin; +update t set c=10 where id=1; +update t set c=100; +ERROR HY000: Lock wait timeout exceeded; try restarting transaction +rollback; +drop table t; +create table t (id int not null primary key, c int not null) engine=tokudb partition by hash(id) partitions 1; +insert into t values (1,0); +begin; +update t set c=10 where id=1; +update t set c=100; +ERROR HY000: Lock wait timeout exceeded; try restarting transaction +rollback; +drop table t; diff --git a/mysql-test/suite/tokudb.bugs/t/db801.test b/mysql-test/suite/tokudb.bugs/t/db801.test new file mode 100644 index 00000000000..8a8fcea1496 --- /dev/null +++ b/mysql-test/suite/tokudb.bugs/t/db801.test @@ -0,0 +1,50 @@ +# test for the DB-801 bug on mysql-5.5.41 +source include/have_tokudb.inc; +source include/have_partition.inc; +set default_storage_engine=tokudb; + +disable_warnings; +drop table if exists t; +enable_warnings; + +# run the test on a tokudb table +create table t (id int not null primary key, c int not null) engine=tokudb; + +insert into t values (1,0); + +connect(conn1,localhost,root,,); +connection default; +begin; +update t set c=10 where id=1; + +connection conn1; +--error ER_LOCK_WAIT_TIMEOUT +update t set c=100; + +connection default; +rollback; +disconnect conn1; + +drop table t; + +# run the test on a partitioned tokudb table +create table t (id int not null primary key, c int not null) engine=tokudb partition by hash(id) partitions 1; + +insert into t values (1,0); + +connect(conn1,localhost,root,,); +connection default; +begin; +update t set c=10 where id=1; + +connection conn1; +--error ER_LOCK_WAIT_TIMEOUT +update t set c=100; + +connection default; +rollback; +disconnect conn1; + +drop table t; + + |