summaryrefslogtreecommitdiff
path: root/mysql-test/t/tablelock.test
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-03-09 14:05:35 +0200
committerMonty <monty@mariadb.org>2018-03-29 13:59:44 +0300
commita7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch)
tree70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/tablelock.test
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/t/tablelock.test')
-rw-r--r--mysql-test/t/tablelock.test64
1 files changed, 0 insertions, 64 deletions
diff --git a/mysql-test/t/tablelock.test b/mysql-test/t/tablelock.test
deleted file mode 100644
index 5ac93f09ac1..00000000000
--- a/mysql-test/t/tablelock.test
+++ /dev/null
@@ -1,64 +0,0 @@
-#
-# Test of lock tables
-#
-
---disable_warnings
-drop table if exists t1,t2;
---enable_warnings
-
-create table t1 ( n int auto_increment primary key);
-lock tables t1 write;
-insert into t1 values(NULL);
-unlock tables;
-check table t1;
-lock tables t1 write, t1 as t0 read;
-insert into t1 values(NULL);
-unlock tables;
-check table t1;
-lock tables t1 write, t1 as t0 read, t1 as t2 read;
-insert into t1 values(NULL);
-unlock tables;
-check table t1;
-lock tables t1 write, t1 as t0 write, t1 as t2 read;
-insert into t1 values(NULL);
-unlock tables;
-check table t1;
-lock tables t1 write, t1 as t0 write, t1 as t2 read, t1 as t3 read;
-insert into t1 values(NULL);
-unlock tables;
-check table t1;
-lock tables t1 write, t1 as t0 write, t1 as t2 write;
-insert into t1 values(NULL);
-unlock tables;
-check table t1;
-drop table t1;
-
-#
-# Test of locking and delete of files
-#
-
-CREATE TABLE t1 (a int);
-CREATE TABLE t2 (a int);
-lock tables t1 write,t1 as b write, t2 write, t2 as c read;
-drop table t1,t2;
-
-CREATE TABLE t1 (a int);
-CREATE TABLE t2 (a int);
-lock tables t1 write,t1 as b write, t2 write, t2 as c read;
-drop table t2,t1;
-unlock tables;
-
-# End of 4.1 tests
-
-#
-# Bug#23588 SHOW COLUMNS on a temporary table causes locking issues
-#
-create temporary table t1(f1 int);
-lock tables t1 write;
-insert into t1 values (1);
-show columns from t1;
-insert into t1 values(2);
-drop table t1;
-unlock tables;
-
-# End of 5.0 tests