Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.6
Description
For MTR tests which have test specific .cnf files (e.g. <test_name>.cnf), if an option is provided multiple times with the intention of creating a list (e.g. for option replicate_do_table), then only the last value is copied into the final var/my.cnf file, and the prior options are disregarded.
For example, the configuration
[mysqld.2]
|
replicate_do_table=test.t1
|
replicate_do_table=test.t2
|
replicate_do_table=test.t3
|
Results in
connect extra2,127.0.0.1,root,,test,$SLAVE_MYPORT;
|
show variables like 'replicate_do_table';
|
Variable_name Value
|
replicate_do_table test.t3
|
And the file var/my.cnf shows only the last value provided:
[mysqld.2]
|
#!run-slave-sh=
|
#!use-slave-opt=
|
log-basename=slave
|
init-rpl-role=slave
|
log-slave-updates
|
master-retry-count=10
|
report-host=127.0.0.1
|
report-port=19001
|
report-user=root
|
skip-slave-start
|
slave-load-tmpdir=../../tmp
|
loose-innodb
|
replicate_do_table=test.t3
|
log_slave_updates
|
Note that a workaround would be to use a .opt file for the test, and that works, e.g.
replicate_do_table=test.t1 replicate_do_table=test.t2 replicate_do_table=test.t3
|
with output
connect extra2,127.0.0.1,root,,test,$SLAVE_MYPORT;
|
show variables like 'replicate_do_table';
|
Variable_name Value
|
replicate_do_table test.t3,test.t1,test.t2
|
include/master-slave.inc
|
Note I only tested this on 10.6.