Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_unsafe_funcs.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 CREATE TABLE t1 (a INT);
5 CREATE TABLE t2 (a INT, b INT);
6 INSERT INTO t1 SELECT 1;
7 connection master1;
8 INSERT INTO t1 VALUES (2),(3),(4),(5),(6);
9 connection master;
10 INSERT INTO t2 SELECT 1, ROW_COUNT();
11 INSERT INTO t1 VALUES (2),(3),(4);
12 INSERT INTO t2 SELECT 2, ROW_COUNT();
13 SELECT b FROM t2 ORDER BY a;
14 b
15 1
16 3
17 connection slave;
18 SELECT b FROM t2 ORDER BY a;
19 b
20 1
21 3
22 connection master;
23 DROP TABLE t1, t2;
24 connection slave;
25 connection master;
26 include/rpl_end.inc