mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 13:22:17 +01:00
adb4117631
btr_cur_upd_rec_in_place(): Invoke page_zip_rec_set_deleted()
for ROW_FORMAT=COMPRESSED pages, so that the change will be
written to the redo log.
This part of crash recovery was broken in
commit 08ba388713 (MDEV-12353).
35 lines
892 B
Text
35 lines
892 B
Text
FLUSH TABLES;
|
|
#
|
|
# MDEV-21892 Assertion 'index != clust_index || row_get_rec_trx_id()'
|
|
#
|
|
connect con1,localhost,root;
|
|
CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
|
|
INSERT INTO t1 VALUES (1),(2);
|
|
BEGIN;
|
|
UPDATE t1 SET pk=1;
|
|
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
|
connection default;
|
|
#
|
|
# MDEV-12720 recovery fails with "Generic error"
|
|
# for ROW_FORMAT=compressed
|
|
#
|
|
CREATE TABLE a(i INT PRIMARY KEY AUTO_INCREMENT, s VARCHAR(255)) ENGINE=InnoDB
|
|
ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
|
|
BEGIN;
|
|
insert into a(i) select null;
|
|
insert into a select null, uuid() from a a, a b, a c;
|
|
insert into a select null, uuid() from a a, a b, a c;
|
|
insert into a select null, uuid() from a a, a b, a c;
|
|
SET GLOBAL innodb_flush_log_at_trx_commit=1;
|
|
COMMIT;
|
|
# restart
|
|
disconnect con1;
|
|
SELECT * FROM t1;
|
|
pk
|
|
1
|
|
2
|
|
DROP TABLE t1;
|
|
SELECT COUNT(*) from a;
|
|
COUNT(*)
|
|
1010
|
|
DROP TABLE a;
|