summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/mariabackup/row_format_redundant.result
blob: 7ff5e8654c6a81416452447ecfd0f2564e02c843 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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;
# shutdown server
# remove datadir
# xtrabackup move back
# restart
SELECT * FROM t1;
pk	a
1	NULL
2	NULL
3	NULL
DROP TABLE t1;