Debian Codegraph @

mysql-test/suite/mariabackup/row_format_redundant.result

raw
1 CREATE TABLE t1 (pk INT PRIMARY KEY, a YEAR UNSIGNED) ENGINE=InnoDB
2 ROW_FORMAT=REDUNDANT;
3 INSERT INTO t1 VALUES (1,2021),(2,21),(3,0);
4 UPDATE t1 SET a = NULL;
5 # shutdown server
6 # remove datadir
7 # xtrabackup move back
8 # restart
9 SELECT * FROM t1;
10 pk a
11 1 NULL
12 2 NULL
13 3 NULL
14 DROP TABLE t1;