← Back to branch summary

~jobinau/drizzle/bug_654164

« back to all changes in this revision

Viewing changes to tests/suite/regression/t/680028.test

  • Committer: Brian Aker
  • Date: 2010-11-27 18:27:58 UTC
  • mfrom: (1948.2.15 catalogs)
  • Revision ID: brian@tangent.org-20101127182758-dmlrboyhsazqa1tm
Merge in additiona fixes, includes a number of bug fixes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/regression/t/680028.test
 
1
# Kill a connection while flush table with read lock is occuring.
 
2
connect (con1, localhost, root,,);
 
3
connect (con2, localhost, root,,);
 
4
 
 
5
CREATE TABLE CONNECTION_ID (id int);
 
6
CREATE TABLE t1_680028 (a serial);
 
7
 
 
8
# Jump to connection one and save our ID.
 
9
connection con1;
 
10
insert into CONNECTION_ID VALUES (CONNECTION_ID());
 
11
 
 
12
connection con2;
 
13
EXECUTE "SELECT @id:=id FROM CONNECTION_ID LIMIT 1" WITH NO RETURN;
 
14
 
 
15
connection default;
 
16
FLUSH TABLES WITH READ LOCK;
 
17
 
 
18
connection con1;
 
19
SEND select * from t1_680028 for update;
 
20
 
 
21
connection con2;
 
22
KILL @id;
 
23
 
 
24
connection default;
 
25
SELECT GLOBAL_READ_LOCK();
 
26
UNLOCK tables;
 
27
SELECT GLOBAL_READ_LOCK();
 
28
DROP TABLE t1_680028;
 
29
DROP TABLE CONNECTION_ID;