← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/regression/r/680028.result

  • Committer: patrick crews
  • Date: 2010-09-29 15:15:19 UTC
  • mfrom: (1099.4.188 drizzle)
  • Revision ID: gleebix@gmail.com-20100929151519-6mrmzd1ciw2p9nws
Tags: 2010.09.1802
Update translations

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/regression/r/680028.result
1
 
CREATE TABLE CONNECTION_ID (id int);
2
 
CREATE TABLE t1_680028 (a serial);
3
 
insert into CONNECTION_ID VALUES (CONNECTION_ID());
4
 
EXECUTE "SELECT @id:=id FROM CONNECTION_ID LIMIT 1" WITH NO RETURN;
5
 
FLUSH TABLES WITH READ LOCK;
6
 
select * from t1_680028 for update;
7
 
KILL @id;
8
 
SELECT GLOBAL_READ_LOCK();
9
 
GLOBAL_READ_LOCK()
10
 
HAS GLOBAL READ LOCK WITH BLOCKING COMMIT
11
 
UNLOCK tables;
12
 
SELECT GLOBAL_READ_LOCK();
13
 
GLOBAL_READ_LOCK()
14
 
NONE
15
 
DROP TABLE t1_680028;
16
 
DROP TABLE CONNECTION_ID;