|
--source include/have_innodb.inc
|
|
CREATE TEMPORARY TABLE t1 (i INT, KEY (i)) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (NULL),(NULL);
|
UPDATE t1 SET i = 0;
|
START TRANSACTION;
|
UPDATE t1 SET i = 4;
|
UPDATE t1 SET i = 0;
|
ROLLBACK;
|
|
10.2 e44ca6cc9c
|
2018-05-07 18:09:02 139988084655872 [Warning] InnoDB: Record in index `i` of table `mysqld.1`.`#sql3893_9_0` was not found on rollback, trying to insert: TUPLE (info_bits=0, 2 fields): {[4] (0x00000000),[6] (0x000000000201)} at: COMPACT RECORD(info_bits=32, 2 fields): {NULL,[6] (0x000000000201)}
|
2018-05-07 18:09:02 139988084655872 [Warning] InnoDB: Record in index `i` of table `mysqld.1`.`#sql3893_9_0` was not found on rollback, trying to insert: TUPLE (info_bits=0, 2 fields): {[4] (0x00000000),[6] (0x000000000200)} at: COMPACT RECORD(info_bits=32, 2 fields): {NULL,[6] (0x000000000201)}
|
|