Debian Codegraph @

mysql-test/suite/mariabackup/incremental_ddl_before_backup.result

raw
1 call mtr.add_suppression("InnoDB: New log files created");
2 CREATE TABLE t1(i INT) ENGINE INNODB;
3 CREATE TABLE t2(i INT PRIMARY KEY) ENGINE INNODB;
4 CREATE TABLE t3(i INT) ENGINE INNODB;
5 # Create full backup , modify table, then create incremental/differential backup
6 create table t4(f1 int not null, f2 int not null)engine=innodb;
7 insert into t4 values(1, 2), (2, 2), (3, 3), (5, 5), (6, 6), (4, 4), (9, 9);
8 insert into t4 select * from t4;
9 insert into t4 select * from t4;
10 insert into t4 select * from t4;
11 insert into t4 select * from t4;
12 insert into t4 select * from t4;
13 insert into t4 select * from t4;
14 insert into t4 select * from t4;
15 insert into t4 select * from t4;
16 insert into t4 select * from t4;
17 insert into t4 select * from t4;
18 rename table t4 to t7;
19 select count(*) from t7;
20 count(*)
21 7168
22 # XTRABACKUP INCREMENTAL
23 # XTRABACKUP PREPARE
24 # XTRABACKUP INCREMENTAL PREPARE
25 # shutdown server
26 # remove datadir
27 # xtrabackup move back
28 # restart
29 select count(*) from t7;
30 count(*)
31 7168
32 drop table t1, t2, t7, t3;