← 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: Monty Taylor
  • Date: 2008-09-16 00:00:48 UTC
  • mto: This revision was merged to the branch mainline in revision 391.
  • Revision ID: monty@inaugust.com-20080916000048-3rvrv3gv9l0ad3gs
Fixed copyright headers in drizzled/

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;