summaryrefslogtreecommitdiff
path: root/mysql-test/suite/mariabackup/row_format_redundant.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/mariabackup/row_format_redundant.test')
-rw-r--r--mysql-test/suite/mariabackup/row_format_redundant.test15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/suite/mariabackup/row_format_redundant.test b/mysql-test/suite/mariabackup/row_format_redundant.test
new file mode 100644
index 00000000000..a77f1b9e493
--- /dev/null
+++ b/mysql-test/suite/mariabackup/row_format_redundant.test
@@ -0,0 +1,15 @@
+--source include/have_innodb.inc
+
+--let $targetdir=$MYSQLTEST_VARDIR/tmp/backup
+
+CREATE TABLE t1 (pk INT PRIMARY KEY, a YEAR UNSIGNED) ENGINE=InnoDB
+ROW_FORMAT=REDUNDANT;
+INSERT INTO t1 VALUES (1,2021),(2,21),(3,0);
+UPDATE t1 SET a = NULL;
+
+exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir;
+exec $XTRABACKUP --prepare --verbose --target-dir=$targetdir;
+--source include/restart_and_restore.inc
+
+SELECT * FROM t1;
+DROP TABLE t1;