Debian Codegraph @

mysql-test/suite/mariabackup/mdev-14447.result

raw
1 call mtr.add_suppression("InnoDB: New log files created");
2 SET GLOBAL innodb_file_per_table=0;
3 Warnings:
4 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
5 CREATE TABLE t(a varchar(40) PRIMARY KEY, b varchar(40), c varchar(40), d varchar(40), index(b,c,d)) ENGINE INNODB;
6 # Create full backup , modify table, then create incremental/differential backup
7 SET debug_dbug='+d,skip_page_checksum',foreign_key_checks=0,unique_checks=0;
8 BEGIN;
9 INSERT INTO t select uuid(), uuid(), uuid(), uuid() from seq_1_to_100000;
10 COMMIT;
11 SELECT count(*) FROM t;
12 count(*)
13 100000
14 # Prepare full backup, apply incremental one
15 # Restore and check results
16 # shutdown server
17 # remove datadir
18 # xtrabackup move back
19 # restart server
20 # restart
21 SELECT count(*) FROM t;
22 count(*)
23 100000
24 DROP TABLE t;