6 drop table if exists t1,t2;
9 create table t1 ( n int auto_increment primary key);
11 insert into t1 values(NULL);
14 lock tables t1 write, t1 as t0 read;
15 insert into t1 values(NULL);
18 lock tables t1 write, t1 as t0 read, t1 as t2 read;
19 insert into t1 values(NULL);
22 lock tables t1 write, t1 as t0 write, t1 as t2 read;
23 insert into t1 values(NULL);
26 lock tables t1 write, t1 as t0 write, t1 as t2 read, t1 as t3 read;
27 insert into t1 values(NULL);
30 lock tables t1 write, t1 as t0 write, t1 as t2 write;
31 insert into t1 values(NULL);
37 # Test of locking and delete of files
40 CREATE TABLE t1 (a int);
41 CREATE TABLE t2 (a int);
42 lock tables t1 write,t1 as b write, t2 write, t2 as c read;
45 CREATE TABLE t1 (a int);
46 CREATE TABLE t2 (a int);
47 lock tables t1 write,t1 as b write, t2 write, t2 as c read;
54 # Bug#23588 SHOW COLUMNS on a temporary table causes locking issues
56 create temporary table t1(f1 int);
58 insert into t1 values (1);
60 insert into t1 values(2);