2
# Bug #51920: InnoDB connections in lock wait ignore KILL until timeout
4
-- source include/not_embedded.inc
5
-- source include/have_innodb_plugin.inc
7
CREATE TABLE bug51920 (i INT) ENGINE=InnoDB;
8
INSERT INTO bug51920 VALUES (1);
11
SELECT * FROM bug51920 FOR UPDATE;
13
connect (con1,localhost,root,,);
17
UPDATE bug51920 SET i=2;
21
SELECT COUNT(*)=1 FROM information_schema.processlist
22
WHERE INFO="UPDATE bug51920 SET i=2";
23
-- source include/wait_condition.inc
25
SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST
26
WHERE INFO="UPDATE bug51920 SET i=2"
31
SELECT COUNT(*)=0 FROM information_schema.processlist WHERE ID=@thread_id;
32
-- source include/wait_condition.inc
35
# Bug#19723: kill of active connection yields different error code
36
# depending on platform.
39
-- error 1317, 2006, 2013