Debian Codegraph @

mysql-test/suite/rpl/t/rpl_change_master_implicit_gtid_warning.test

raw
1 #
2 # Purpose:
3 # This test validates that CHANGE MASTER TO does not emit a spurious
4 # warning about implicitly changing Using_Gtid when the value is not
5 # actually changing.
6 #
7 # References:
8 # MDEV-37842: CHANGE MASTER TO is implicitly changing the value of
9 # 'Using_Gtid' from 'No' to 'No'
10 #
11
12 # Format independent test so just use one
13 --source include/have_binlog_format_mixed.inc
14 --source include/master-slave.inc
15
16 --connection slave
17 --source include/stop_slave.inc
18
19 --echo #
20 --echo # Test 1: CHANGE MASTER TO with relay_log_pos when Using_Gtid is
21 --echo # already No should NOT produce a spurious 'from No to No' warning
22 --echo #
23 CHANGE MASTER TO MASTER_USE_GTID=NO;
24 CHANGE MASTER TO relay_log_pos=0;
25 SHOW WARNINGS;
26
27 --echo #
28 --echo # Test 2: CHANGE MASTER TO with master_log_file/pos when Using_Gtid
29 --echo # is already No should NOT produce a warning
30 --echo #
31 --let $io_log_pos= query_get_value('SHOW SLAVE STATUS', Read_Master_Log_Pos, 1)
32 --let $io_log_file= query_get_value('SHOW SLAVE STATUS', Master_Log_File, 1)
33 --replace_result $io_log_file IO_LOG_FILE $io_log_pos IO_LOG_POS
34 --eval CHANGE MASTER TO master_log_pos=$io_log_pos, master_log_file='$io_log_file'
35 SHOW WARNINGS;
36
37 --echo #
38 --echo # Test 3: CHANGE MASTER TO with log coordinates when Using_Gtid is
39 --echo # Slave_Pos SHOULD produce a warning (value actually changes)
40 --echo #
41 CHANGE MASTER TO MASTER_USE_GTID=Slave_Pos;
42 --replace_result $io_log_file IO_LOG_FILE $io_log_pos IO_LOG_POS
43 --eval CHANGE MASTER TO master_log_pos=$io_log_pos, master_log_file='$io_log_file'
44 SHOW WARNINGS;
45
46 --echo #
47 --echo # Cleanup
48 --echo #
49 CHANGE MASTER TO MASTER_USE_GTID=Slave_Pos;
50 --source include/start_slave.inc
51
52 --source include/rpl_end.inc