"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/t/673833.test" (6 May 2012, 508 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 t1 (a int, b int, PRIMARY KEY  (a,b)) ENGINE=InnoDB;
    2 INSERT INTO t1 (a,b) VALUES (1070109,99);
    3 CREATE TABLE t2 (b int, a int, PRIMARY KEY (b)) ENGINE=InnoDB;
    4 INSERT INTO t2 (b,a) VALUES (7,1070109);
    5 SELECT * FROM t1;
    6 
    7 BEGIN;
    8 SELECT b FROM t2 WHERE b=7 FOR UPDATE;
    9 
   10 CONNECT (addconroot, localhost, root,,);
   11 CONNECTION addconroot;
   12 
   13 BEGIN;
   14 --error ER_LOCK_WAIT_TIMEOUT
   15 DELETE FROM t1 WHERE a=(SELECT a FROM t2 WHERE b=7);
   16 
   17 CONNECTION default;
   18 DISCONNECT addconroot;
   19 
   20 ROLLBACK;
   21 
   22 DROP TABLE t2, t1;
   23