--source include/have_innodb_max_16k.inc --source include/have_debug.inc --source include/count_sessions.inc set global innodb_compression_level = 0; CREATE TABLE `t1` ( `a` int NOT NULL, `b` longblob, `c` longblob, PRIMARY KEY (`a`) ) ENGINE=InnoDB row_format=compressed; # Prepare Data. --disable_query_log let $i= 0; while ($i < 125) { if ($i == 23) { eval INSERT INTO `t1` VALUES($i, repeat("a",32768),repeat("b",32768)); } if ($i != 23) { eval INSERT INTO `t1` VALUES($i, repeat("a",49152),repeat("b",49152)); } inc $i; } --enable_query_log connect(conn1,localhost,root,,); connection default; # disable purge thread to construct `update on delete mark record` SET global innodb_purge_stop_now=ON; DELETE FROM t1 WHERE a = 24; connection conn1; BEGIN; INSERT INTO `t1` VALUES(24, repeat("c",89152),repeat("d",89152)); # enable purge thread to update purge's view. SET global innodb_purge_run_now=ON; --source include/wait_innodb_all_purged.inc # rollback for undo `TRX_UNDO_UPD_DEL_REC` ROLLBACK; connection default; disconnect conn1; DROP TABLE t1; --source include/count_sessions.inc set global innodb_compression_level = default;