1 files changed, 41 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/t/lock_uniq_key_empty.test b/storage/tokudb/mysql-test/tokudb_bugs/t/lock_uniq_key_empty.test
new file mode 100644
index 00000000000..3f8d7113dff
--- /dev/null
+++ b/storage/tokudb/mysql-test/tokudb_bugs/t/lock_uniq_key_empty.test
@@ -0,0 +1,41 @@
+# test case for overlocking unique secondary keys
+source include/have_tokudb.inc;
+set default_storage_engine=tokudb;
+disable_warnings;
+drop table if exists t;
+enable_warnings;
+
+create table t (id int, unique key(id));
+connect(c1,localhost,root,,);
+begin;
+insert into t values (1);
+connect(c2,localhost,root,,);
+begin;
+insert into t values (2);
+connection c1;
+commit;
+connection c2;
+commit;
+connection default;
+select * from t;
+disconnect c1;
+disconnect c2;
+drop table if exists t;
+
+create table t (id int not null, unique key(id));
+connect(c1,localhost,root,,);
+begin;
+insert into t values (1);
+connect(c2,localhost,root,,);
+begin;
+insert into t values (2);
+connection c1;
+commit;
+connection c2;
+commit;
+connection default;
+select * from t;
+disconnect c1;
+disconnect c2;
+drop table if exists t;
+