diff options
| author | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2018-05-08 19:27:08 +0530 |
|---|---|---|
| committer | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2018-05-08 19:27:08 +0530 |
| commit | bd1d152d05ba75bd1bdd2d9bc0358d8508df307a (patch) | |
| tree | 002d2b787423c8574b55e4e74fa9056c7d69836e /mysql-test/suite/innodb/r/temporary_table.result | |
| parent | 9bcd0f5fea8ca26742b10d37b95a966c69909ff1 (diff) | |
| download | mariadb-git-bd1d152d05ba75bd1bdd2d9bc0358d8508df307a.tar.gz | |
MDEV-16106 Record in index was not found on rollback, trying to insert: TUPLE
During rollback of temporary table logs, secondary index should delete mark
the index entry instead of removing it completely.
Diffstat (limited to 'mysql-test/suite/innodb/r/temporary_table.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/temporary_table.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/temporary_table.result b/mysql-test/suite/innodb/r/temporary_table.result index 310741b5798..64eb3270934 100644 --- a/mysql-test/suite/innodb/r/temporary_table.result +++ b/mysql-test/suite/innodb/r/temporary_table.result @@ -638,3 +638,15 @@ t1 CREATE TEMPORARY TABLE `t1` ( `j` int(11) DEFAULT NULL, PRIMARY KEY (`i`) KEY_BLOCK_SIZE=8 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC +DROP TABLE t1; +CREATE TEMPORARY TABLE t1(f1 INT, KEY(f1)) ENGINE=InnoDB; +INSERT INTO t1 VALUES(NULL); +UPDATE t1 SET f1 = 0; +START TRANSACTION; +UPDATE t1 SET f1 = 4; +UPDATE t1 SET f1 = 0; +ROLLBACK; +SELECT * FROM t1; +f1 +0 +DROP TABLE t1; |