Debian Codegraph @

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

raw
1 -- connection master
2 -- source include/rpl_reset.inc
3
4 -- connection master
5
6 CREATE TABLE t1 (a INT);
7 INSERT INTO t1 VALUES (1);
8 INSERT INTO t1 VALUES (2);
9 INSERT INTO t1 VALUES (3);
10
11 # PART I
12 #
13 # SHOWs contents of binary logs on the master and both, binary and
14 # relay logs, on the slave.
15 #
16
17 --let $is_relay_log= 0
18 --let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
19 --source suite/rpl/include/rpl_show_log_events_with_varying_options.inc
20
21 --sync_slave_with_master
22 --let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
23 --source suite/rpl/include/rpl_show_log_events_with_varying_options.inc
24
25 --let $is_relay_log= 1
26 --let $binlog_file= query_get_value(SHOW SLAVE STATUS, Relay_Log_File, 1)
27 --source suite/rpl/include/rpl_show_log_events_with_varying_options.inc
28
29 #
30 # PART II
31 #
32 # Although this second part of the test may seem redudant it is
33 # actually needed to assert that SHOW RELAYLOG EVENTS works properly
34 # with respect to the ordering of the relay log in relay-log.index.
35 #
36 # If no file is specified with "IN" then first relay log file in
37 # relay-log.index (ie, the oldest one) should be picked and its
38 # contents displayed. The same happens for SHOW BINLOG EVENTS, so we
39 # show them both. All in all, this is the reason for re-assert after
40 # MASTER and SLAVE's FLUSH LOGS operations.
41 #
42
43 FLUSH LOGS;
44 --source include/wait_for_binlog_checkpoint.inc
45 -- connection master
46 FLUSH LOGS;
47 --source include/wait_for_binlog_checkpoint.inc
48 DROP TABLE t1;
49
50 --let $is_relay_log= 0
51 --let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
52 --source suite/rpl/include/rpl_show_log_events_with_varying_options.inc
53
54 --sync_slave_with_master
55 --let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
56 --source suite/rpl/include/rpl_show_log_events_with_varying_options.inc
57
58 --let $is_relay_log= 1
59 --let $binlog_file= query_get_value(SHOW SLAVE STATUS, Relay_Log_File, 1)
60 --source suite/rpl/include/rpl_show_log_events_with_varying_options.inc
61
62
63 # clear show_binlog_event/show_relaylog_events parameters
64 let $binlog_file= ;
65 let $binlog_limit= ;