MOON
Server: Apache/2.2.31 (Unix) mod_ssl/2.2.31 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4
System: Linux csr818.wilogic.com 2.6.18-419.el5xen #1 SMP Fri Feb 24 22:50:37 UTC 2017 x86_64
User: obrechts (544)
PHP: 5.4.45
Disabled: NONE
Upload Files
File: //usr/share/mysql-test/suite/rpl/t/rpl_row_unsafe_funcs.test
source include/master-slave.inc;
source include/have_binlog_format_mixed.inc;

#
# Bug #30244: row_count/found_rows does not replicate well
#

connection master;

CREATE TABLE t1 (a INT); 
CREATE TABLE t2 (a INT, b INT); 

INSERT INTO t1 SELECT 1;

connection master1;
INSERT INTO t1 VALUES (2),(3),(4),(5),(6);

connection master;
INSERT INTO t2 SELECT 1, ROW_COUNT();

INSERT INTO t1 VALUES (2),(3),(4);
INSERT INTO t2 SELECT 2, ROW_COUNT();

#must return 1 and 3
SELECT b FROM t2 ORDER BY a;

sync_slave_with_master;

#must return 1 and 3
SELECT b FROM t2 ORDER BY a;

connection master;
DROP TABLE t1, t2;
sync_slave_with_master;
connection master;
--source include/rpl_end.inc