问题描述
表dt包含了一个主键,一个复合唯一索引和一个普通索引,存在9条记录。表结构和记录如下:
CREATE TABLE `dt` (
`ID` int(10) NOT NULL,
`COUPON_ID` varchar(60) NOT NULL,
`OPERATION_TYPE` decimal(2,0) NOT NULL,
`REMAIN_AMOUNT` decimal(8,2) NOT NULL,
`OPERATION_AMOUNT` decimal(8,2) NOT NULL,
`OPERATION_DESC` varchar(200) DEFAULT NULL,
`OPERATION_IP` varchar(30) DEFAULT NULL,
`OPERATION_ID` varchar(60) DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `detail7_1` (`COUPON_ID`,`OPERATION_DESC`),
KEY `detail7_2` (`OPERATION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
insert into dt values(1,1,0,10000.00,10000.00,1,1,1);
insert into dt values(2,1,0,10000.00,10000.00,2,2,2);
insert into dt values(3,1,0,10000.00,10000.00,3,3,3);
insert into dt values(4,1,0,10000.00,10000.00,4,4,4);
insert into dt values(5,1,0,10000.00,10000.00,5,5,5);
insert into dt values(6,1,0,10000.00,10000.00,6,6,6);
insert into dt values(7,1,0,10000.00,10000.00,7,7,7);
insert into dt values(8,1,0,10000.00,10000.00,8,8,8);
insert into dt values(9,1,0,10000.00,10000.00,9,9,9);
分别在2个session起2个事务。事务隔离级别均为RC。
session1-ddb>show session variables like "%isolation%";
+-----------------------+----------------+
| Variable_name | Value |
+-----------------------&