"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/r/680028.result" (6 May 2012, 469 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    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;