mirror of
https://github.com/MariaDB/server.git
synced 2025-02-14 17:35:35 +01:00
a119c5f998
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.
35 lines
916 B
Text
35 lines
916 B
Text
################################################################################
|
|
# 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
|
|
--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;
|
|
|