Debian Codegraph @

mysql-test/suite/gcol/t/gcol_purge.test

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