← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/flush.result

  • Committer: Brian Aker
  • Date: 2009-06-05 23:10:06 UTC
  • mto: This revision was merged to the branch mainline in revision 1055.
  • Revision ID: brian@gaz-20090605231006-01nyw7pfpj2z2v8p
Remove guts in parser for LOCK TABLE.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/flush.result
21
21
23
22
22
unlock tables;
23
23
create table t1 (c1 int);
24
 
lock table t1 write;
25
 
flush tables with read lock;
26
 
ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
27
 
lock table t1 read;
28
 
flush tables with read lock;
29
 
lock table t1 write;
30
 
ERROR HY000: Can't execute the query because you have a conflicting read lock
31
 
lock table t1 read;
32
 
lock table t1 write;
33
 
ERROR HY000: Can't execute the query because you have a conflicting read lock
34
 
unlock tables;
35
 
create table t2 (c1 int);
36
 
create table t3 (c1 int);
37
 
lock table t1 read, t2 read, t3 write;
38
 
flush tables with read lock;
39
 
ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
40
 
lock table t1 read, t2 read, t3 read;
41
 
flush tables with read lock;
42
 
unlock tables;
43
 
drop table t1, t2, t3;
44
 
create table t1 (c1 int);
45
 
create table t2 (c1 int);
46
 
lock table t1 write;
 
24
create table t2 (c1 int);
47
25
flush tables with read lock;
48
26
insert into t2 values(1);
49
27
unlock tables;