summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb/t/lockretry-writelocktable.insert2.test
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2013-09-09 13:59:38 +0200
committerSergei Golubchik <sergii@pisem.net>2013-09-09 13:59:38 +0200
commit9a3b9a541659f9d2637614df417a39d5508abeaa (patch)
tree5df6de4ffdeae387d6610f8b8462ca292b97cd7a /storage/tokudb/mysql-test/tokudb/t/lockretry-writelocktable.insert2.test
parentd29f874db18068926ee899c532b25d0c8872f5dd (diff)
downloadmariadb-git-9a3b9a541659f9d2637614df417a39d5508abeaa.tar.gz
tokudb test suites
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/t/lockretry-writelocktable.insert2.test')
-rw-r--r--storage/tokudb/mysql-test/tokudb/t/lockretry-writelocktable.insert2.test32
1 files changed, 32 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/lockretry-writelocktable.insert2.test b/storage/tokudb/mysql-test/tokudb/t/lockretry-writelocktable.insert2.test
new file mode 100644
index 00000000000..6eec3efc8e8
--- /dev/null
+++ b/storage/tokudb/mysql-test/tokudb/t/lockretry-writelocktable.insert2.test
@@ -0,0 +1,32 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=TokuDB;
+
+connect (conn1,localhost,root,,);
+
+let $i=1000;
+while ($i)
+{
+ connection default;
+ LOCK TABLES t1 WRITE;
+ eval INSERT INTO t1 VALUES (-$i);
+
+ connection conn1;
+ send;
+ eval INSERT INTO t1 VALUES ($i);
+
+ connection default;
+ UNLOCK TABLES;
+
+ connection conn1;
+ reap;
+
+ dec $i;
+}
+
+disconnect conn1;
+
+connection default;
+DROP TABLE t1; \ No newline at end of file