mysql嵌套事务的坑

表结构：
CREATE TABLE `t1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c1` int(11) NOT NULL,
  `c2` int(11) NOT NULL,
  `c3` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `c1` (`c1`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;

数据：
INSERT INTO `t1` VALUES ('1', '1', '1', '1');
INSERT INTO `t1` VALUES ('2', '2', '2', '2');
INSERT INTO `t1` VALUES ('3', '3', '3', '3');
INSERT INTO `t1` VALUES ('4', '4', '4', '4');
INSERT INTO `t1` VALUES ('5', '5', '5', '5');
INSERT INTO `t1` VALUES ('6', '6', '6', '6');
INSERT INTO `t1` VALUES