Debian Codegraph @

mysql-test/suite/group_replication/t/gr_skip_send_lower_case_table_names.test

raw
1 ################################################################################
2 ## This test proves that group replication allows member to join the group if
3 ## it does not send its lower_case_table_names value. This is required so
4 ## members with higher version can join groups which has member of lower
5 ## version.
6 ##
7 ## Test:
8 ## 0. This test requires 2 members.
9 ## 1. Set debug flag so server1 does not send its value of
10 ## lower_case_table_names and bootstrap group.
11 ## 2. Start server2.
12 ## 3. Verify server2 joins the group.
13 ## 4. Cleanup.
14 ################################################################################
15
16 --source include/have_debug.inc
17 --source include/have_group_replication_plugin.inc
18 --let $rpl_skip_group_replication_start= 1
19 --source include/group_replication.inc
20
21 --echo
22 --echo ## 1. Set debug flag so server1 does not send its value of
23 --echo ## lower_case_table_names and bootstrap group.
24 --echo
25 --let $rpl_connection_name= server1
26 --source include/rpl_connection.inc
27
28 SET @debug_save= @@GLOBAL.DEBUG;
29 SET @@GLOBAL.DEBUG='+d,group_replication_skip_encode_lower_case_table_names';
30
31 --source include/start_and_bootstrap_group_replication.inc
32
33 --echo
34 --echo ## 2. Start server2.
35 --echo
36 --let $rpl_connection_name= server2
37 --source include/rpl_connection.inc
38
39 --source include/start_group_replication.inc
40
41 --echo
42 --echo ## 3. Verify server2 joins the group.
43 --echo
44 --let $assert_text= Assert 2 servers are ONLINE
45 --let $assert_cond= "[SELECT COUNT(*) from performance_schema.replication_group_members WHERE MEMBER_STATE=\"ONLINE\"]" = 2
46 --source include/assert.inc
47
48 --let $rpl_connection_name= server1
49 --source include/rpl_connection.inc
50 --let $assert_text= Assert 2 servers are ONLINE
51 --let $assert_cond= "[SELECT COUNT(*) from performance_schema.replication_group_members WHERE MEMBER_STATE=\"ONLINE\"]" = 2
52 --source include/assert.inc
53
54 --echo
55 --echo ## 4. Cleanup.
56 --echo
57 SET @@GLOBAL.DEBUG= @debug_save;
58 --source include/group_replication_end.inc