Debian Codegraph @

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

raw
1 #
2 # This include file validates that sequence events are properly binlogged
3 # and replicated.
4 #
5 # Parameters:
6 # expected_columns (list<uint>, in) : A list of positive integers which
7 # correspond to the column numbers that should be output in a binary
8 # log's write_rows event
9 #
10
11 --echo # Create sequences with specific engines per server
12 --connection server_1
13 --eval SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=$server_1_engine
14 --source include/save_master_gtid.inc
15
16 --connection server_2
17 --eval SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=$server_2_engine
18 --source include/sync_with_master_gtid.inc
19
20 --connection server_3
21 --eval SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=$server_3_engine
22 --source include/sync_with_master_gtid.inc
23
24
25 --echo # Pt.1 Ensure SETVAL replicates and binlogs correctly
26 --connection server_1
27 SELECT SETVAL(s1, 10);
28 --source include/save_master_gtid.inc
29
30 --echo # Validate SETVAL replicated correctly to other servers
31 --connection server_3
32 --source include/sync_with_master_gtid.inc
33 --let $diff_tables= server_1:test.s1,server_2:test.s1,server_3:test.s1
34 --source include/diff_tables.inc
35
36 --echo # Validate server_1 binlogged SETVAL with the correct columns
37 --connection server_1
38 --let binlog_filenamE= query_get_value(SHOW MASTER STATUS, File, 1)
39 FLUSH LOGS;
40 --source include/ensure_binlog_row_event_columns.inc
41
42 --echo # Validate server_2 binlogged SETVAL with the correct columns
43 --connection server_2
44 --let binlog_filename= query_get_value(SHOW MASTER STATUS, File, 1)
45 FLUSH LOGS;
46 --source include/ensure_binlog_row_event_columns.inc
47
48 --echo # Validate server_3 binlogged SETVAL with the correct columns
49 --connection server_3
50 --let binlog_filename= query_get_value(SHOW MASTER STATUS, File, 1)
51 FLUSH LOGS;
52 --source include/ensure_binlog_row_event_columns.inc
53
54
55 --echo # Pt.2 Ensure NEXTVAL replicates and binlogs correctly
56 --connection server_1
57 --disable_ps2_protocol
58 SELECT NEXTVAL(s1);
59 --enable_ps2_protocol
60 --source include/save_master_gtid.inc
61
62 --echo # Validate NEXTVAL replicated correctly to other servers
63 --connection server_3
64 --source include/sync_with_master_gtid.inc
65 --let $diff_tables= server_1:test.s1,server_2:test.s1,server_3:test.s1
66 --source include/diff_tables.inc
67
68 --echo # Validate server_1 binlogged NEXTVAL with the correct columns
69 --connection server_1
70 --let binlog_filename= query_get_value(SHOW MASTER STATUS, File, 1)
71 FLUSH LOGS;
72 --source include/ensure_binlog_row_event_columns.inc
73
74 --echo # Validate server_2 binlogged NEXTVAL with the correct columns
75 --connection server_2
76 --let binlog_filename= query_get_value(SHOW MASTER STATUS, File, 1)
77 FLUSH LOGS;
78 --source include/ensure_binlog_row_event_columns.inc
79
80 --echo # Validate server_3 binlogged NEXTVAL with the correct columns
81 --connection server_3
82 --let binlog_filename= query_get_value(SHOW MASTER STATUS, File, 1)
83 FLUSH LOGS;
84 --source include/ensure_binlog_row_event_columns.inc
85
86
87 --echo # Cleanup
88 --connection server_1
89 DROP TABLE s1;
90 --source include/save_master_gtid.inc
91 --connection server_3
92 --source include/sync_with_master_gtid.inc