Comment 2 for bug 922146

Revision history for this message
Elena Stepanova (elenst) wrote :

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.