SELECT lock_table, COUNT(*) FROM INFORMATION_SCHEMA.INNODB_LOCKS GROUP BY lock_table;

CREATE VIEW vv as SELECT lock_table, COUNT(*) FROM INFORMATION_SCHEMA.INNODB_LOCKS GROUP BY lock_table;

SELECT * FROM vv;

DROP VIEW vv;

--source include/have_partition.inc

--source include/have_innodb.inc

SET NAMES utf8;

CREATE TABLE `t``\""e` (a INT, PRIMARY KEY (a))

ENGINE=InnoDB

PARTITION BY RANGE (a)

SUBPARTITION BY HASH (a)

(PARTITION `p0``\""e` VALUES LESS THAN (100)

 (SUBPARTITION `sp0``\""e`,

  SUBPARTITION `sp1``\""e`),

 PARTITION `p1``\""e` VALUES LESS THAN (MAXVALUE)

 (SUBPARTITION `sp2``\""e`,

  SUBPARTITION `sp3``\""e`));

INSERT INTO `t``\""e` VALUES (0), (2), (6), (10), (14), (18), (22);

START TRANSACTION;

connect(con1,localhost,root,,);

SET NAMES utf8;

START TRANSACTION;

connection default;

UPDATE `t``\""e` SET a = 16 WHERE a = 0;

connection con1;

UPDATE `t``\""e` SET a = 8 WHERE a = 22;

let $id_1= `SELECT CONNECTION_ID()`;

SEND;

UPDATE `t``\""e` SET a = 12 WHERE a = 0;

connection default;

let $wait_condition= SELECT COUNT(*)=2 FROM INFORMATION_SCHEMA.INNODB_LOCKS;

--source include/wait_condition.inc

--sorted_result

CREATE VIEW vv as SELECT lock_table, COUNT(*) FROM INFORMATION_SCHEMA.INNODB_LOCKS

GROUP BY lock_table;

SELECT * FROM vv;

DROP VIEW vv;

--error ER_LOCK_DEADLOCK

UPDATE `t``\""e` SET a = 4 WHERE a = 22;

connection con1;

REAP;

ROLLBACK;

disconnect con1;

connection default;

DROP TABLE `t``\""e`;

At line 36: query 'UPDATE `t``\""e` SET a = 4 WHERE a = 22' failed with wrong errno 1205: 'Lock wait timeout exceeded; try restarting transaction', instead of 1213...