mirror of
https://github.com/MariaDB/server.git
synced 2025-09-16 16:42:28 +03: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
999 B
Plaintext
35 lines
999 B
Plaintext
#Want to skip this test from daily Valgrind execution
|
|
--source include/no_valgrind_without_big.inc
|
|
#
|
|
# This file contains tests for FULL_NODUP row image mode
|
|
#
|
|
|
|
--let $rpl_topology= 1->2->3
|
|
--source include/rpl_init.inc
|
|
-- source include/have_binlog_format_row.inc
|
|
|
|
-- connection server_1
|
|
-- source include/have_innodb.inc
|
|
-- connection server_2
|
|
-- source include/have_innodb.inc
|
|
-- connection server_3
|
|
-- source include/have_innodb.inc
|
|
-- connection server_1
|
|
|
|
# Tests for different storage engines on each server,
|
|
# but same index structure on tables. The tests are conducted
|
|
# using FULL_NODUP binlog-row-image on all servers.
|
|
#
|
|
|
|
-- let $row_img_set=server_1:FULL_NODUP:N,server_2:FULL_NODUP:Y,server_3:FULL_NODUP:Y
|
|
-- source include/rpl_row_img_set.inc
|
|
|
|
-- let $row_img_test_script= include/rpl_row_img.test
|
|
-- source include/rpl_row_img_general_loop.inc
|
|
|
|
-- let $row_img_set=server_1:FULL:N,server_2:FULL:Y,server_3:FULL:Y
|
|
-- source include/rpl_row_img_set.inc
|
|
|
|
|
|
--source include/rpl_end.inc
|