← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/flush_block_commit.test

  • Committer: Daniel Nichter
  • Date: 2011-10-23 16:01:37 UTC
  • mto: This revision was merged to the branch mainline in revision 2448.
  • Revision ID: daniel@percona.com-20111023160137-7ac3blgz8z4tf8za
Add Administration Getting Started and Logging.  Capitalize SQL clause keywords.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/flush_block_commit.test
25
25
select * from t1;
26
26
connection con1;
27
27
send commit; # blocked by con2
28
 
sleep 1;
 
28
sleep 0.1;
29
29
connection con2;
30
30
select * from t1; # verify con1 was blocked and data did not move
31
31
unlock tables;
40
40
connection con2;
41
41
begin;
42
42
send select * from t1 for update; # blocked by con1
43
 
sleep 1;
 
43
sleep 0.5;
44
44
connection con3;
45
45
send flush tables with read lock; # blocked by con2
46
46
connection con1;
71
71
begin;
72
72
select * from t1;
73
73
show create database test;
74
 
 
 
74
COMMIT;
75
75
drop table t1;
76
76
 
77
77
# End of 4.1 tests