Debian Codegraph @

mysql-test/suite/innodb/t/innodb_bug51920.test

raw
1 #
2 # Bug #51920: InnoDB connections in lock wait ignore KILL until timeout
3 #
4
5 CREATE TABLE bug51920 (i INT) ENGINE=InnoDB;
6 INSERT INTO bug51920 VALUES (1);
7
8 BEGIN;
9 SELECT * FROM bug51920 FOR UPDATE;
10
11 connect (con1,localhost,root,,);
12
13 connection con1;
14 --send
15 UPDATE bug51920 SET i=2;
16
17 connection default;
18 let $wait_condition =
19 SELECT COUNT(*)=1 FROM information_schema.processlist
20 WHERE INFO="UPDATE bug51920 SET i=2";
21 -- source include/wait_condition.inc
22
23 SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST
24 WHERE INFO="UPDATE bug51920 SET i=2"
25 INTO @thread_id;
26
27 KILL @thread_id;
28 let $wait_condition =
29 SELECT COUNT(*)=0 FROM information_schema.processlist WHERE ID=@thread_id;
30 -- source include/wait_condition.inc
31
32 #
33 # Bug#19723: kill of active connection yields different error code
34 # depending on platform.
35 #
36 connection con1;
37 -- error 1317, 2006, 2013
38 reap;
39 connection default;
40 DROP TABLE bug51920;
41 -- disconnect con1