2
CREATE TABLE `t``\""e` (a INT, PRIMARY KEY (a))
5
SUBPARTITION BY HASH (a)
6
(PARTITION `p0``\""e` VALUES LESS THAN (100)
7
(SUBPARTITION `sp0``\""e`,
8
SUBPARTITION `sp1``\""e`),
9
PARTITION `p1``\""e` VALUES LESS THAN (MAXVALUE)
10
(SUBPARTITION `sp2``\""e`,
11
SUBPARTITION `sp3``\""e`));
12
INSERT INTO `t``\""e` VALUES (0), (2), (6), (10), (14), (18), (22);
18
UPDATE `t``\""e` SET a = 16 WHERE a = 0;
20
UPDATE `t``\""e` SET a = 8 WHERE a = 22;
21
UPDATE `t``\""e` SET a = 12 WHERE a = 0;
23
UPDATE `t``\""e` SET a = 4 WHERE a = 22;
24
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
25
# First table reported in 'SHOW ENGINE InnoDB STATUS'
26
SHOW ENGINE InnoDB STATUS;
28
InnoDB index `PRIMARY` of table `test`.`t``\""e` /* Partition `p0``\""e`, Subpartition `sp0``\""e` */
29
set @old_sql_mode = @@sql_mode;
30
set sql_mode = 'ANSI_QUOTES';
31
SHOW ENGINE InnoDB STATUS;
33
InnoDB index `PRIMARY` of table `test`.`t``\""e` /* Partition `p0``\""e`, Subpartition `sp0``\""e` */
34
set @@sql_mode = @old_sql_mode;