Edit File: 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
Back to File Manager