InnoDB事务锁之行锁-insert二级唯一索引插入duplicate案例

1、表结构

CREATE TABLE `t3` (
  `id` int(11) NOT NULL,
  `id2` int(11) DEFAULT NULL,
  `id3` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id2` (`id2`,`id3`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2、数据

mysql> select *from t3;
+----+------+------+
| id | id2  | id3  |
+----+------+------+
|  6 |    1 |    1 |
|  8 |    1 |    2 |
| 10 |    1 |    3 |
|  7 |    4 |    4 |
|  1 |    6 |    6 |
|  4 |    7 |    7 |
+----+------+------+
6 rows in set (0.00 sec)

3、插入数据

mysql> insert into t3 values(11,1,3);
ERROR 1062 (2