summaryrefslogtreecommitdiff
path: root/mysql-test/r/flush.result
diff options
context:
space:
mode:
authorunknown <davi@endora.local>2007-11-22 10:32:34 -0200
committerunknown <davi@endora.local>2007-11-22 10:32:34 -0200
commited4edda18f3535e798029a52559275796ca01daf (patch)
tree155156a4b365d464c3e405c228eb238f5cf7bc08 /mysql-test/r/flush.result
parent01900080958d8209617d76d3c5f770008c7c94ff (diff)
parent719e64e4a55a6893b14464cb28e8beaaa33f6a7c (diff)
downloadmariadb-git-ed4edda18f3535e798029a52559275796ca01daf.tar.gz
Merge endora.local:/Users/davi/mysql/bugs/32528-5.0
into endora.local:/Users/davi/mysql/mysql-5.1-runtime sql/sql_parse.cc: Auto merged mysql-test/r/flush.result: SCCS merged mysql-test/t/flush.test: SCCS merged
Diffstat (limited to 'mysql-test/r/flush.result')
-rw-r--r--mysql-test/r/flush.result17
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/flush.result b/mysql-test/r/flush.result
index dcbffd6f7c8..f1b6c471943 100644
--- a/mysql-test/r/flush.result
+++ b/mysql-test/r/flush.result
@@ -55,6 +55,23 @@ flush tables with read lock;
insert into t2 values(1);
unlock tables;
drop table t1, t2;
+drop table if exists t1, t2;
+set session low_priority_updates=1;
+create table t1 (a int);
+create table t2 (b int);
+lock tables 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
+unlock tables;
+lock tables t1 read, t2 write;
+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;
+lock tables t1 read;
+flush tables with read lock;
+unlock tables;
+drop table t1, t2;
+set session low_priority_updates=default;
End of 5.0 tests
set @old_general_log= @@general_log;
set @old_read_only= @@read_only;