"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/r/673833.result" (6 May 2012, 452 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 a	b
    7 1070109	99
    8 BEGIN;
    9 SELECT b FROM t2 WHERE b=7 FOR UPDATE;
   10 b
   11 7
   12 BEGIN;
   13 DELETE FROM t1 WHERE a=(SELECT a FROM t2 WHERE b=7);
   14 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
   15 ROLLBACK;
   16 DROP TABLE t2, t1;