1source include/have_binlog_format_mixed.inc; 2source include/master-slave.inc; 3 4# 5# Bug #30244: row_count/found_rows does not replicate well 6# 7 8connection master; 9 10CREATE TABLE t1 (a INT); 11CREATE TABLE t2 (a INT, b INT); 12 13INSERT INTO t1 SELECT 1; 14 15connection master1; 16INSERT INTO t1 VALUES (2),(3),(4),(5),(6); 17 18connection master; 19INSERT INTO t2 SELECT 1, ROW_COUNT(); 20 21INSERT INTO t1 VALUES (2),(3),(4); 22INSERT INTO t2 SELECT 2, ROW_COUNT(); 23 24#must return 1 and 3 25SELECT b FROM t2 ORDER BY a; 26 27sync_slave_with_master; 28 29#must return 1 and 3 30SELECT b FROM t2 ORDER BY a; 31 32connection master; 33DROP TABLE t1, t2; 34sync_slave_with_master; 35connection master; 36--source include/rpl_end.inc 37