Debian Codegraph @

mysql-test/suite/rpl/include/rpl_mixed_check_select.inc

raw
1 #########################################
2 # Author: Serge Kozlov [email protected]
3 # Date: 07/10/2006
4 # Purpose: Showing data from work tables on master and on slave
5 # Requirements:
6 #########################################
7
8 --echo ==========MASTER==========
9 SELECT COUNT(*) FROM t1;
10 SELECT * FROM t1 ORDER BY a;
11 SELECT COUNT(*) FROM t2;
12 SELECT * FROM t2 ORDER BY a;
13 sync_slave_with_master;
14 --echo ==========SLAVE===========
15 USE test_rpl;
16 SELECT COUNT(*) FROM t1;
17 SELECT * FROM t1 ORDER BY a;
18 SELECT COUNT(*) FROM t2;
19 SELECT * FROM t2 ORDER BY a;
20 connection master;
21