← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

[patch 112/129] Merge patch for revision 1925 from InnoDB SVN:
revno: 1925
revision-id: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:6169
parent: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:6163
committer: calvin
timestamp: Thu 2009-11-12 12:40:43 +0000
message:
  branches/zip: add test case for bug#46676
  
  This crash is reproducible with InnoDB plugin 1.0.4 + MySQL 5.1.37.
  But no longer reproducible after MySQL 5.1.38 (with plugin 1.0.5).
  Add test case to catch future regression.
added:
  mysql-test/innodb_bug46676.result 6169@16c675df-0fcb-4bc9-8058-dcc011a37293:branches%2Fzip%2Fmysql-test%2Finnodb_bug46676.result
  mysql-test/innodb_bug46676.test 6169@16c675df-0fcb-4bc9-8058-dcc011a37293:branches%2Fzip%2Fmysql-test%2Finnodb_bug46676.test
diff:
=== added file 'mysql-test/innodb_bug46676.result'

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;