diff options
Diffstat (limited to 'mysql-test/suite/pbxt/r/flush.result')
-rw-r--r-- | mysql-test/suite/pbxt/r/flush.result | 61 |
1 files changed, 0 insertions, 61 deletions
diff --git a/mysql-test/suite/pbxt/r/flush.result b/mysql-test/suite/pbxt/r/flush.result deleted file mode 100644 index 49da8db5dae..00000000000 --- a/mysql-test/suite/pbxt/r/flush.result +++ /dev/null @@ -1,61 +0,0 @@ -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 (n int); -flush tables with read lock; -insert into t1 values (345); -select * from t1; -n -345 -drop table t1; -create table t1 (c1 int); -lock table t1 write; -flush tables with read lock; -ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction -lock table t1 read; -flush tables with read lock; -ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction -unlock tables; -flush tables with read lock; -lock table t1 write; -ERROR HY000: Can't execute the query because you have a conflicting read lock -lock table t1 read; -lock table t1 write; -ERROR HY000: Can't execute the query because you have a conflicting read lock -unlock tables; -create table t2 (c1 int); -create table t3 (c1 int); -lock table t1 read, t2 read, t3 write; -flush tables with read lock; -ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction -lock table t1 read, t2 read, t3 read; -flush tables with read lock; -ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction -unlock tables; -drop table t1, t2, t3; -create table t1 (c1 int); -create table t2 (c1 int); -lock table t1 write; -flush tables with read lock; -insert into t2 values(1); -unlock tables; -drop table t1, t2; |