~drizzle-trunk/drizzle/development

drop table if exists t1,t2;

drop database if exists mysqltest;

create temporary table t1(n int not null primary key);

create table t2(n int);

insert into t2 values(3);

select * from t1;

n

3

flush tables with read lock;

drop table t2;

ERROR HY000: Can't execute the query because you have a conflicting read lock

drop table t2;

unlock tables;

create database mysqltest;

create table mysqltest.t1(n int);

insert into mysqltest.t1 values (23);

flush tables with read lock;

drop database mysqltest;

select * from mysqltest.t1;

n

23

unlock tables;

create table t1 (c1 int);

create table t2 (c1 int);

flush tables with read lock;

insert into t2 values(1);

unlock tables;

ERROR HY000: No lock is held by this connection.

drop table t1, t2;

select benchmark(200, (select sin(1))) > 1000;

End of 5.0 tests