Debian Codegraph @

mysql-test/suite/gcol/r/gcol_purge.result

raw
1 SET @save_dbug=@@GLOBAL.debug_dbug;
2 CREATE TABLE t1(f1 INT NOT NULL, f2 int not null,
3 f3 int generated always as (f2 * 2) VIRTUAL,
4 primary key(f1), INDEX (f3))ENGINE=InnoDB STATS_PERSISTENT=0;
5 connect con1,localhost,root,,,;
6 InnoDB 0 transactions not purged
7 START TRANSACTION WITH CONSISTENT SNAPSHOT;
8 connection default;
9 INSERT INTO t1(f1, f2) VALUES(1,2);
10 DELETE from t1 where f1 = 1;
11 connect con2,localhost,root,,,;
12 begin;
13 INSERT INTO t1 (f1, f2) VALUES(1,2);
14 set global debug_dbug="+d,ib_purge_virtual_index_callback";
15 connection con1;
16 COMMIT;
17 SET GLOBAL innodb_max_purge_lag_wait=1;
18 connection con2;
19 commit;
20 disconnect con1;
21 disconnect con2;
22 connection default;
23 SET GLOBAL debug_dbug=@save_dbug;
24 DROP TABLE t1;