← 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: Brian Aker
  • Date: 2010-11-27 13:38:27 UTC
  • mfrom: (1955.1.3 quick)
  • Revision ID: brian@tangent.org-20101127133827-fowoi26sizq1zneg
Rollup of staging, mostly UDL

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;