Debian Codegraph @

mysql-test/suite/rpl/t/rpl_row_unsafe_funcs.test

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