|
1
by brian
clean slate |
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 |
sync_slave_with_master; |
|
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 |
sync_slave_with_master; |
|
35 |
connection master; |