Debian Codegraph @

mysql-test/suite/mariabackup/row_format_redundant.test

raw
1 --source include/have_innodb.inc
2
3 --let $targetdir=$MYSQLTEST_VARDIR/tmp/backup
4
5 CREATE TABLE t1 (pk INT PRIMARY KEY, a YEAR UNSIGNED) ENGINE=InnoDB
6 ROW_FORMAT=REDUNDANT;
7 INSERT INTO t1 VALUES (1,2021),(2,21),(3,0);
8 UPDATE t1 SET a = NULL;
9
10 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir;
11 exec $XTRABACKUP --prepare --verbose --target-dir=$targetdir;
12 --source include/restart_and_restore.inc
13
14 rmdir $targetdir;
15
16 SELECT * FROM t1;
17 DROP TABLE t1;