Debian Codegraph @

mysql-test/suite/binlog_nogtid/t/binlog_enforce_gtid_consistency_option.test

raw
1 # ==== Purpose ====
2 #
3 # Test that the command-line enforce-gtid-consistency accepts the
4 # values it is supposed to accept. This is a special variable, hence
5 # the elaborate testing. The variable was boolean in 5.6, but changed
6 # in 5.7 into an enumeration. However, normal enumerations aren't
7 # entirely compatible with booleans:
8 #
9 # - Boolean has two aliases per value: 0=off=false, 1=on=true, but
10 # enum only allows one alias per value.
11 #
12 # - Boolean is displayed as an int, enum displays the alias.
13 #
14 # - Boolean allows command-line options without arguments, like
15 # --enforce-gtid-consistency (without =ON), enum does not.
16 #
17 # To create a three-valued variable that has multiple aliases per
18 # value, is displayed as an int, and can be used on the command line
19 # without argument, we needed a bit of new code. So that's what we
20 # test here.
21 #
22 # ==== Implementation ====
23 #
24 # Restart the server several times, specifying
25 # enforce-gtid-consistency in different ways.
26 #
27 # ==== References ====
28 #
29 # WL#7083: GTIDs: set gtid_mode=ON online
30 # - The third value for enforce-gtid-consistency was added in this worklog.
31
32 # No point in running combinations.
33 --source include/have_binlog_format_statement.inc
34
35 # Restarts many times, and very unlikely to ever fail again.
36 --source include/big_test.inc
37
38 --let $rpl_server_count= 1
39 --let $rpl_topology= none
40 --source include/rpl_init.inc
41
42 CALL mtr.add_suppression("option 'enforce-gtid-consistency': value '.*' was");
43
44 --echo ==== No option: defaults to 0 ====
45
46 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
47
48 --echo ==== Option given without value: defaults to 1 ====
49
50 --let $rpl_server_parameters= --enforce-gtid-consistency
51 --let $rpl_server_number= 1
52 --source include/rpl_restart_server.inc
53
54 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
55
56 --echo ==== Option given with invalid values: defaults to 0 ====
57
58 --let $rpl_server_parameters= --enforce-gtid-consistency=
59 --source include/rpl_restart_server.inc
60
61 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
62
63 --let $rpl_server_parameters= --enforce-gtid-consistency=homersimpson
64 --source include/rpl_restart_server.inc
65
66 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
67
68 --let $rpl_server_parameters= --enforce-gtid-consistency=-1
69 --source include/rpl_restart_server.inc
70
71 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
72
73 --let $rpl_server_parameters= --enforce-gtid-consistency=3
74 --source include/rpl_restart_server.inc
75
76 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
77
78 --echo ==== Option given with correct value, equal to 1 ====
79
80 --let $rpl_server_parameters= --enforce-gtid-consistency=1
81 --source include/rpl_restart_server.inc
82
83 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
84
85 --let $rpl_server_parameters= --enforce-gtid-consistency=on
86 --source include/rpl_restart_server.inc
87
88 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
89
90 --let $rpl_server_parameters= --enforce-gtid-consistency=true
91 --source include/rpl_restart_server.inc
92
93 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
94
95 --echo ==== Option given with correct value, equal to 2 ====
96
97 --let $rpl_server_parameters= --enforce-gtid-consistency=2
98 --source include/rpl_restart_server.inc
99
100 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
101
102 --let $rpl_server_parameters= --enforce-gtid-consistency=warn
103 --source include/rpl_restart_server.inc
104
105 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
106
107 --echo ==== Option given with correct value, equal to 0 ====
108
109 --let $rpl_server_parameters= --enforce-gtid-consistency=0
110 --source include/rpl_restart_server.inc
111
112 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
113
114 --let $rpl_server_parameters= --enforce-gtid-consistency=off
115 --source include/rpl_restart_server.inc
116
117 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
118
119 --let $rpl_server_parameters= --enforce-gtid-consistency=false
120 --source include/rpl_restart_server.inc
121
122 SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
123
124 --source include/rpl_end.inc