TRUNCATE on a partitioned InnoDB table fails with ERROR 1205 when LOCK TABLES also holds the table through an alias, a view or a trigger

--source include/have_partition.inc

--source include/have_innodb.inc

CREATE TABLE t1 (a INT) ENGINE=InnoDB PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (10), PARTITION p1 VALUES LESS THAN MAXVALUE);

INSERT INTO t1 VALUES (1),(20);

LOCK TABLES t1 WRITE, t1 AS a1 READ;

--error 0,ER_LOCK_WAIT_TIMEOUT

TRUNCATE TABLE t1;

if ($mysql_errno)

{

  --die The partitioned InnoDB table cannot be truncated while LOCK TABLES also holds an alias of it: TRUNCATE TABLE fails with a lock wait timeout

}

--error 0,ER_LOCK_WAIT_TIMEOUT

ALTER TABLE t1 TRUNCATE PARTITION p0;

if ($mysql_errno)

{

  --die The partition cannot be truncated while LOCK TABLES also holds an alias of the table: TRUNCATE PARTITION fails with a lock wait timeout

}

UNLOCK TABLES;

DROP TABLE t1;

mysqltest: At line 11: The partitioned InnoDB table cannot be truncated while LOCK TABLES also holds an alias of it: TRUNCATE TABLE fails with a lock wait timeout

CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB PARTITION BY HASH (a) PARTITIONS 2;

CREATE TABLE t2 (a INT) ENGINE=InnoDB;

CREATE TRIGGER tr AFTER INSERT ON t2 FOR EACH ROW INSERT INTO t1 VALUES (NEW.a, 0);

INSERT INTO t1 VALUES (1, 1), (2, 2);

LOCK TABLES t1 WRITE, t2 WRITE;

TRUNCATE TABLE t1;

UNLOCK TABLES;

DROP TABLE t1, t2;