← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Lee Bieber
  • Date: 2010-11-07 19:34:48 UTC
  • mfrom: (1910.1.2 build)
  • Revision ID: kalebral@gmail.com-20101107193448-64kdu912qej354sh
Merge Stewart - including adapting and expanding the "differences from mysql" page from the wiki.
Merge Stewart - fix bug 668143: drizzleslap with --commit runs second iteration data load in a transaction

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;