Debian Codegraph @

mysql-test/suite/innodb/t/zlob_rollback_update.test

raw
1 --source include/have_innodb_max_16k.inc
2 --source include/have_debug.inc
3 --source include/count_sessions.inc
4
5 set global innodb_compression_level = 0;
6
7 CREATE TABLE `t1` (
8 `a` int NOT NULL,
9 `b` longblob,
10 `c` longblob,
11 PRIMARY KEY (`a`)
12 ) ENGINE=InnoDB row_format=compressed;
13
14 # Prepare Data.
15
16 --disable_query_log
17 let $i= 0;
18 while ($i < 125)
19 {
20 if ($i == 23)
21 {
22 eval INSERT INTO `t1` VALUES($i, repeat("a",32768),repeat("b",32768));
23 }
24
25 if ($i != 23)
26 {
27 eval INSERT INTO `t1` VALUES($i, repeat("a",49152),repeat("b",49152));
28 }
29 inc $i;
30 }
31 --enable_query_log
32
33 connect(conn1,localhost,root,,);
34 connection default;
35 # disable purge thread to construct `update on delete mark record`
36 SET global innodb_purge_stop_now=ON;
37 DELETE FROM t1 WHERE a = 24;
38
39 connection conn1;
40 BEGIN;
41 INSERT INTO `t1` VALUES(24, repeat("c",89152),repeat("d",89152));
42
43 # enable purge thread to update purge's view.
44 SET global innodb_purge_run_now=ON;
45 --source include/wait_innodb_all_purged.inc
46
47 # rollback for undo `TRX_UNDO_UPD_DEL_REC`
48 ROLLBACK;
49
50 connection default;
51 disconnect conn1;
52 DROP TABLE t1;
53 --source include/count_sessions.inc
54
55 set global innodb_compression_level = default;