The MTR test case provided in the description does not fail for me on the current revno 3272, but this one does:
--source include/have_innodb.inc
SET GLOBAL innodb_lock_wait_timeout=3;
CREATE TABLE t1 ( col_int_key INT, KEY (col_int_key) ) ENGINE=InnoDB PARTITION BY KEY(col_int_key) PARTITIONS 2; INSERT INTO t1 VALUES (6);
--connect (con1,127.0.0.1,root,,test) SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE; SET AUTOCOMMIT=OFF; SELECT col_int_key FROM t1;
--connection default --send DELETE IGNORE FROM t1;
--connection con1 DELETE FROM t1 WHERE col_int_key IN (1, 40000000);
--connection default --reap
Tried Linux 32 bit, Linux 64 bit, Windows 32 bit, failed everywhere, on every attempt.
The MTR test case provided in the description does not fail for me on the current revno 3272, but this one does:
--source include/ have_innodb. inc
SET GLOBAL innodb_ lock_wait_ timeout= 3;
CREATE TABLE t1 (
col_int_key INT,
KEY (col_int_key)
) ENGINE=InnoDB
PARTITION BY KEY(col_int_key) PARTITIONS 2;
INSERT INTO t1 VALUES (6);
--connect (con1,127. 0.0.1,root, ,test)
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET AUTOCOMMIT=OFF;
SELECT col_int_key FROM t1;
--connection default
--send
DELETE IGNORE FROM t1;
--connection con1
DELETE FROM t1 WHERE col_int_key IN (1, 40000000);
--connection default
--reap
Tried Linux 32 bit, Linux 64 bit, Windows 32 bit, failed everywhere, on every attempt.