mariadb/mysql-test/suite/rpl/t/rpl_csv.test
Kristian Nielsen 9e7762e718 MDEV-35233: RBR does not work with CSV tables
Handle null bits for record comparison in row events the same way as in
handler::calculate_checksum(), forcing bits that can be undefined to 1.
These bits are the trailing unused bits, as well as the first bit for
tables not using HA_OPTION_PACK_RECORD.

The csv storage engine leaves these bits at 0, while the row-based
replication has them set to 1, which otherwise cause can't find record error.

Reviewed-by: Monty <monty@mariadb.org>
Signed-off-by: Kristian Nielsen <knielsen@knielsen-hq.org>
2024-12-17 17:34:29 +01:00

16 lines
393 B
Text

--source include/have_csv.inc
--source include/have_binlog_format_row.inc
--source include/master-slave.inc
--echo *** MDEV-35233: RBR does not work with CSV tables
CREATE TABLE t (a INT NOT NULL) ENGINE=CSV;
INSERT INTO t VALUES (1),(2);
DELETE FROM t where a=1;
--sync_slave_with_master
SELECT * FROM t ORDER BY a;
# Cleanup
--connection master
DROP TABLE t;
--source include/rpl_end.inc