mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 09:55:33 +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.
67 lines
1.8 KiB
Text
67 lines
1.8 KiB
Text
#Want to skip this test from daily Valgrind execution
|
|
--source include/no_valgrind_without_big.inc
|
|
|
|
#
|
|
# This file contains tests for WL#5096.
|
|
#
|
|
|
|
--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
|
|
|
|
#
|
|
# WL#5096 Tests.
|
|
#
|
|
|
|
#
|
|
# Tests combinations of binlog-row-image against mixes of MyISAM and InnoDB
|
|
# storage engines on all three servers.
|
|
#
|
|
# All the combinarions need not to be separated into their own files as
|
|
# the tests for indexes and engines mixes are, because noblobs test script
|
|
# does not take too long time, thence we do not risk triggering PB2 timeout
|
|
# on valgrind runs.
|
|
#
|
|
|
|
## NOBLOB
|
|
|
|
-- let $row_img_set=server_1:NOBLOB:N,server_2:NOBLOB:Y,server_3:NOBLOB:Y
|
|
-- source include/rpl_row_img_set.inc
|
|
|
|
-- let $row_img_test_script= include/rpl_row_img_blobs.test
|
|
-- source include/rpl_row_img_general_loop.inc
|
|
|
|
## MINIMAL
|
|
|
|
-- let $row_img_set=server_1:MINIMAL:N,server_2:MINIMAL:Y,server_3:MINIMAL:Y
|
|
-- source include/rpl_row_img_set.inc
|
|
|
|
-- let $row_img_test_script= include/rpl_row_img_blobs.test
|
|
-- source include/rpl_row_img_general_loop.inc
|
|
|
|
## FULL_NODUP
|
|
|
|
-- 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_blobs.test
|
|
-- source include/rpl_row_img_general_loop.inc
|
|
|
|
## FULL
|
|
|
|
-- let $row_img_set=server_1:FULL:N,server_2:FULL:Y,server_3:FULL:Y
|
|
-- source include/rpl_row_img_set.inc
|
|
|
|
-- let $row_img_test_script= include/rpl_row_img_blobs.test
|
|
-- source include/rpl_row_img_general_loop.inc
|
|
|
|
|
|
--source include/rpl_end.inc
|