summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRich Prohaska <prohaska@tokutek.com>2015-01-22 07:21:52 -0500
committerRich Prohaska <prohaska@tokutek.com>2015-01-22 07:21:52 -0500
commitd8493f40ef981f63e8e6713b31f5f1159807b037 (patch)
tree439da683e77c239c4bb2a6d3632ba81491b5eebc
parentc30c109302d9eeab3e3bd945797e3192f27a1816 (diff)
parent1abb2286faa625fb8a86b0350018f3acd2cc96e5 (diff)
downloadmariadb-git-d8493f40ef981f63e8e6713b31f5f1159807b037.tar.gz
Merge branch 'master' into releases/tokudb-7.5
-rw-r--r--mysql-test/suite/tokudb.bugs/r/db801.result18
-rw-r--r--mysql-test/suite/tokudb.bugs/t/db801.test50
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;
+
+