Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_gtid_mode_set_gtid_next.result

raw
1 include/rpl_init.inc [topology=none]
2 SET GLOBAL ENFORCE_GTID_CONSISTENCY = ON;
3 ==== GTID_MODE = OFF ====
4 ---- Old value is AUTOMATIC or ANONYMOUS ----
5 # AUTOMATIC -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
6 Expecting error ER_CANT_SET_GTID_NEXT_TO_GTID_WHEN_GTID_MODE_IS_OFF.
7 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
8 ERROR HY000: @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF.
9 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
10 include/assert.inc [GTID_OWNED == ""]
11 # AUTOMATIC -> ANONYMOUS
12 SET GTID_NEXT = 'ANONYMOUS';
13 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
14 include/assert.inc [GTID_OWNED == "ANONYMOUS"]
15 ROLLBACK;
16 # ANONYMOUS -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
17 Expecting error ER_CANT_SET_GTID_NEXT_TO_GTID_WHEN_GTID_MODE_IS_OFF.
18 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
19 ERROR HY000: @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF.
20 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
21 include/assert.inc [GTID_OWNED == ""]
22 # ANONYMOUS -> ANONYMOUS
23 SET GTID_NEXT = 'ANONYMOUS';
24 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
25 include/assert.inc [GTID_OWNED == "ANONYMOUS"]
26 ROLLBACK;
27 # ANONYMOUS -> AUTOMATIC
28 SET GTID_NEXT = 'AUTOMATIC';
29 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
30 include/assert.inc [GTID_OWNED == ""]
31 ROLLBACK;
32 # AUTOMATIC -> AUTOMATIC
33 SET GTID_NEXT = 'AUTOMATIC';
34 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
35 include/assert.inc [GTID_OWNED == ""]
36 ROLLBACK;
37 ---- Old value is UUID:NUMBER ----
38 SET GLOBAL GTID_MODE = 'OFF_PERMISSIVE';
39 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';;
40 ROLLBACK;
41 SET GLOBAL GTID_MODE = 'OFF';
42 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
43 Expecting error ER_CANT_SET_GTID_NEXT_TO_GTID_WHEN_GTID_MODE_IS_OFF.
44 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
45 ERROR HY000: @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF.
46 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
47 include/assert.inc [GTID_OWNED == ""]
48 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2
49 Expecting error ER_CANT_SET_GTID_NEXT_TO_GTID_WHEN_GTID_MODE_IS_OFF.
50 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
51 ERROR HY000: @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF.
52 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
53 include/assert.inc [GTID_OWNED == ""]
54 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> ANONYMOUS
55 SET GTID_NEXT = 'ANONYMOUS';
56 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
57 include/assert.inc [GTID_OWNED == "ANONYMOUS"]
58 ROLLBACK;
59 SET GLOBAL GTID_MODE = 'OFF_PERMISSIVE';
60 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';;
61 ROLLBACK;
62 SET GLOBAL GTID_MODE = 'OFF';
63 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> AUTOMATIC
64 SET GTID_NEXT = 'AUTOMATIC';
65 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
66 include/assert.inc [GTID_OWNED == ""]
67 ROLLBACK;
68 ==== GTID_MODE = OFF_PERMISSIVE ====
69 SET GLOBAL GTID_MODE = 'OFF_PERMISSIVE';
70 # AUTOMATIC -> AUTOMATIC
71 SET GTID_NEXT = 'AUTOMATIC';
72 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
73 include/assert.inc [GTID_OWNED == ""]
74 ROLLBACK;
75 # AUTOMATIC -> ANONYMOUS
76 SET GTID_NEXT = 'ANONYMOUS';
77 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
78 include/assert.inc [GTID_OWNED == "ANONYMOUS"]
79 ROLLBACK;
80 # ANONYMOUS -> ANONYMOUS
81 SET GTID_NEXT = 'ANONYMOUS';
82 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
83 include/assert.inc [GTID_OWNED == "ANONYMOUS"]
84 ROLLBACK;
85 # ANONYMOUS -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
86 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
87 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
88 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
89 ROLLBACK;
90 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
91 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
92 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
93 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
94 ROLLBACK;
95 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2
96 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
97 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2"]
98 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2"]
99 ROLLBACK;
100 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2 -> AUTOMATIC
101 SET GTID_NEXT = 'AUTOMATIC';
102 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
103 include/assert.inc [GTID_OWNED == ""]
104 ROLLBACK;
105 # AUTOMATIC -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
106 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
107 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
108 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
109 ROLLBACK;
110 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> ANONYMOUS
111 SET GTID_NEXT = 'ANONYMOUS';
112 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
113 include/assert.inc [GTID_OWNED == "ANONYMOUS"]
114 ROLLBACK;
115 # ANONYMOUS -> AUTOMATIC
116 SET GTID_NEXT = 'AUTOMATIC';
117 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
118 include/assert.inc [GTID_OWNED == ""]
119 ROLLBACK;
120 ==== GTID_MODE = ON_PERMISSIVE ====
121 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
122 # AUTOMATIC -> AUTOMATIC
123 SET GTID_NEXT = 'AUTOMATIC';
124 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
125 include/assert.inc [GTID_OWNED == ""]
126 ROLLBACK;
127 # AUTOMATIC -> ANONYMOUS
128 SET GTID_NEXT = 'ANONYMOUS';
129 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
130 include/assert.inc [GTID_OWNED == "ANONYMOUS"]
131 ROLLBACK;
132 # ANONYMOUS -> ANONYMOUS
133 SET GTID_NEXT = 'ANONYMOUS';
134 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
135 include/assert.inc [GTID_OWNED == "ANONYMOUS"]
136 ROLLBACK;
137 # ANONYMOUS -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
138 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
139 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
140 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
141 ROLLBACK;
142 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
143 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
144 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
145 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
146 ROLLBACK;
147 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2
148 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
149 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2"]
150 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2"]
151 ROLLBACK;
152 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2 -> AUTOMATIC
153 SET GTID_NEXT = 'AUTOMATIC';
154 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
155 include/assert.inc [GTID_OWNED == ""]
156 ROLLBACK;
157 # AUTOMATIC -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
158 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
159 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
160 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
161 ROLLBACK;
162 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> ANONYMOUS
163 SET GTID_NEXT = 'ANONYMOUS';
164 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
165 include/assert.inc [GTID_OWNED == "ANONYMOUS"]
166 ROLLBACK;
167 # ANONYMOUS -> AUTOMATIC
168 SET GTID_NEXT = 'AUTOMATIC';
169 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
170 include/assert.inc [GTID_OWNED == ""]
171 ROLLBACK;
172 ==== GTID_MODE = ON ====
173 ---- Old value is AUTOMATIC or GTID ----
174 SET @@GLOBAL.GTID_MODE = ON;
175 # AUTOMATIC -> AUTOMATIC
176 SET GTID_NEXT = 'AUTOMATIC';
177 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
178 include/assert.inc [GTID_OWNED == ""]
179 ROLLBACK;
180 # AUTOMATIC -> ANONYMOUS
181 Expecting error ER_CANT_SET_GTID_NEXT_TO_ANONYMOUS_WHEN_GTID_MODE_IS_ON.
182 SET GTID_NEXT = 'ANONYMOUS';
183 ERROR HY000: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON.
184 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
185 include/assert.inc [GTID_OWNED == ""]
186 # AUTOMATIC -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
187 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
188 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
189 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
190 ROLLBACK;
191 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
192 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
193 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
194 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
195 ROLLBACK;
196 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2
197 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
198 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2"]
199 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2"]
200 ROLLBACK;
201 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2 -> AUTOMATIC
202 SET GTID_NEXT = 'AUTOMATIC';
203 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
204 include/assert.inc [GTID_OWNED == ""]
205 ROLLBACK;
206 # AUTOMATIC -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
207 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
208 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
209 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
210 ROLLBACK;
211 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> ANONYMOUS
212 Expecting error ER_CANT_SET_GTID_NEXT_TO_ANONYMOUS_WHEN_GTID_MODE_IS_ON.
213 SET GTID_NEXT = 'ANONYMOUS';
214 ERROR HY000: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON.
215 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
216 include/assert.inc [GTID_OWNED == ""]
217 # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1 -> AUTOMATIC
218 SET GTID_NEXT = 'AUTOMATIC';
219 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
220 include/assert.inc [GTID_OWNED == ""]
221 ROLLBACK;
222 ---- Old value is ANONYMOUS ----
223 SET GLOBAL GTID_MODE = 'ON_PERMISSIVE';
224 SET GTID_NEXT = 'ANONYMOUS';;
225 ROLLBACK;
226 SET GLOBAL GTID_MODE = 'ON';
227 # ANONYMOUS -> ANONYMOUS
228 Expecting error ER_CANT_SET_GTID_NEXT_TO_ANONYMOUS_WHEN_GTID_MODE_IS_ON.
229 SET GTID_NEXT = 'ANONYMOUS';
230 ERROR HY000: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON.
231 include/assert.inc [GTID_NEXT == "ANONYMOUS"]
232 include/assert.inc [GTID_OWNED == ""]
233 # ANONYMOUS -> aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1
234 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
235 include/assert.inc [GTID_NEXT == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
236 include/assert.inc [GTID_OWNED == "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1"]
237 ROLLBACK;
238 SET GLOBAL GTID_MODE = 'ON_PERMISSIVE';
239 SET GTID_NEXT = 'ANONYMOUS';;
240 ROLLBACK;
241 SET GLOBAL GTID_MODE = 'ON';
242 # ANONYMOUS -> AUTOMATIC
243 SET GTID_NEXT = 'AUTOMATIC';
244 include/assert.inc [GTID_NEXT == "AUTOMATIC"]
245 include/assert.inc [GTID_OWNED == ""]
246 ROLLBACK;
247 ---- Clean up ----
248 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
249 SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
250 SET GLOBAL GTID_MODE = OFF;
251 SET GLOBAL ENFORCE_GTID_CONSISTENCY = OFF;
252 include/rpl_end.inc