mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-01-16 03:52:35 +01:00
Code Issues Projects Releases Packages Wiki Activity Actions
mariadb/mysql-test/suite/binlog/t/binlog_row_img.test

39 lines
1,006 B
Text
Raw Permalink Normal View History

MDEV-32589 FULL_NODUP mode for binlog_row_image This patch provides a new mode FULL_NODUP to binlog_row_image system variable. With FULL_NODUP mode, all columns are included in before image, but only updated columns are included in after image for UPDATE. While all columns are included in the after image for INSERT. FULL_NODUP is for replacing FULL mode. It includes all data of the before and after image as FULL mode, but it uses less storage especially in the case that only a few columns are updated. Note: It will binlog full before and after image for all modes if the table has no primary key. FULL_NODUP follows the behavior.
2023-10-26 11:24:22 +02:00
################################################################################
# Support binlog_row_image FULL_NODUP mode
#
# In FULL_NODUP:
# - before image includes all columns.
# - after image includes only changed columns.
################################################################################
--source include/have_binlog_format_row.inc
MDEV-19123 Change default charset from latin1 to utf8mb4 Changing the default server character set from latin1 to utf8mb4.
2024-05-28 07:08:51 +02:00
--source include/test_db_charset_latin1.inc
MDEV-32589 FULL_NODUP mode for binlog_row_image This patch provides a new mode FULL_NODUP to binlog_row_image system variable. With FULL_NODUP mode, all columns are included in before image, but only updated columns are included in after image for UPDATE. While all columns are included in the after image for INSERT. FULL_NODUP is for replacing FULL mode. It includes all data of the before and after image as FULL mode, but it uses less storage especially in the case that only a few columns are updated. Note: It will binlog full before and after image for all modes if the table has no primary key. FULL_NODUP follows the behavior.
2023-10-26 11:24:22 +02:00
--echo #
--echo # FULL_NODUP mode works as expected
--echo #
SET binlog_row_image = "FULL_NODUP";
--source suite/binlog/include/row_img.test
--echo #
--echo # MINIMAL mode works as expected
--echo #
SET binlog_row_image = "MINIMAL";
--source suite/binlog/include/row_img.test
--echo #
--echo # NOBLOB mode works as expected
--echo #
SET binlog_row_image = "NOBLOB";
--source suite/binlog/include/row_img.test
--echo #
--echo # FULL mode works as expected
--echo #
SET binlog_row_image = "FULL";
--source suite/binlog/include/row_img.test
RESET MASTER;
MDEV-19123 Change default charset from latin1 to utf8mb4 Changing the default server character set from latin1 to utf8mb4.
2024-05-28 07:08:51 +02:00
--source include/test_db_charset_restore.inc
Reference in a new issue Copy permalink