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;
|
