← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-12-09 06:02:39 UTC
  • mto: This revision was merged to the branch mainline in revision 5.
  • Revision ID: james.westby@ubuntu.com-20101209060239-t0ujftvcvd558yno
Tags: upstream-2010.12.05
Import upstream version 2010.12.05

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;