-- 5.6.39 - partitions one affected

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.39/mysql-test: ./mtr rpl_bug73648 rpl_bug73648_nonpart
Logging: ./mtr  rpl_bug73648 rpl_bug73648_nonpart
2018-02-09 09:57:32 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2018-02-09 09:57:32 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.6.39/bin/mysqld (mysqld 5.6.39) starting as process 4210 ...
2018-02-09 09:57:32 4210 [Note] Plugin 'FEDERATED' is disabled.
2018-02-09 09:57:32 4210 [Note] Binlog end
2018-02-09 09:57:32 4210 [Note] Shutting down plugin 'MyISAM'
2018-02-09 09:57:32 4210 [Note] Shutting down plugin 'CSV'
MySQL Version 5.6.39
Checking supported features...
 - SSL connections supported
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.6.39/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
include/master-slave.inc
Warnings:
Note    ####    Sending passwords in plain text without SSL/TLS is extremely insecure.
Note    ####    Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
CREATE TABLE t (
id bigint(20) unsigned NOT NULL auto_increment,
d date NOT NULL,
ts datetime(6) NOT NULL,
PRIMARY KEY (id,d)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50500 PARTITION BY HASH(id) partitions 200*/;
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
replace into t(d,ts) select t1.d,t1.ts from t t1, t t2, t t3, t t4, t t5, t t6, t t7, t t8, t t9, t t10;
commit;
update t set ts = now();
commit;
drop table t;
stop slave;
main.rpl_bug73648                        [ pass ]  238810
include/master-slave.inc
Warnings:
Note    ####    Sending passwords in plain text without SSL/TLS is extremely insecure.
Note    ####    Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
CREATE TABLE t (
id bigint(20) unsigned NOT NULL auto_increment,
d date NOT NULL,
ts datetime(6) NOT NULL,
PRIMARY KEY (id,d)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
replace into t(d,ts) select t1.d,t1.ts from t t1, t t2, t t3, t t4, t t5, t t6, t t7, t t8, t t9, t t10;
commit;
update t set ts = now();
commit;
drop table t;
stop slave;
main.rpl_bug73648_nonpart                [ pass ]  38080
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 276.890 of 285 seconds executing testcases

Completed: All 2 tests were successful.


-- 5.7.21

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21: cat docs/INFO_SRC
commit: ddfbfcfdfcb4f77f72e459a293686a2be27af112
date: 2017-11-08 17:46:12 +0530
build-date: 2017-11-08 18:00:52 +0100
short: ddfbfcf
branch: mysql-5.7

MySQL source 5.7.21

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21/mysql-test: ./mtr rpl_bug73648 rpl_bug73648_nonpart
Logging: ./mtr  rpl_bug73648 rpl_bug73648_nonpart
MySQL Version 5.7.21
Checking supported features...
 - SSL connections supported
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 13010..13019
include/master-slave.inc
Warnings:
Note    ####    Sending passwords in plain text without SSL/TLS is extremely insecure.
Note    ####    Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
CREATE TABLE t (
id bigint(20) unsigned NOT NULL auto_increment,
d date NOT NULL,
ts datetime(6) NOT NULL,
PRIMARY KEY (id,d)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50500 PARTITION BY HASH(id) partitions 200*/;
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
replace into t(d,ts) select t1.d,t1.ts from t t1, t t2, t t3, t t4, t t5, t t6, t t7, t t8, t t9, t t10;
commit;
update t set ts = now();
commit;
drop table t;
stop slave;
main.rpl_bug73648                        [ pass ]  82662
include/master-slave.inc
Warnings:
Note    ####    Sending passwords in plain text without SSL/TLS is extremely insecure.
Note    ####    Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
CREATE TABLE t (
id bigint(20) unsigned NOT NULL auto_increment,
d date NOT NULL,
ts datetime(6) NOT NULL,
PRIMARY KEY (id,d)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
replace into t(d,ts) select t1.d,t1.ts from t t1, t t2, t t3, t t4, t t5, t t6, t t7, t t8, t t9, t t10;
commit;
update t set ts = now();
commit;
drop table t;
stop slave;
main.rpl_bug73648_nonpart                [ pass ]  48396
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 131.058 of 146 seconds executing testcases

Completed: All 2 tests were successful.

-- 8.0.4-rc

[umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-8.0.4-rc-linux-glibc2.12-x86_64/mysql-test: ./mtr --nocheck-testcases rpl_bug73648 rpl_bug73648_nonpart
Logging: ./mtr  --nocheck-testcases rpl_bug73648 rpl_bug73648_nonpart
2018-02-09T09:00:57.433922Z 0 [System] [MY-010116] /export/umesh/server/binaries/Trunk/mysql-8.0.4-rc-linux-glibc2.12-x86_64/bin/mysqld (mysqld 8.0.4-rc-log) starting as process 5263 ...
MySQL Version 8.0.4
Too long tmpdir path '/export/umesh/server/binaries/Trunk/mysql-8.0.4-rc-linux-glibc2.12-x86_64/mysql-test/var/tmp'  creating a shorter one...
 - using tmpdir: '/tmp/gcAy3iEd_G'

Checking supported features...
 - SSL connections supported
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/export/umesh/server/binaries/Trunk/mysql-8.0.4-rc-linux-glibc2.12-x86_64/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 13010..13019
include/master-slave.inc
Warnings:
Note    ####    Sending passwords in plain text without SSL/TLS is extremely insecure.
Note    ####    Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
CREATE TABLE t (
id bigint(20) unsigned NOT NULL auto_increment,
d date NOT NULL,
ts datetime(6) NOT NULL,
PRIMARY KEY (id,d)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50500 PARTITION BY HASH(id) partitions 200*/;
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
replace into t(d,ts) select t1.d,t1.ts from t t1, t t2, t t3, t t4, t t5, t t6, t t7, t t8, t t9, t t10;
commit;
update t set ts = now();
commit;
drop table t;
stop slave;
main.rpl_bug73648                        [ pass ]  106157
include/master-slave.inc
Warnings:
Note    ####    Sending passwords in plain text without SSL/TLS is extremely insecure.
Note    ####    Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
CREATE TABLE t (
id bigint(20) unsigned NOT NULL auto_increment,
d date NOT NULL,
ts datetime(6) NOT NULL,
PRIMARY KEY (id,d)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
insert into t(d,ts) values(current_date(),now());
replace into t(d,ts) select t1.d,t1.ts from t t1, t t2, t t3, t t4, t t5, t t6, t t7, t t8, t t9, t t10;
commit;
update t set ts = now();
commit;
drop table t;
stop slave;
main.rpl_bug73648_nonpart                [ pass ]  84426
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 190.583 of 210 seconds executing testcases

Completed: All 2 tests were successful.