Debian Codegraph @

mysql-test/suite/storage_engine/insert_delayed.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,b) VALUES (1,'f'),(2,'b');
4 LOCK TABLE t1 READ;
5 connect con0,localhost,root,,;
6 SET lock_wait_timeout = 1;
7 INSERT DELAYED INTO t1 (a,b) VALUES (3,'c');
8 INSERT DELAYED INTO t1 SET a=4, b='d';
9 INSERT DELAYED INTO t1 (a,b) SELECT 5, 'e';
10 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
11 disconnect con0;
12 connection default;
13 SELECT a,b FROM t1;
14 a b
15 1 f
16 2 b
17 UNLOCK TABLES;
18 FLUSH TABLES;
19 SELECT a,b FROM t1;
20 a b
21 1 f
22 2 b
23 3 c
24 4 d
25 DROP TABLE t1;