mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01:00
d82386b6b9
btr_cur_upd_rec_in_place(): Prefer WRITE to MEMSET for a single-byte operation. log_phys_t::apply(): Relax the assertion to allow a single-byte MEMSET, even though it is 1 byte longer than a WRITE record.
14 lines
286 B
Text
14 lines
286 B
Text
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;
|