Debian Codegraph @

mysql-test/suite/binlog/r/binlog_enforce_gtid_consistency_create_select_consistent.result

raw
1 include/begin_replace_gtid_combination.inc [gtid_mode=off/on -> default_storage_engine=InnoDB/MyISAM]
2 include/rpl_init.inc [topology=none]
3 SET @old_sql_notes= @@GLOBAL.SQL_NOTES;
4 SET GLOBAL SQL_NOTES= 0;
5 SET SESSION SQL_NOTES= 0;
6 CALL mtr.add_suppression('Statement violates GTID consistency:');
7 CALL mtr.add_suppression('Unsafe statement written to the binary log');
8 SET GLOBAL ENFORCE_GTID_CONSISTENCY = 0;
9 SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
10 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
11 SET GLOBAL GTID_MODE = 2;
12 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=ON_PERMISSIVE GTID_NEXT=AUTOMATIC ########
13 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
14 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
15 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
16 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
17 INSERT INTO nonempty_innodb VALUES (1);
18 INSERT INTO nonempty_myisam VALUES (1);
19 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
20 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
21 SET GTID_NEXT = 'AUTOMATIC';
22 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
23 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
24 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
25 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
26 include/assert.inc [No warning or error should be generated.]
27 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
28 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
29 ROLLBACK;
30 SET GTID_NEXT = 'AUTOMATIC';
31 include/assert.inc [Both counters should be 0]
32 DROP TABLE IF EXISTS t1;
33 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
34 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
35 SET GTID_NEXT = 'AUTOMATIC';
36 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
37 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
38 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
39 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
40 include/assert.inc [No warning or error should be generated.]
41 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
42 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
43 ROLLBACK;
44 SET GTID_NEXT = 'AUTOMATIC';
45 include/assert.inc [Both counters should be 0]
46 DROP TABLE IF EXISTS t1;
47 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
48 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
49 SET GTID_NEXT = 'AUTOMATIC';
50 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
51 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
52 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
53 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
54 include/assert.inc [No warning or error should be generated.]
55 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
56 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
57 ROLLBACK;
58 SET GTID_NEXT = 'AUTOMATIC';
59 include/assert.inc [Both counters should be 0]
60 DROP TABLE IF EXISTS t1;
61 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
62 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
63 SET GTID_NEXT = 'AUTOMATIC';
64 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
65 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
66 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
67 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
68 include/assert.inc [No warning or error should be generated.]
69 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
70 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
71 ROLLBACK;
72 SET GTID_NEXT = 'AUTOMATIC';
73 include/assert.inc [Both counters should be 0]
74 DROP TABLE IF EXISTS t1;
75 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
76 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
77 SET GTID_NEXT = 'AUTOMATIC';
78 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
79 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
80 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
81 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
82 include/assert.inc [No warning or error should be generated.]
83 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
84 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
85 ROLLBACK;
86 SET GTID_NEXT = 'AUTOMATIC';
87 include/assert.inc [Both counters should be 0]
88 DROP TABLE IF EXISTS t1;
89 SET SQL_LOG_BIN = 0;
90 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
91 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
92 SET GTID_NEXT = 'AUTOMATIC';
93 [START] CREATE TABLE t1 (a INT) SELECT 1;
94 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
95 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
96 [END] CREATE TABLE t1 (a INT) SELECT 1;
97 include/assert.inc [No warning or error should be generated.]
98 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
99 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
100 ROLLBACK;
101 SET GTID_NEXT = 'AUTOMATIC';
102 include/assert.inc [Both counters should be 0]
103 DROP TABLE IF EXISTS t1;
104 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
105 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
106 SET GTID_NEXT = 'AUTOMATIC';
107 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
108 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
109 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
110 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
111 include/assert.inc [No warning or error should be generated.]
112 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
113 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
114 ROLLBACK;
115 SET GTID_NEXT = 'AUTOMATIC';
116 include/assert.inc [Both counters should be 0]
117 DROP TABLE IF EXISTS t1;
118 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
119 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
120 SET GTID_NEXT = 'AUTOMATIC';
121 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
122 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
123 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
124 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
125 include/assert.inc [No warning or error should be generated.]
126 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
127 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
128 ROLLBACK;
129 SET GTID_NEXT = 'AUTOMATIC';
130 include/assert.inc [Both counters should be 0]
131 DROP TABLE IF EXISTS t1;
132 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
133 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
134 SET GTID_NEXT = 'AUTOMATIC';
135 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
136 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
137 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
138 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
139 include/assert.inc [No warning or error should be generated.]
140 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
141 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
142 ROLLBACK;
143 SET GTID_NEXT = 'AUTOMATIC';
144 include/assert.inc [Both counters should be 0]
145 DROP TABLE IF EXISTS t1;
146 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
147 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
148 SET GTID_NEXT = 'AUTOMATIC';
149 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
150 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
151 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
152 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
153 include/assert.inc [No warning or error should be generated.]
154 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
155 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
156 ROLLBACK;
157 SET GTID_NEXT = 'AUTOMATIC';
158 include/assert.inc [Both counters should be 0]
159 DROP TABLE IF EXISTS t1;
160 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
161 SET SQL_LOG_BIN = 1;
162 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=ON_PERMISSIVE GTID_NEXT=ANONYMOUS ########
163 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
164 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
165 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
166 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
167 INSERT INTO nonempty_innodb VALUES (1);
168 INSERT INTO nonempty_myisam VALUES (1);
169 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
170 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
171 SET GTID_NEXT = 'ANONYMOUS';
172 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
173 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
174 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
175 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
176 include/assert.inc [No warning or error should be generated.]
177 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
178 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
179 ROLLBACK;
180 SET GTID_NEXT = 'AUTOMATIC';
181 include/assert.inc [Both counters should be 0]
182 DROP TABLE IF EXISTS t1;
183 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
184 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
185 SET GTID_NEXT = 'ANONYMOUS';
186 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
187 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
188 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
189 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
190 include/assert.inc [No warning or error should be generated.]
191 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
192 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
193 ROLLBACK;
194 SET GTID_NEXT = 'AUTOMATIC';
195 include/assert.inc [Both counters should be 0]
196 DROP TABLE IF EXISTS t1;
197 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
198 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
199 SET GTID_NEXT = 'ANONYMOUS';
200 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
201 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
202 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
203 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
204 include/assert.inc [No warning or error should be generated.]
205 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
206 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
207 ROLLBACK;
208 SET GTID_NEXT = 'AUTOMATIC';
209 include/assert.inc [Both counters should be 0]
210 DROP TABLE IF EXISTS t1;
211 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
212 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
213 SET GTID_NEXT = 'ANONYMOUS';
214 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
215 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
216 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
217 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
218 include/assert.inc [No warning or error should be generated.]
219 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
220 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
221 ROLLBACK;
222 SET GTID_NEXT = 'AUTOMATIC';
223 include/assert.inc [Both counters should be 0]
224 DROP TABLE IF EXISTS t1;
225 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
226 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
227 SET GTID_NEXT = 'ANONYMOUS';
228 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
229 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
230 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
231 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
232 include/assert.inc [No warning or error should be generated.]
233 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
234 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
235 ROLLBACK;
236 SET GTID_NEXT = 'AUTOMATIC';
237 include/assert.inc [Both counters should be 0]
238 DROP TABLE IF EXISTS t1;
239 SET SQL_LOG_BIN = 0;
240 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
241 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
242 SET GTID_NEXT = 'ANONYMOUS';
243 [START] CREATE TABLE t1 (a INT) SELECT 1;
244 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
245 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
246 [END] CREATE TABLE t1 (a INT) SELECT 1;
247 include/assert.inc [No warning or error should be generated.]
248 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
249 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
250 ROLLBACK;
251 SET GTID_NEXT = 'AUTOMATIC';
252 include/assert.inc [Both counters should be 0]
253 DROP TABLE IF EXISTS t1;
254 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
255 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
256 SET GTID_NEXT = 'ANONYMOUS';
257 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
258 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
259 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
260 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
261 include/assert.inc [No warning or error should be generated.]
262 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
263 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
264 ROLLBACK;
265 SET GTID_NEXT = 'AUTOMATIC';
266 include/assert.inc [Both counters should be 0]
267 DROP TABLE IF EXISTS t1;
268 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
269 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
270 SET GTID_NEXT = 'ANONYMOUS';
271 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
272 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
273 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
274 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
275 include/assert.inc [No warning or error should be generated.]
276 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
277 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
278 ROLLBACK;
279 SET GTID_NEXT = 'AUTOMATIC';
280 include/assert.inc [Both counters should be 0]
281 DROP TABLE IF EXISTS t1;
282 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
283 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
284 SET GTID_NEXT = 'ANONYMOUS';
285 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
286 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
287 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
288 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
289 include/assert.inc [No warning or error should be generated.]
290 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
291 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
292 ROLLBACK;
293 SET GTID_NEXT = 'AUTOMATIC';
294 include/assert.inc [Both counters should be 0]
295 DROP TABLE IF EXISTS t1;
296 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
297 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
298 SET GTID_NEXT = 'ANONYMOUS';
299 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
300 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
301 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
302 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
303 include/assert.inc [No warning or error should be generated.]
304 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
305 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
306 ROLLBACK;
307 SET GTID_NEXT = 'AUTOMATIC';
308 include/assert.inc [Both counters should be 0]
309 DROP TABLE IF EXISTS t1;
310 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
311 SET SQL_LOG_BIN = 1;
312 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=ON_PERMISSIVE GTID_NEXT=GTID ########
313 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
314 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
315 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
316 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
317 INSERT INTO nonempty_innodb VALUES (1);
318 INSERT INTO nonempty_myisam VALUES (1);
319 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
320 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
321 SET GTID_NEXT = 'GTID';
322 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
323 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
324 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
325 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
326 include/assert.inc [No warning or error should be generated.]
327 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
328 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
329 ROLLBACK;
330 SET GTID_NEXT = 'AUTOMATIC';
331 include/assert.inc [Both counters should be 0]
332 DROP TABLE IF EXISTS t1;
333 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
334 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
335 SET GTID_NEXT = 'GTID';
336 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
337 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
338 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
339 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
340 include/assert.inc [No warning or error should be generated.]
341 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
342 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
343 ROLLBACK;
344 SET GTID_NEXT = 'AUTOMATIC';
345 include/assert.inc [Both counters should be 0]
346 DROP TABLE IF EXISTS t1;
347 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
348 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
349 SET GTID_NEXT = 'GTID';
350 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
351 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
352 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
353 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
354 include/assert.inc [No warning or error should be generated.]
355 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
356 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
357 ROLLBACK;
358 SET GTID_NEXT = 'AUTOMATIC';
359 include/assert.inc [Both counters should be 0]
360 DROP TABLE IF EXISTS t1;
361 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
362 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
363 SET GTID_NEXT = 'GTID';
364 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
365 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
366 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
367 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
368 include/assert.inc [No warning or error should be generated.]
369 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
370 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
371 ROLLBACK;
372 SET GTID_NEXT = 'AUTOMATIC';
373 include/assert.inc [Both counters should be 0]
374 DROP TABLE IF EXISTS t1;
375 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
376 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
377 SET GTID_NEXT = 'GTID';
378 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
379 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
380 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
381 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
382 include/assert.inc [No warning or error should be generated.]
383 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
384 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
385 ROLLBACK;
386 SET GTID_NEXT = 'AUTOMATIC';
387 include/assert.inc [Both counters should be 0]
388 DROP TABLE IF EXISTS t1;
389 SET SQL_LOG_BIN = 0;
390 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
391 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
392 SET GTID_NEXT = 'GTID';
393 [START] CREATE TABLE t1 (a INT) SELECT 1;
394 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
395 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
396 [END] CREATE TABLE t1 (a INT) SELECT 1;
397 include/assert.inc [No warning or error should be generated.]
398 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
399 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
400 ROLLBACK;
401 SET GTID_NEXT = 'AUTOMATIC';
402 include/assert.inc [Both counters should be 0]
403 DROP TABLE IF EXISTS t1;
404 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
405 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
406 SET GTID_NEXT = 'GTID';
407 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
408 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
409 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
410 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
411 include/assert.inc [No warning or error should be generated.]
412 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
413 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
414 ROLLBACK;
415 SET GTID_NEXT = 'AUTOMATIC';
416 include/assert.inc [Both counters should be 0]
417 DROP TABLE IF EXISTS t1;
418 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
419 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
420 SET GTID_NEXT = 'GTID';
421 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
422 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
423 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
424 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
425 include/assert.inc [No warning or error should be generated.]
426 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
427 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
428 ROLLBACK;
429 SET GTID_NEXT = 'AUTOMATIC';
430 include/assert.inc [Both counters should be 0]
431 DROP TABLE IF EXISTS t1;
432 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
433 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
434 SET GTID_NEXT = 'GTID';
435 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
436 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
437 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
438 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
439 include/assert.inc [No warning or error should be generated.]
440 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
441 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
442 ROLLBACK;
443 SET GTID_NEXT = 'AUTOMATIC';
444 include/assert.inc [Both counters should be 0]
445 DROP TABLE IF EXISTS t1;
446 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
447 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
448 SET GTID_NEXT = 'GTID';
449 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
450 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
451 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
452 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
453 include/assert.inc [No warning or error should be generated.]
454 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
455 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
456 ROLLBACK;
457 SET GTID_NEXT = 'AUTOMATIC';
458 include/assert.inc [Both counters should be 0]
459 DROP TABLE IF EXISTS t1;
460 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
461 SET SQL_LOG_BIN = 1;
462 SET GLOBAL GTID_MODE = 1;
463 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF_PERMISSIVE GTID_NEXT=AUTOMATIC ########
464 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
465 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
466 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
467 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
468 INSERT INTO nonempty_innodb VALUES (1);
469 INSERT INTO nonempty_myisam VALUES (1);
470 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
471 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
472 SET GTID_NEXT = 'AUTOMATIC';
473 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
474 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
475 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
476 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
477 include/assert.inc [No warning or error should be generated.]
478 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
479 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
480 ROLLBACK;
481 SET GTID_NEXT = 'AUTOMATIC';
482 include/assert.inc [Both counters should be 0]
483 DROP TABLE IF EXISTS t1;
484 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
485 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
486 SET GTID_NEXT = 'AUTOMATIC';
487 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
488 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
489 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
490 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
491 include/assert.inc [No warning or error should be generated.]
492 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
493 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
494 ROLLBACK;
495 SET GTID_NEXT = 'AUTOMATIC';
496 include/assert.inc [Both counters should be 0]
497 DROP TABLE IF EXISTS t1;
498 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
499 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
500 SET GTID_NEXT = 'AUTOMATIC';
501 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
502 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
503 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
504 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
505 include/assert.inc [No warning or error should be generated.]
506 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
507 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
508 ROLLBACK;
509 SET GTID_NEXT = 'AUTOMATIC';
510 include/assert.inc [Both counters should be 0]
511 DROP TABLE IF EXISTS t1;
512 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
513 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
514 SET GTID_NEXT = 'AUTOMATIC';
515 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
516 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
517 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
518 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
519 include/assert.inc [No warning or error should be generated.]
520 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
521 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
522 ROLLBACK;
523 SET GTID_NEXT = 'AUTOMATIC';
524 include/assert.inc [Both counters should be 0]
525 DROP TABLE IF EXISTS t1;
526 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
527 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
528 SET GTID_NEXT = 'AUTOMATIC';
529 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
530 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
531 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
532 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
533 include/assert.inc [No warning or error should be generated.]
534 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
535 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
536 ROLLBACK;
537 SET GTID_NEXT = 'AUTOMATIC';
538 include/assert.inc [Both counters should be 0]
539 DROP TABLE IF EXISTS t1;
540 SET SQL_LOG_BIN = 0;
541 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
542 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
543 SET GTID_NEXT = 'AUTOMATIC';
544 [START] CREATE TABLE t1 (a INT) SELECT 1;
545 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
546 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
547 [END] CREATE TABLE t1 (a INT) SELECT 1;
548 include/assert.inc [No warning or error should be generated.]
549 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
550 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
551 ROLLBACK;
552 SET GTID_NEXT = 'AUTOMATIC';
553 include/assert.inc [Both counters should be 0]
554 DROP TABLE IF EXISTS t1;
555 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
556 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
557 SET GTID_NEXT = 'AUTOMATIC';
558 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
559 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
560 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
561 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
562 include/assert.inc [No warning or error should be generated.]
563 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
564 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
565 ROLLBACK;
566 SET GTID_NEXT = 'AUTOMATIC';
567 include/assert.inc [Both counters should be 0]
568 DROP TABLE IF EXISTS t1;
569 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
570 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
571 SET GTID_NEXT = 'AUTOMATIC';
572 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
573 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
574 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
575 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
576 include/assert.inc [No warning or error should be generated.]
577 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
578 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
579 ROLLBACK;
580 SET GTID_NEXT = 'AUTOMATIC';
581 include/assert.inc [Both counters should be 0]
582 DROP TABLE IF EXISTS t1;
583 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
584 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
585 SET GTID_NEXT = 'AUTOMATIC';
586 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
587 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
588 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
589 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
590 include/assert.inc [No warning or error should be generated.]
591 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
592 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
593 ROLLBACK;
594 SET GTID_NEXT = 'AUTOMATIC';
595 include/assert.inc [Both counters should be 0]
596 DROP TABLE IF EXISTS t1;
597 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
598 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
599 SET GTID_NEXT = 'AUTOMATIC';
600 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
601 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
602 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
603 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
604 include/assert.inc [No warning or error should be generated.]
605 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
606 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
607 ROLLBACK;
608 SET GTID_NEXT = 'AUTOMATIC';
609 include/assert.inc [Both counters should be 0]
610 DROP TABLE IF EXISTS t1;
611 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
612 SET SQL_LOG_BIN = 1;
613 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF_PERMISSIVE GTID_NEXT=ANONYMOUS ########
614 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
615 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
616 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
617 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
618 INSERT INTO nonempty_innodb VALUES (1);
619 INSERT INTO nonempty_myisam VALUES (1);
620 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
621 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
622 SET GTID_NEXT = 'ANONYMOUS';
623 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
624 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
625 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
626 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
627 include/assert.inc [No warning or error should be generated.]
628 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
629 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
630 ROLLBACK;
631 SET GTID_NEXT = 'AUTOMATIC';
632 include/assert.inc [Both counters should be 0]
633 DROP TABLE IF EXISTS t1;
634 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
635 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
636 SET GTID_NEXT = 'ANONYMOUS';
637 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
638 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
639 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
640 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
641 include/assert.inc [No warning or error should be generated.]
642 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
643 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
644 ROLLBACK;
645 SET GTID_NEXT = 'AUTOMATIC';
646 include/assert.inc [Both counters should be 0]
647 DROP TABLE IF EXISTS t1;
648 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
649 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
650 SET GTID_NEXT = 'ANONYMOUS';
651 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
652 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
653 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
654 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
655 include/assert.inc [No warning or error should be generated.]
656 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
657 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
658 ROLLBACK;
659 SET GTID_NEXT = 'AUTOMATIC';
660 include/assert.inc [Both counters should be 0]
661 DROP TABLE IF EXISTS t1;
662 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
663 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
664 SET GTID_NEXT = 'ANONYMOUS';
665 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
666 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
667 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
668 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
669 include/assert.inc [No warning or error should be generated.]
670 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
671 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
672 ROLLBACK;
673 SET GTID_NEXT = 'AUTOMATIC';
674 include/assert.inc [Both counters should be 0]
675 DROP TABLE IF EXISTS t1;
676 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
677 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
678 SET GTID_NEXT = 'ANONYMOUS';
679 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
680 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
681 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
682 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
683 include/assert.inc [No warning or error should be generated.]
684 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
685 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
686 ROLLBACK;
687 SET GTID_NEXT = 'AUTOMATIC';
688 include/assert.inc [Both counters should be 0]
689 DROP TABLE IF EXISTS t1;
690 SET SQL_LOG_BIN = 0;
691 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
692 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
693 SET GTID_NEXT = 'ANONYMOUS';
694 [START] CREATE TABLE t1 (a INT) SELECT 1;
695 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
696 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
697 [END] CREATE TABLE t1 (a INT) SELECT 1;
698 include/assert.inc [No warning or error should be generated.]
699 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
700 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
701 ROLLBACK;
702 SET GTID_NEXT = 'AUTOMATIC';
703 include/assert.inc [Both counters should be 0]
704 DROP TABLE IF EXISTS t1;
705 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
706 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
707 SET GTID_NEXT = 'ANONYMOUS';
708 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
709 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
710 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
711 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
712 include/assert.inc [No warning or error should be generated.]
713 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
714 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
715 ROLLBACK;
716 SET GTID_NEXT = 'AUTOMATIC';
717 include/assert.inc [Both counters should be 0]
718 DROP TABLE IF EXISTS t1;
719 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
720 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
721 SET GTID_NEXT = 'ANONYMOUS';
722 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
723 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
724 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
725 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
726 include/assert.inc [No warning or error should be generated.]
727 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
728 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
729 ROLLBACK;
730 SET GTID_NEXT = 'AUTOMATIC';
731 include/assert.inc [Both counters should be 0]
732 DROP TABLE IF EXISTS t1;
733 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
734 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
735 SET GTID_NEXT = 'ANONYMOUS';
736 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
737 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
738 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
739 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
740 include/assert.inc [No warning or error should be generated.]
741 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
742 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
743 ROLLBACK;
744 SET GTID_NEXT = 'AUTOMATIC';
745 include/assert.inc [Both counters should be 0]
746 DROP TABLE IF EXISTS t1;
747 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
748 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
749 SET GTID_NEXT = 'ANONYMOUS';
750 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
751 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
752 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
753 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
754 include/assert.inc [No warning or error should be generated.]
755 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
756 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
757 ROLLBACK;
758 SET GTID_NEXT = 'AUTOMATIC';
759 include/assert.inc [Both counters should be 0]
760 DROP TABLE IF EXISTS t1;
761 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
762 SET SQL_LOG_BIN = 1;
763 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF_PERMISSIVE GTID_NEXT=GTID ########
764 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
765 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
766 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
767 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
768 INSERT INTO nonempty_innodb VALUES (1);
769 INSERT INTO nonempty_myisam VALUES (1);
770 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
771 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
772 SET GTID_NEXT = 'GTID';
773 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
774 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
775 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
776 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
777 include/assert.inc [No warning or error should be generated.]
778 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
779 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
780 ROLLBACK;
781 SET GTID_NEXT = 'AUTOMATIC';
782 include/assert.inc [Both counters should be 0]
783 DROP TABLE IF EXISTS t1;
784 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
785 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
786 SET GTID_NEXT = 'GTID';
787 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
788 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
789 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
790 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
791 include/assert.inc [No warning or error should be generated.]
792 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
793 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
794 ROLLBACK;
795 SET GTID_NEXT = 'AUTOMATIC';
796 include/assert.inc [Both counters should be 0]
797 DROP TABLE IF EXISTS t1;
798 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
799 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
800 SET GTID_NEXT = 'GTID';
801 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
802 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
803 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
804 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
805 include/assert.inc [No warning or error should be generated.]
806 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
807 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
808 ROLLBACK;
809 SET GTID_NEXT = 'AUTOMATIC';
810 include/assert.inc [Both counters should be 0]
811 DROP TABLE IF EXISTS t1;
812 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
813 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
814 SET GTID_NEXT = 'GTID';
815 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
816 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
817 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
818 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
819 include/assert.inc [No warning or error should be generated.]
820 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
821 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
822 ROLLBACK;
823 SET GTID_NEXT = 'AUTOMATIC';
824 include/assert.inc [Both counters should be 0]
825 DROP TABLE IF EXISTS t1;
826 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
827 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
828 SET GTID_NEXT = 'GTID';
829 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
830 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
831 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
832 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
833 include/assert.inc [No warning or error should be generated.]
834 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
835 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
836 ROLLBACK;
837 SET GTID_NEXT = 'AUTOMATIC';
838 include/assert.inc [Both counters should be 0]
839 DROP TABLE IF EXISTS t1;
840 SET SQL_LOG_BIN = 0;
841 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
842 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
843 SET GTID_NEXT = 'GTID';
844 [START] CREATE TABLE t1 (a INT) SELECT 1;
845 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
846 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
847 [END] CREATE TABLE t1 (a INT) SELECT 1;
848 include/assert.inc [No warning or error should be generated.]
849 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
850 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
851 ROLLBACK;
852 SET GTID_NEXT = 'AUTOMATIC';
853 include/assert.inc [Both counters should be 0]
854 DROP TABLE IF EXISTS t1;
855 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
856 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
857 SET GTID_NEXT = 'GTID';
858 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
859 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
860 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
861 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
862 include/assert.inc [No warning or error should be generated.]
863 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
864 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
865 ROLLBACK;
866 SET GTID_NEXT = 'AUTOMATIC';
867 include/assert.inc [Both counters should be 0]
868 DROP TABLE IF EXISTS t1;
869 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
870 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
871 SET GTID_NEXT = 'GTID';
872 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
873 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
874 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
875 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
876 include/assert.inc [No warning or error should be generated.]
877 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
878 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
879 ROLLBACK;
880 SET GTID_NEXT = 'AUTOMATIC';
881 include/assert.inc [Both counters should be 0]
882 DROP TABLE IF EXISTS t1;
883 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
884 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
885 SET GTID_NEXT = 'GTID';
886 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
887 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
888 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
889 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
890 include/assert.inc [No warning or error should be generated.]
891 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
892 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
893 ROLLBACK;
894 SET GTID_NEXT = 'AUTOMATIC';
895 include/assert.inc [Both counters should be 0]
896 DROP TABLE IF EXISTS t1;
897 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
898 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
899 SET GTID_NEXT = 'GTID';
900 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
901 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
902 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
903 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
904 include/assert.inc [No warning or error should be generated.]
905 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
906 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
907 ROLLBACK;
908 SET GTID_NEXT = 'AUTOMATIC';
909 include/assert.inc [Both counters should be 0]
910 DROP TABLE IF EXISTS t1;
911 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
912 SET SQL_LOG_BIN = 1;
913 SET GLOBAL GTID_MODE = 0;
914 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF GTID_NEXT=AUTOMATIC ########
915 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
916 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
917 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
918 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
919 INSERT INTO nonempty_innodb VALUES (1);
920 INSERT INTO nonempty_myisam VALUES (1);
921 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
922 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
923 SET GTID_NEXT = 'AUTOMATIC';
924 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
925 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
926 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
927 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
928 include/assert.inc [No warning or error should be generated.]
929 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
930 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
931 ROLLBACK;
932 SET GTID_NEXT = 'AUTOMATIC';
933 include/assert.inc [Both counters should be 0]
934 DROP TABLE IF EXISTS t1;
935 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
936 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
937 SET GTID_NEXT = 'AUTOMATIC';
938 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
939 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
940 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
941 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
942 include/assert.inc [No warning or error should be generated.]
943 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
944 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
945 ROLLBACK;
946 SET GTID_NEXT = 'AUTOMATIC';
947 include/assert.inc [Both counters should be 0]
948 DROP TABLE IF EXISTS t1;
949 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
950 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
951 SET GTID_NEXT = 'AUTOMATIC';
952 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
953 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
954 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
955 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
956 include/assert.inc [No warning or error should be generated.]
957 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
958 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
959 ROLLBACK;
960 SET GTID_NEXT = 'AUTOMATIC';
961 include/assert.inc [Both counters should be 0]
962 DROP TABLE IF EXISTS t1;
963 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
964 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
965 SET GTID_NEXT = 'AUTOMATIC';
966 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
967 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
968 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
969 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
970 include/assert.inc [No warning or error should be generated.]
971 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
972 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
973 ROLLBACK;
974 SET GTID_NEXT = 'AUTOMATIC';
975 include/assert.inc [Both counters should be 0]
976 DROP TABLE IF EXISTS t1;
977 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
978 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
979 SET GTID_NEXT = 'AUTOMATIC';
980 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
981 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
982 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
983 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
984 include/assert.inc [No warning or error should be generated.]
985 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
986 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
987 ROLLBACK;
988 SET GTID_NEXT = 'AUTOMATIC';
989 include/assert.inc [Both counters should be 0]
990 DROP TABLE IF EXISTS t1;
991 SET SQL_LOG_BIN = 0;
992 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
993 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
994 SET GTID_NEXT = 'AUTOMATIC';
995 [START] CREATE TABLE t1 (a INT) SELECT 1;
996 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
997 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
998 [END] CREATE TABLE t1 (a INT) SELECT 1;
999 include/assert.inc [No warning or error should be generated.]
1000 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1001 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1002 ROLLBACK;
1003 SET GTID_NEXT = 'AUTOMATIC';
1004 include/assert.inc [Both counters should be 0]
1005 DROP TABLE IF EXISTS t1;
1006 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
1007 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
1008 SET GTID_NEXT = 'AUTOMATIC';
1009 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1010 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1011 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1012 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1013 include/assert.inc [No warning or error should be generated.]
1014 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1015 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1016 ROLLBACK;
1017 SET GTID_NEXT = 'AUTOMATIC';
1018 include/assert.inc [Both counters should be 0]
1019 DROP TABLE IF EXISTS t1;
1020 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
1021 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
1022 SET GTID_NEXT = 'AUTOMATIC';
1023 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1024 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1025 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1026 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1027 include/assert.inc [No warning or error should be generated.]
1028 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1029 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1030 ROLLBACK;
1031 SET GTID_NEXT = 'AUTOMATIC';
1032 include/assert.inc [Both counters should be 0]
1033 DROP TABLE IF EXISTS t1;
1034 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
1035 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
1036 SET GTID_NEXT = 'AUTOMATIC';
1037 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1038 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1039 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1040 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1041 include/assert.inc [No warning or error should be generated.]
1042 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1043 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1044 ROLLBACK;
1045 SET GTID_NEXT = 'AUTOMATIC';
1046 include/assert.inc [Both counters should be 0]
1047 DROP TABLE IF EXISTS t1;
1048 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
1049 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
1050 SET GTID_NEXT = 'AUTOMATIC';
1051 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1052 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1053 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1054 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1055 include/assert.inc [No warning or error should be generated.]
1056 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1057 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1058 ROLLBACK;
1059 SET GTID_NEXT = 'AUTOMATIC';
1060 include/assert.inc [Both counters should be 0]
1061 DROP TABLE IF EXISTS t1;
1062 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
1063 SET SQL_LOG_BIN = 1;
1064 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF GTID_NEXT=ANONYMOUS ########
1065 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
1066 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
1067 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
1068 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
1069 INSERT INTO nonempty_innodb VALUES (1);
1070 INSERT INTO nonempty_myisam VALUES (1);
1071 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
1072 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
1073 SET GTID_NEXT = 'ANONYMOUS';
1074 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1075 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1076 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1077 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1078 include/assert.inc [No warning or error should be generated.]
1079 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1080 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1081 ROLLBACK;
1082 SET GTID_NEXT = 'AUTOMATIC';
1083 include/assert.inc [Both counters should be 0]
1084 DROP TABLE IF EXISTS t1;
1085 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
1086 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
1087 SET GTID_NEXT = 'ANONYMOUS';
1088 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1089 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1090 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1091 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1092 include/assert.inc [No warning or error should be generated.]
1093 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1094 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1095 ROLLBACK;
1096 SET GTID_NEXT = 'AUTOMATIC';
1097 include/assert.inc [Both counters should be 0]
1098 DROP TABLE IF EXISTS t1;
1099 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
1100 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
1101 SET GTID_NEXT = 'ANONYMOUS';
1102 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1103 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1104 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1105 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1106 include/assert.inc [No warning or error should be generated.]
1107 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1108 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1109 ROLLBACK;
1110 SET GTID_NEXT = 'AUTOMATIC';
1111 include/assert.inc [Both counters should be 0]
1112 DROP TABLE IF EXISTS t1;
1113 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
1114 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
1115 SET GTID_NEXT = 'ANONYMOUS';
1116 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1117 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1118 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1119 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1120 include/assert.inc [No warning or error should be generated.]
1121 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1122 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1123 ROLLBACK;
1124 SET GTID_NEXT = 'AUTOMATIC';
1125 include/assert.inc [Both counters should be 0]
1126 DROP TABLE IF EXISTS t1;
1127 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
1128 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
1129 SET GTID_NEXT = 'ANONYMOUS';
1130 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1131 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1132 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1133 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1134 include/assert.inc [No warning or error should be generated.]
1135 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1136 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1137 ROLLBACK;
1138 SET GTID_NEXT = 'AUTOMATIC';
1139 include/assert.inc [Both counters should be 0]
1140 DROP TABLE IF EXISTS t1;
1141 SET SQL_LOG_BIN = 0;
1142 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
1143 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
1144 SET GTID_NEXT = 'ANONYMOUS';
1145 [START] CREATE TABLE t1 (a INT) SELECT 1;
1146 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1147 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1148 [END] CREATE TABLE t1 (a INT) SELECT 1;
1149 include/assert.inc [No warning or error should be generated.]
1150 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1151 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1152 ROLLBACK;
1153 SET GTID_NEXT = 'AUTOMATIC';
1154 include/assert.inc [Both counters should be 0]
1155 DROP TABLE IF EXISTS t1;
1156 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
1157 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
1158 SET GTID_NEXT = 'ANONYMOUS';
1159 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1160 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1161 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1162 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1163 include/assert.inc [No warning or error should be generated.]
1164 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1165 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1166 ROLLBACK;
1167 SET GTID_NEXT = 'AUTOMATIC';
1168 include/assert.inc [Both counters should be 0]
1169 DROP TABLE IF EXISTS t1;
1170 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
1171 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
1172 SET GTID_NEXT = 'ANONYMOUS';
1173 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1174 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1175 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1176 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1177 include/assert.inc [No warning or error should be generated.]
1178 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1179 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1180 ROLLBACK;
1181 SET GTID_NEXT = 'AUTOMATIC';
1182 include/assert.inc [Both counters should be 0]
1183 DROP TABLE IF EXISTS t1;
1184 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
1185 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
1186 SET GTID_NEXT = 'ANONYMOUS';
1187 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1188 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1189 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1190 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1191 include/assert.inc [No warning or error should be generated.]
1192 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1193 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1194 ROLLBACK;
1195 SET GTID_NEXT = 'AUTOMATIC';
1196 include/assert.inc [Both counters should be 0]
1197 DROP TABLE IF EXISTS t1;
1198 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
1199 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
1200 SET GTID_NEXT = 'ANONYMOUS';
1201 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1202 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1203 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1204 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1205 include/assert.inc [No warning or error should be generated.]
1206 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1207 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1208 ROLLBACK;
1209 SET GTID_NEXT = 'AUTOMATIC';
1210 include/assert.inc [Both counters should be 0]
1211 DROP TABLE IF EXISTS t1;
1212 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
1213 SET SQL_LOG_BIN = 1;
1214 SET GLOBAL ENFORCE_GTID_CONSISTENCY = 1;
1215 SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
1216 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
1217 SET GLOBAL GTID_MODE = ON;
1218 SET GLOBAL GTID_MODE = 3;
1219 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON GTID_NEXT=AUTOMATIC ########
1220 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
1221 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
1222 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
1223 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
1224 INSERT INTO nonempty_innodb VALUES (1);
1225 INSERT INTO nonempty_myisam VALUES (1);
1226 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
1227 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
1228 SET GTID_NEXT = 'AUTOMATIC';
1229 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1230 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1231 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1232 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1233 include/assert.inc [No warning or error should be generated.]
1234 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1235 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1236 ROLLBACK;
1237 SET GTID_NEXT = 'AUTOMATIC';
1238 include/assert.inc [Both counters should be 0]
1239 DROP TABLE IF EXISTS t1;
1240 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
1241 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
1242 SET GTID_NEXT = 'AUTOMATIC';
1243 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1244 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1245 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1246 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1247 include/assert.inc [No warning or error should be generated.]
1248 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1249 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1250 ROLLBACK;
1251 SET GTID_NEXT = 'AUTOMATIC';
1252 include/assert.inc [Both counters should be 0]
1253 DROP TABLE IF EXISTS t1;
1254 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
1255 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
1256 SET GTID_NEXT = 'AUTOMATIC';
1257 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1258 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1259 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1260 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1261 include/assert.inc [No warning or error should be generated.]
1262 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1263 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1264 ROLLBACK;
1265 SET GTID_NEXT = 'AUTOMATIC';
1266 include/assert.inc [Both counters should be 0]
1267 DROP TABLE IF EXISTS t1;
1268 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
1269 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
1270 SET GTID_NEXT = 'AUTOMATIC';
1271 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1272 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1273 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1274 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1275 include/assert.inc [No warning or error should be generated.]
1276 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1277 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1278 ROLLBACK;
1279 SET GTID_NEXT = 'AUTOMATIC';
1280 include/assert.inc [Both counters should be 0]
1281 DROP TABLE IF EXISTS t1;
1282 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
1283 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
1284 SET GTID_NEXT = 'AUTOMATIC';
1285 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1286 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1287 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1288 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1289 include/assert.inc [No warning or error should be generated.]
1290 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1291 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1292 ROLLBACK;
1293 SET GTID_NEXT = 'AUTOMATIC';
1294 include/assert.inc [Both counters should be 0]
1295 DROP TABLE IF EXISTS t1;
1296 SET SQL_LOG_BIN = 0;
1297 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
1298 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
1299 SET GTID_NEXT = 'AUTOMATIC';
1300 [START] CREATE TABLE t1 (a INT) SELECT 1;
1301 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1302 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1303 [END] CREATE TABLE t1 (a INT) SELECT 1;
1304 include/assert.inc [No warning or error should be generated.]
1305 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1306 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1307 ROLLBACK;
1308 SET GTID_NEXT = 'AUTOMATIC';
1309 include/assert.inc [Both counters should be 0]
1310 DROP TABLE IF EXISTS t1;
1311 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
1312 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
1313 SET GTID_NEXT = 'AUTOMATIC';
1314 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1315 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1316 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1317 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1318 include/assert.inc [No warning or error should be generated.]
1319 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1320 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1321 ROLLBACK;
1322 SET GTID_NEXT = 'AUTOMATIC';
1323 include/assert.inc [Both counters should be 0]
1324 DROP TABLE IF EXISTS t1;
1325 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
1326 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
1327 SET GTID_NEXT = 'AUTOMATIC';
1328 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1329 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1330 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1331 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1332 include/assert.inc [No warning or error should be generated.]
1333 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1334 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1335 ROLLBACK;
1336 SET GTID_NEXT = 'AUTOMATIC';
1337 include/assert.inc [Both counters should be 0]
1338 DROP TABLE IF EXISTS t1;
1339 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
1340 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
1341 SET GTID_NEXT = 'AUTOMATIC';
1342 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1343 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1344 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1345 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1346 include/assert.inc [No warning or error should be generated.]
1347 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1348 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1349 ROLLBACK;
1350 SET GTID_NEXT = 'AUTOMATIC';
1351 include/assert.inc [Both counters should be 0]
1352 DROP TABLE IF EXISTS t1;
1353 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
1354 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
1355 SET GTID_NEXT = 'AUTOMATIC';
1356 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1357 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1358 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1359 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1360 include/assert.inc [No warning or error should be generated.]
1361 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1362 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1363 ROLLBACK;
1364 SET GTID_NEXT = 'AUTOMATIC';
1365 include/assert.inc [Both counters should be 0]
1366 DROP TABLE IF EXISTS t1;
1367 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
1368 SET SQL_LOG_BIN = 1;
1369 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON GTID_NEXT=GTID ########
1370 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
1371 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
1372 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
1373 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
1374 INSERT INTO nonempty_innodb VALUES (1);
1375 INSERT INTO nonempty_myisam VALUES (1);
1376 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
1377 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1378 SET GTID_NEXT = 'GTID';
1379 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1380 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1381 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1382 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1383 include/assert.inc [No warning or error should be generated.]
1384 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1385 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1386 ROLLBACK;
1387 SET GTID_NEXT = 'AUTOMATIC';
1388 include/assert.inc [Both counters should be 0]
1389 DROP TABLE IF EXISTS t1;
1390 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
1391 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1392 SET GTID_NEXT = 'GTID';
1393 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1394 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1395 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1396 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1397 include/assert.inc [No warning or error should be generated.]
1398 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1399 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1400 ROLLBACK;
1401 SET GTID_NEXT = 'AUTOMATIC';
1402 include/assert.inc [Both counters should be 0]
1403 DROP TABLE IF EXISTS t1;
1404 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
1405 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1406 SET GTID_NEXT = 'GTID';
1407 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1408 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1409 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1410 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1411 include/assert.inc [No warning or error should be generated.]
1412 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1413 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1414 ROLLBACK;
1415 SET GTID_NEXT = 'AUTOMATIC';
1416 include/assert.inc [Both counters should be 0]
1417 DROP TABLE IF EXISTS t1;
1418 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
1419 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1420 SET GTID_NEXT = 'GTID';
1421 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1422 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1423 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1424 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1425 include/assert.inc [No warning or error should be generated.]
1426 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1427 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1428 ROLLBACK;
1429 SET GTID_NEXT = 'AUTOMATIC';
1430 include/assert.inc [Both counters should be 0]
1431 DROP TABLE IF EXISTS t1;
1432 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
1433 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1434 SET GTID_NEXT = 'GTID';
1435 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1436 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1437 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1438 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1439 include/assert.inc [No warning or error should be generated.]
1440 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1441 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1442 ROLLBACK;
1443 SET GTID_NEXT = 'AUTOMATIC';
1444 include/assert.inc [Both counters should be 0]
1445 DROP TABLE IF EXISTS t1;
1446 SET SQL_LOG_BIN = 0;
1447 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
1448 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1449 SET GTID_NEXT = 'GTID';
1450 [START] CREATE TABLE t1 (a INT) SELECT 1;
1451 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1452 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1453 [END] CREATE TABLE t1 (a INT) SELECT 1;
1454 include/assert.inc [No warning or error should be generated.]
1455 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1456 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1457 ROLLBACK;
1458 SET GTID_NEXT = 'AUTOMATIC';
1459 include/assert.inc [Both counters should be 0]
1460 DROP TABLE IF EXISTS t1;
1461 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
1462 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1463 SET GTID_NEXT = 'GTID';
1464 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1465 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1466 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1467 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1468 include/assert.inc [No warning or error should be generated.]
1469 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1470 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1471 ROLLBACK;
1472 SET GTID_NEXT = 'AUTOMATIC';
1473 include/assert.inc [Both counters should be 0]
1474 DROP TABLE IF EXISTS t1;
1475 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
1476 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1477 SET GTID_NEXT = 'GTID';
1478 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1479 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1480 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1481 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1482 include/assert.inc [No warning or error should be generated.]
1483 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1484 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1485 ROLLBACK;
1486 SET GTID_NEXT = 'AUTOMATIC';
1487 include/assert.inc [Both counters should be 0]
1488 DROP TABLE IF EXISTS t1;
1489 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
1490 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1491 SET GTID_NEXT = 'GTID';
1492 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1493 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1494 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1495 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1496 include/assert.inc [No warning or error should be generated.]
1497 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1498 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1499 ROLLBACK;
1500 SET GTID_NEXT = 'AUTOMATIC';
1501 include/assert.inc [Both counters should be 0]
1502 DROP TABLE IF EXISTS t1;
1503 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
1504 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1505 SET GTID_NEXT = 'GTID';
1506 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1507 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1508 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1509 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1510 include/assert.inc [No warning or error should be generated.]
1511 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1512 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1513 ROLLBACK;
1514 SET GTID_NEXT = 'AUTOMATIC';
1515 include/assert.inc [Both counters should be 0]
1516 DROP TABLE IF EXISTS t1;
1517 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
1518 SET SQL_LOG_BIN = 1;
1519 SET GLOBAL GTID_MODE = 2;
1520 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON_PERMISSIVE GTID_NEXT=AUTOMATIC ########
1521 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
1522 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
1523 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
1524 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
1525 INSERT INTO nonempty_innodb VALUES (1);
1526 INSERT INTO nonempty_myisam VALUES (1);
1527 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
1528 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1529 SET GTID_NEXT = 'AUTOMATIC';
1530 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1531 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1532 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1533 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1534 include/assert.inc [No warning or error should be generated.]
1535 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1536 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1537 ROLLBACK;
1538 SET GTID_NEXT = 'AUTOMATIC';
1539 include/assert.inc [Both counters should be 0]
1540 DROP TABLE IF EXISTS t1;
1541 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
1542 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1543 SET GTID_NEXT = 'AUTOMATIC';
1544 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1545 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1546 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1547 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1548 include/assert.inc [No warning or error should be generated.]
1549 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1550 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1551 ROLLBACK;
1552 SET GTID_NEXT = 'AUTOMATIC';
1553 include/assert.inc [Both counters should be 0]
1554 DROP TABLE IF EXISTS t1;
1555 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
1556 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1557 SET GTID_NEXT = 'AUTOMATIC';
1558 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1559 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1560 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1561 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1562 include/assert.inc [No warning or error should be generated.]
1563 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1564 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1565 ROLLBACK;
1566 SET GTID_NEXT = 'AUTOMATIC';
1567 include/assert.inc [Both counters should be 0]
1568 DROP TABLE IF EXISTS t1;
1569 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
1570 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1571 SET GTID_NEXT = 'AUTOMATIC';
1572 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1573 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1574 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1575 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1576 include/assert.inc [No warning or error should be generated.]
1577 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1578 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1579 ROLLBACK;
1580 SET GTID_NEXT = 'AUTOMATIC';
1581 include/assert.inc [Both counters should be 0]
1582 DROP TABLE IF EXISTS t1;
1583 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
1584 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1585 SET GTID_NEXT = 'AUTOMATIC';
1586 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1587 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1588 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1589 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1590 include/assert.inc [No warning or error should be generated.]
1591 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1592 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1593 ROLLBACK;
1594 SET GTID_NEXT = 'AUTOMATIC';
1595 include/assert.inc [Both counters should be 0]
1596 DROP TABLE IF EXISTS t1;
1597 SET SQL_LOG_BIN = 0;
1598 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
1599 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1600 SET GTID_NEXT = 'AUTOMATIC';
1601 [START] CREATE TABLE t1 (a INT) SELECT 1;
1602 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1603 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1604 [END] CREATE TABLE t1 (a INT) SELECT 1;
1605 include/assert.inc [No warning or error should be generated.]
1606 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1607 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1608 ROLLBACK;
1609 SET GTID_NEXT = 'AUTOMATIC';
1610 include/assert.inc [Both counters should be 0]
1611 DROP TABLE IF EXISTS t1;
1612 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
1613 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1614 SET GTID_NEXT = 'AUTOMATIC';
1615 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1616 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1617 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1618 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1619 include/assert.inc [No warning or error should be generated.]
1620 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1621 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1622 ROLLBACK;
1623 SET GTID_NEXT = 'AUTOMATIC';
1624 include/assert.inc [Both counters should be 0]
1625 DROP TABLE IF EXISTS t1;
1626 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
1627 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1628 SET GTID_NEXT = 'AUTOMATIC';
1629 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1630 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1631 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1632 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1633 include/assert.inc [No warning or error should be generated.]
1634 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1635 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1636 ROLLBACK;
1637 SET GTID_NEXT = 'AUTOMATIC';
1638 include/assert.inc [Both counters should be 0]
1639 DROP TABLE IF EXISTS t1;
1640 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
1641 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1642 SET GTID_NEXT = 'AUTOMATIC';
1643 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1644 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1645 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1646 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1647 include/assert.inc [No warning or error should be generated.]
1648 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1649 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1650 ROLLBACK;
1651 SET GTID_NEXT = 'AUTOMATIC';
1652 include/assert.inc [Both counters should be 0]
1653 DROP TABLE IF EXISTS t1;
1654 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
1655 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1656 SET GTID_NEXT = 'AUTOMATIC';
1657 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1658 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1659 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1660 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1661 include/assert.inc [No warning or error should be generated.]
1662 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1663 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1664 ROLLBACK;
1665 SET GTID_NEXT = 'AUTOMATIC';
1666 include/assert.inc [Both counters should be 0]
1667 DROP TABLE IF EXISTS t1;
1668 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
1669 SET SQL_LOG_BIN = 1;
1670 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON_PERMISSIVE GTID_NEXT=ANONYMOUS ########
1671 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
1672 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
1673 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
1674 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
1675 INSERT INTO nonempty_innodb VALUES (1);
1676 INSERT INTO nonempty_myisam VALUES (1);
1677 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
1678 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1679 SET GTID_NEXT = 'ANONYMOUS';
1680 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1681 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1682 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1683 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1684 include/assert.inc [No warning or error should be generated.]
1685 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1686 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1687 ROLLBACK;
1688 SET GTID_NEXT = 'AUTOMATIC';
1689 include/assert.inc [Both counters should be 0]
1690 DROP TABLE IF EXISTS t1;
1691 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
1692 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1693 SET GTID_NEXT = 'ANONYMOUS';
1694 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1695 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1696 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1697 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1698 include/assert.inc [No warning or error should be generated.]
1699 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1700 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1701 ROLLBACK;
1702 SET GTID_NEXT = 'AUTOMATIC';
1703 include/assert.inc [Both counters should be 0]
1704 DROP TABLE IF EXISTS t1;
1705 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
1706 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1707 SET GTID_NEXT = 'ANONYMOUS';
1708 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1709 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1710 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1711 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1712 include/assert.inc [No warning or error should be generated.]
1713 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1714 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1715 ROLLBACK;
1716 SET GTID_NEXT = 'AUTOMATIC';
1717 include/assert.inc [Both counters should be 0]
1718 DROP TABLE IF EXISTS t1;
1719 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
1720 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1721 SET GTID_NEXT = 'ANONYMOUS';
1722 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1723 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1724 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1725 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1726 include/assert.inc [No warning or error should be generated.]
1727 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1728 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1729 ROLLBACK;
1730 SET GTID_NEXT = 'AUTOMATIC';
1731 include/assert.inc [Both counters should be 0]
1732 DROP TABLE IF EXISTS t1;
1733 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
1734 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1735 SET GTID_NEXT = 'ANONYMOUS';
1736 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1737 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1738 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1739 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1740 include/assert.inc [No warning or error should be generated.]
1741 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1742 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1743 ROLLBACK;
1744 SET GTID_NEXT = 'AUTOMATIC';
1745 include/assert.inc [Both counters should be 0]
1746 DROP TABLE IF EXISTS t1;
1747 SET SQL_LOG_BIN = 0;
1748 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
1749 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1750 SET GTID_NEXT = 'ANONYMOUS';
1751 [START] CREATE TABLE t1 (a INT) SELECT 1;
1752 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1753 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1754 [END] CREATE TABLE t1 (a INT) SELECT 1;
1755 include/assert.inc [No warning or error should be generated.]
1756 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1757 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1758 ROLLBACK;
1759 SET GTID_NEXT = 'AUTOMATIC';
1760 include/assert.inc [Both counters should be 0]
1761 DROP TABLE IF EXISTS t1;
1762 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
1763 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1764 SET GTID_NEXT = 'ANONYMOUS';
1765 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1766 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1767 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1768 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1769 include/assert.inc [No warning or error should be generated.]
1770 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1771 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1772 ROLLBACK;
1773 SET GTID_NEXT = 'AUTOMATIC';
1774 include/assert.inc [Both counters should be 0]
1775 DROP TABLE IF EXISTS t1;
1776 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
1777 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1778 SET GTID_NEXT = 'ANONYMOUS';
1779 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1780 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1781 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1782 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1783 include/assert.inc [No warning or error should be generated.]
1784 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1785 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1786 ROLLBACK;
1787 SET GTID_NEXT = 'AUTOMATIC';
1788 include/assert.inc [Both counters should be 0]
1789 DROP TABLE IF EXISTS t1;
1790 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
1791 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1792 SET GTID_NEXT = 'ANONYMOUS';
1793 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1794 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1795 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1796 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1797 include/assert.inc [No warning or error should be generated.]
1798 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1799 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1800 ROLLBACK;
1801 SET GTID_NEXT = 'AUTOMATIC';
1802 include/assert.inc [Both counters should be 0]
1803 DROP TABLE IF EXISTS t1;
1804 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
1805 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1806 SET GTID_NEXT = 'ANONYMOUS';
1807 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1808 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1809 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1810 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1811 include/assert.inc [No warning or error should be generated.]
1812 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1813 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1814 ROLLBACK;
1815 SET GTID_NEXT = 'AUTOMATIC';
1816 include/assert.inc [Both counters should be 0]
1817 DROP TABLE IF EXISTS t1;
1818 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
1819 SET SQL_LOG_BIN = 1;
1820 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON_PERMISSIVE GTID_NEXT=GTID ########
1821 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
1822 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
1823 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
1824 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
1825 INSERT INTO nonempty_innodb VALUES (1);
1826 INSERT INTO nonempty_myisam VALUES (1);
1827 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
1828 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1829 SET GTID_NEXT = 'GTID';
1830 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1831 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1832 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1833 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1834 include/assert.inc [No warning or error should be generated.]
1835 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1836 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1837 ROLLBACK;
1838 SET GTID_NEXT = 'AUTOMATIC';
1839 include/assert.inc [Both counters should be 0]
1840 DROP TABLE IF EXISTS t1;
1841 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
1842 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1843 SET GTID_NEXT = 'GTID';
1844 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1845 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1846 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1847 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1848 include/assert.inc [No warning or error should be generated.]
1849 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1850 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1851 ROLLBACK;
1852 SET GTID_NEXT = 'AUTOMATIC';
1853 include/assert.inc [Both counters should be 0]
1854 DROP TABLE IF EXISTS t1;
1855 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
1856 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1857 SET GTID_NEXT = 'GTID';
1858 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1859 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1860 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1861 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1862 include/assert.inc [No warning or error should be generated.]
1863 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1864 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1865 ROLLBACK;
1866 SET GTID_NEXT = 'AUTOMATIC';
1867 include/assert.inc [Both counters should be 0]
1868 DROP TABLE IF EXISTS t1;
1869 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
1870 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1871 SET GTID_NEXT = 'GTID';
1872 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1873 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1874 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1875 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
1876 include/assert.inc [No warning or error should be generated.]
1877 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1878 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1879 ROLLBACK;
1880 SET GTID_NEXT = 'AUTOMATIC';
1881 include/assert.inc [Both counters should be 0]
1882 DROP TABLE IF EXISTS t1;
1883 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
1884 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1885 SET GTID_NEXT = 'GTID';
1886 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1887 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1888 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1889 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
1890 include/assert.inc [No warning or error should be generated.]
1891 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1892 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1893 ROLLBACK;
1894 SET GTID_NEXT = 'AUTOMATIC';
1895 include/assert.inc [Both counters should be 0]
1896 DROP TABLE IF EXISTS t1;
1897 SET SQL_LOG_BIN = 0;
1898 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
1899 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1900 SET GTID_NEXT = 'GTID';
1901 [START] CREATE TABLE t1 (a INT) SELECT 1;
1902 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1903 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1904 [END] CREATE TABLE t1 (a INT) SELECT 1;
1905 include/assert.inc [No warning or error should be generated.]
1906 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1907 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1908 ROLLBACK;
1909 SET GTID_NEXT = 'AUTOMATIC';
1910 include/assert.inc [Both counters should be 0]
1911 DROP TABLE IF EXISTS t1;
1912 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
1913 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1914 SET GTID_NEXT = 'GTID';
1915 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1916 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1917 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1918 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1919 include/assert.inc [No warning or error should be generated.]
1920 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1921 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1922 ROLLBACK;
1923 SET GTID_NEXT = 'AUTOMATIC';
1924 include/assert.inc [Both counters should be 0]
1925 DROP TABLE IF EXISTS t1;
1926 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
1927 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1928 SET GTID_NEXT = 'GTID';
1929 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1930 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1931 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1932 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
1933 include/assert.inc [No warning or error should be generated.]
1934 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1935 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1936 ROLLBACK;
1937 SET GTID_NEXT = 'AUTOMATIC';
1938 include/assert.inc [Both counters should be 0]
1939 DROP TABLE IF EXISTS t1;
1940 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
1941 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1942 SET GTID_NEXT = 'GTID';
1943 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1944 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1945 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1946 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
1947 include/assert.inc [No warning or error should be generated.]
1948 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1949 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1950 ROLLBACK;
1951 SET GTID_NEXT = 'AUTOMATIC';
1952 include/assert.inc [Both counters should be 0]
1953 DROP TABLE IF EXISTS t1;
1954 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
1955 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1956 SET GTID_NEXT = 'GTID';
1957 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1958 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1959 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1960 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
1961 include/assert.inc [No warning or error should be generated.]
1962 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1963 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1964 ROLLBACK;
1965 SET GTID_NEXT = 'AUTOMATIC';
1966 include/assert.inc [Both counters should be 0]
1967 DROP TABLE IF EXISTS t1;
1968 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
1969 SET SQL_LOG_BIN = 1;
1970 SET GLOBAL GTID_MODE = 1;
1971 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF_PERMISSIVE GTID_NEXT=AUTOMATIC ########
1972 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
1973 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
1974 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
1975 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
1976 INSERT INTO nonempty_innodb VALUES (1);
1977 INSERT INTO nonempty_myisam VALUES (1);
1978 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
1979 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
1980 SET GTID_NEXT = 'AUTOMATIC';
1981 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1982 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1983 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1984 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
1985 include/assert.inc [No warning or error should be generated.]
1986 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1987 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1988 ROLLBACK;
1989 SET GTID_NEXT = 'AUTOMATIC';
1990 include/assert.inc [Both counters should be 0]
1991 DROP TABLE IF EXISTS t1;
1992 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
1993 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
1994 SET GTID_NEXT = 'AUTOMATIC';
1995 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1996 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1997 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1998 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
1999 include/assert.inc [No warning or error should be generated.]
2000 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2001 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2002 ROLLBACK;
2003 SET GTID_NEXT = 'AUTOMATIC';
2004 include/assert.inc [Both counters should be 0]
2005 DROP TABLE IF EXISTS t1;
2006 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
2007 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
2008 SET GTID_NEXT = 'AUTOMATIC';
2009 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2010 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2011 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2012 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2013 include/assert.inc [No warning or error should be generated.]
2014 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2015 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2016 ROLLBACK;
2017 SET GTID_NEXT = 'AUTOMATIC';
2018 include/assert.inc [Both counters should be 0]
2019 DROP TABLE IF EXISTS t1;
2020 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
2021 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
2022 SET GTID_NEXT = 'AUTOMATIC';
2023 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2024 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2025 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2026 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2027 include/assert.inc [No warning or error should be generated.]
2028 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2029 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2030 ROLLBACK;
2031 SET GTID_NEXT = 'AUTOMATIC';
2032 include/assert.inc [Both counters should be 0]
2033 DROP TABLE IF EXISTS t1;
2034 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
2035 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
2036 SET GTID_NEXT = 'AUTOMATIC';
2037 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2038 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2039 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2040 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2041 include/assert.inc [No warning or error should be generated.]
2042 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2043 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2044 ROLLBACK;
2045 SET GTID_NEXT = 'AUTOMATIC';
2046 include/assert.inc [Both counters should be 0]
2047 DROP TABLE IF EXISTS t1;
2048 SET SQL_LOG_BIN = 0;
2049 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
2050 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
2051 SET GTID_NEXT = 'AUTOMATIC';
2052 [START] CREATE TABLE t1 (a INT) SELECT 1;
2053 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2054 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2055 [END] CREATE TABLE t1 (a INT) SELECT 1;
2056 include/assert.inc [No warning or error should be generated.]
2057 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2058 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2059 ROLLBACK;
2060 SET GTID_NEXT = 'AUTOMATIC';
2061 include/assert.inc [Both counters should be 0]
2062 DROP TABLE IF EXISTS t1;
2063 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
2064 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
2065 SET GTID_NEXT = 'AUTOMATIC';
2066 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2067 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2068 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2069 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2070 include/assert.inc [No warning or error should be generated.]
2071 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2072 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2073 ROLLBACK;
2074 SET GTID_NEXT = 'AUTOMATIC';
2075 include/assert.inc [Both counters should be 0]
2076 DROP TABLE IF EXISTS t1;
2077 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
2078 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
2079 SET GTID_NEXT = 'AUTOMATIC';
2080 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2081 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2082 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2083 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2084 include/assert.inc [No warning or error should be generated.]
2085 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2086 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2087 ROLLBACK;
2088 SET GTID_NEXT = 'AUTOMATIC';
2089 include/assert.inc [Both counters should be 0]
2090 DROP TABLE IF EXISTS t1;
2091 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
2092 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
2093 SET GTID_NEXT = 'AUTOMATIC';
2094 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2095 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2096 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2097 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2098 include/assert.inc [No warning or error should be generated.]
2099 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2100 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2101 ROLLBACK;
2102 SET GTID_NEXT = 'AUTOMATIC';
2103 include/assert.inc [Both counters should be 0]
2104 DROP TABLE IF EXISTS t1;
2105 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
2106 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
2107 SET GTID_NEXT = 'AUTOMATIC';
2108 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2109 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2110 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2111 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2112 include/assert.inc [No warning or error should be generated.]
2113 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2114 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2115 ROLLBACK;
2116 SET GTID_NEXT = 'AUTOMATIC';
2117 include/assert.inc [Both counters should be 0]
2118 DROP TABLE IF EXISTS t1;
2119 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
2120 SET SQL_LOG_BIN = 1;
2121 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF_PERMISSIVE GTID_NEXT=ANONYMOUS ########
2122 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
2123 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
2124 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
2125 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
2126 INSERT INTO nonempty_innodb VALUES (1);
2127 INSERT INTO nonempty_myisam VALUES (1);
2128 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
2129 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
2130 SET GTID_NEXT = 'ANONYMOUS';
2131 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2132 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2133 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2134 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2135 include/assert.inc [No warning or error should be generated.]
2136 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2137 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2138 ROLLBACK;
2139 SET GTID_NEXT = 'AUTOMATIC';
2140 include/assert.inc [Both counters should be 0]
2141 DROP TABLE IF EXISTS t1;
2142 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
2143 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
2144 SET GTID_NEXT = 'ANONYMOUS';
2145 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2146 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2147 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2148 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2149 include/assert.inc [No warning or error should be generated.]
2150 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2151 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2152 ROLLBACK;
2153 SET GTID_NEXT = 'AUTOMATIC';
2154 include/assert.inc [Both counters should be 0]
2155 DROP TABLE IF EXISTS t1;
2156 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
2157 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
2158 SET GTID_NEXT = 'ANONYMOUS';
2159 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2160 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2161 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2162 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2163 include/assert.inc [No warning or error should be generated.]
2164 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2165 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2166 ROLLBACK;
2167 SET GTID_NEXT = 'AUTOMATIC';
2168 include/assert.inc [Both counters should be 0]
2169 DROP TABLE IF EXISTS t1;
2170 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
2171 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
2172 SET GTID_NEXT = 'ANONYMOUS';
2173 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2174 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2175 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2176 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2177 include/assert.inc [No warning or error should be generated.]
2178 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2179 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2180 ROLLBACK;
2181 SET GTID_NEXT = 'AUTOMATIC';
2182 include/assert.inc [Both counters should be 0]
2183 DROP TABLE IF EXISTS t1;
2184 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
2185 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
2186 SET GTID_NEXT = 'ANONYMOUS';
2187 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2188 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2189 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2190 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2191 include/assert.inc [No warning or error should be generated.]
2192 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2193 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2194 ROLLBACK;
2195 SET GTID_NEXT = 'AUTOMATIC';
2196 include/assert.inc [Both counters should be 0]
2197 DROP TABLE IF EXISTS t1;
2198 SET SQL_LOG_BIN = 0;
2199 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
2200 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
2201 SET GTID_NEXT = 'ANONYMOUS';
2202 [START] CREATE TABLE t1 (a INT) SELECT 1;
2203 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2204 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2205 [END] CREATE TABLE t1 (a INT) SELECT 1;
2206 include/assert.inc [No warning or error should be generated.]
2207 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2208 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2209 ROLLBACK;
2210 SET GTID_NEXT = 'AUTOMATIC';
2211 include/assert.inc [Both counters should be 0]
2212 DROP TABLE IF EXISTS t1;
2213 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
2214 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
2215 SET GTID_NEXT = 'ANONYMOUS';
2216 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2217 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2218 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2219 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2220 include/assert.inc [No warning or error should be generated.]
2221 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2222 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2223 ROLLBACK;
2224 SET GTID_NEXT = 'AUTOMATIC';
2225 include/assert.inc [Both counters should be 0]
2226 DROP TABLE IF EXISTS t1;
2227 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
2228 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
2229 SET GTID_NEXT = 'ANONYMOUS';
2230 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2231 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2232 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2233 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2234 include/assert.inc [No warning or error should be generated.]
2235 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2236 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2237 ROLLBACK;
2238 SET GTID_NEXT = 'AUTOMATIC';
2239 include/assert.inc [Both counters should be 0]
2240 DROP TABLE IF EXISTS t1;
2241 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
2242 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
2243 SET GTID_NEXT = 'ANONYMOUS';
2244 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2245 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2246 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2247 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2248 include/assert.inc [No warning or error should be generated.]
2249 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2250 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2251 ROLLBACK;
2252 SET GTID_NEXT = 'AUTOMATIC';
2253 include/assert.inc [Both counters should be 0]
2254 DROP TABLE IF EXISTS t1;
2255 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
2256 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
2257 SET GTID_NEXT = 'ANONYMOUS';
2258 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2259 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2260 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2261 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2262 include/assert.inc [No warning or error should be generated.]
2263 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2264 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2265 ROLLBACK;
2266 SET GTID_NEXT = 'AUTOMATIC';
2267 include/assert.inc [Both counters should be 0]
2268 DROP TABLE IF EXISTS t1;
2269 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
2270 SET SQL_LOG_BIN = 1;
2271 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF_PERMISSIVE GTID_NEXT=GTID ########
2272 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
2273 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
2274 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
2275 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
2276 INSERT INTO nonempty_innodb VALUES (1);
2277 INSERT INTO nonempty_myisam VALUES (1);
2278 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
2279 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
2280 SET GTID_NEXT = 'GTID';
2281 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2282 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2283 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2284 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2285 include/assert.inc [No warning or error should be generated.]
2286 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2287 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2288 ROLLBACK;
2289 SET GTID_NEXT = 'AUTOMATIC';
2290 include/assert.inc [Both counters should be 0]
2291 DROP TABLE IF EXISTS t1;
2292 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
2293 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
2294 SET GTID_NEXT = 'GTID';
2295 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2296 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2297 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2298 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2299 include/assert.inc [No warning or error should be generated.]
2300 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2301 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2302 ROLLBACK;
2303 SET GTID_NEXT = 'AUTOMATIC';
2304 include/assert.inc [Both counters should be 0]
2305 DROP TABLE IF EXISTS t1;
2306 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
2307 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
2308 SET GTID_NEXT = 'GTID';
2309 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2310 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2311 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2312 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2313 include/assert.inc [No warning or error should be generated.]
2314 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2315 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2316 ROLLBACK;
2317 SET GTID_NEXT = 'AUTOMATIC';
2318 include/assert.inc [Both counters should be 0]
2319 DROP TABLE IF EXISTS t1;
2320 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
2321 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
2322 SET GTID_NEXT = 'GTID';
2323 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2324 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2325 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2326 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2327 include/assert.inc [No warning or error should be generated.]
2328 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2329 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2330 ROLLBACK;
2331 SET GTID_NEXT = 'AUTOMATIC';
2332 include/assert.inc [Both counters should be 0]
2333 DROP TABLE IF EXISTS t1;
2334 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
2335 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
2336 SET GTID_NEXT = 'GTID';
2337 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2338 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2339 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2340 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2341 include/assert.inc [No warning or error should be generated.]
2342 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2343 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2344 ROLLBACK;
2345 SET GTID_NEXT = 'AUTOMATIC';
2346 include/assert.inc [Both counters should be 0]
2347 DROP TABLE IF EXISTS t1;
2348 SET SQL_LOG_BIN = 0;
2349 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
2350 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
2351 SET GTID_NEXT = 'GTID';
2352 [START] CREATE TABLE t1 (a INT) SELECT 1;
2353 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2354 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2355 [END] CREATE TABLE t1 (a INT) SELECT 1;
2356 include/assert.inc [No warning or error should be generated.]
2357 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2358 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2359 ROLLBACK;
2360 SET GTID_NEXT = 'AUTOMATIC';
2361 include/assert.inc [Both counters should be 0]
2362 DROP TABLE IF EXISTS t1;
2363 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
2364 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
2365 SET GTID_NEXT = 'GTID';
2366 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2367 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2368 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2369 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2370 include/assert.inc [No warning or error should be generated.]
2371 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2372 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2373 ROLLBACK;
2374 SET GTID_NEXT = 'AUTOMATIC';
2375 include/assert.inc [Both counters should be 0]
2376 DROP TABLE IF EXISTS t1;
2377 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
2378 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
2379 SET GTID_NEXT = 'GTID';
2380 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2381 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2382 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2383 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2384 include/assert.inc [No warning or error should be generated.]
2385 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2386 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2387 ROLLBACK;
2388 SET GTID_NEXT = 'AUTOMATIC';
2389 include/assert.inc [Both counters should be 0]
2390 DROP TABLE IF EXISTS t1;
2391 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
2392 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
2393 SET GTID_NEXT = 'GTID';
2394 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2395 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2396 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2397 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2398 include/assert.inc [No warning or error should be generated.]
2399 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2400 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2401 ROLLBACK;
2402 SET GTID_NEXT = 'AUTOMATIC';
2403 include/assert.inc [Both counters should be 0]
2404 DROP TABLE IF EXISTS t1;
2405 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
2406 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
2407 SET GTID_NEXT = 'GTID';
2408 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2409 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2410 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2411 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2412 include/assert.inc [No warning or error should be generated.]
2413 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2414 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2415 ROLLBACK;
2416 SET GTID_NEXT = 'AUTOMATIC';
2417 include/assert.inc [Both counters should be 0]
2418 DROP TABLE IF EXISTS t1;
2419 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
2420 SET SQL_LOG_BIN = 1;
2421 SET GLOBAL GTID_MODE = 0;
2422 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF GTID_NEXT=AUTOMATIC ########
2423 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
2424 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
2425 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
2426 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
2427 INSERT INTO nonempty_innodb VALUES (1);
2428 INSERT INTO nonempty_myisam VALUES (1);
2429 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
2430 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
2431 SET GTID_NEXT = 'AUTOMATIC';
2432 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2433 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2434 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2435 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2436 include/assert.inc [No warning or error should be generated.]
2437 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2438 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2439 ROLLBACK;
2440 SET GTID_NEXT = 'AUTOMATIC';
2441 include/assert.inc [Both counters should be 0]
2442 DROP TABLE IF EXISTS t1;
2443 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
2444 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
2445 SET GTID_NEXT = 'AUTOMATIC';
2446 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2447 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2448 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2449 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2450 include/assert.inc [No warning or error should be generated.]
2451 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2452 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2453 ROLLBACK;
2454 SET GTID_NEXT = 'AUTOMATIC';
2455 include/assert.inc [Both counters should be 0]
2456 DROP TABLE IF EXISTS t1;
2457 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
2458 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
2459 SET GTID_NEXT = 'AUTOMATIC';
2460 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2461 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2462 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2463 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2464 include/assert.inc [No warning or error should be generated.]
2465 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2466 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2467 ROLLBACK;
2468 SET GTID_NEXT = 'AUTOMATIC';
2469 include/assert.inc [Both counters should be 0]
2470 DROP TABLE IF EXISTS t1;
2471 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
2472 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
2473 SET GTID_NEXT = 'AUTOMATIC';
2474 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2475 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2476 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2477 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2478 include/assert.inc [No warning or error should be generated.]
2479 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2480 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2481 ROLLBACK;
2482 SET GTID_NEXT = 'AUTOMATIC';
2483 include/assert.inc [Both counters should be 0]
2484 DROP TABLE IF EXISTS t1;
2485 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
2486 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
2487 SET GTID_NEXT = 'AUTOMATIC';
2488 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2489 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2490 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2491 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2492 include/assert.inc [No warning or error should be generated.]
2493 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2494 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2495 ROLLBACK;
2496 SET GTID_NEXT = 'AUTOMATIC';
2497 include/assert.inc [Both counters should be 0]
2498 DROP TABLE IF EXISTS t1;
2499 SET SQL_LOG_BIN = 0;
2500 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
2501 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
2502 SET GTID_NEXT = 'AUTOMATIC';
2503 [START] CREATE TABLE t1 (a INT) SELECT 1;
2504 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2505 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2506 [END] CREATE TABLE t1 (a INT) SELECT 1;
2507 include/assert.inc [No warning or error should be generated.]
2508 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2509 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2510 ROLLBACK;
2511 SET GTID_NEXT = 'AUTOMATIC';
2512 include/assert.inc [Both counters should be 0]
2513 DROP TABLE IF EXISTS t1;
2514 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
2515 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
2516 SET GTID_NEXT = 'AUTOMATIC';
2517 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2518 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2519 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2520 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2521 include/assert.inc [No warning or error should be generated.]
2522 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2523 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2524 ROLLBACK;
2525 SET GTID_NEXT = 'AUTOMATIC';
2526 include/assert.inc [Both counters should be 0]
2527 DROP TABLE IF EXISTS t1;
2528 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
2529 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
2530 SET GTID_NEXT = 'AUTOMATIC';
2531 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2532 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2533 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2534 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2535 include/assert.inc [No warning or error should be generated.]
2536 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2537 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2538 ROLLBACK;
2539 SET GTID_NEXT = 'AUTOMATIC';
2540 include/assert.inc [Both counters should be 0]
2541 DROP TABLE IF EXISTS t1;
2542 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
2543 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
2544 SET GTID_NEXT = 'AUTOMATIC';
2545 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2546 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2547 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2548 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2549 include/assert.inc [No warning or error should be generated.]
2550 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2551 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2552 ROLLBACK;
2553 SET GTID_NEXT = 'AUTOMATIC';
2554 include/assert.inc [Both counters should be 0]
2555 DROP TABLE IF EXISTS t1;
2556 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
2557 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
2558 SET GTID_NEXT = 'AUTOMATIC';
2559 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2560 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2561 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2562 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2563 include/assert.inc [No warning or error should be generated.]
2564 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2565 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2566 ROLLBACK;
2567 SET GTID_NEXT = 'AUTOMATIC';
2568 include/assert.inc [Both counters should be 0]
2569 DROP TABLE IF EXISTS t1;
2570 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
2571 SET SQL_LOG_BIN = 1;
2572 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF GTID_NEXT=ANONYMOUS ########
2573 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
2574 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
2575 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
2576 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
2577 INSERT INTO nonempty_innodb VALUES (1);
2578 INSERT INTO nonempty_myisam VALUES (1);
2579 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
2580 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
2581 SET GTID_NEXT = 'ANONYMOUS';
2582 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2583 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2584 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2585 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2586 include/assert.inc [No warning or error should be generated.]
2587 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2588 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2589 ROLLBACK;
2590 SET GTID_NEXT = 'AUTOMATIC';
2591 include/assert.inc [Both counters should be 0]
2592 DROP TABLE IF EXISTS t1;
2593 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
2594 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
2595 SET GTID_NEXT = 'ANONYMOUS';
2596 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2597 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2598 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2599 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2600 include/assert.inc [No warning or error should be generated.]
2601 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2602 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2603 ROLLBACK;
2604 SET GTID_NEXT = 'AUTOMATIC';
2605 include/assert.inc [Both counters should be 0]
2606 DROP TABLE IF EXISTS t1;
2607 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
2608 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
2609 SET GTID_NEXT = 'ANONYMOUS';
2610 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2611 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2612 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2613 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2614 include/assert.inc [No warning or error should be generated.]
2615 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2616 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2617 ROLLBACK;
2618 SET GTID_NEXT = 'AUTOMATIC';
2619 include/assert.inc [Both counters should be 0]
2620 DROP TABLE IF EXISTS t1;
2621 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
2622 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
2623 SET GTID_NEXT = 'ANONYMOUS';
2624 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2625 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2626 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2627 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2628 include/assert.inc [No warning or error should be generated.]
2629 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2630 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2631 ROLLBACK;
2632 SET GTID_NEXT = 'AUTOMATIC';
2633 include/assert.inc [Both counters should be 0]
2634 DROP TABLE IF EXISTS t1;
2635 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
2636 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
2637 SET GTID_NEXT = 'ANONYMOUS';
2638 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2639 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2640 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2641 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2642 include/assert.inc [No warning or error should be generated.]
2643 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2644 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2645 ROLLBACK;
2646 SET GTID_NEXT = 'AUTOMATIC';
2647 include/assert.inc [Both counters should be 0]
2648 DROP TABLE IF EXISTS t1;
2649 SET SQL_LOG_BIN = 0;
2650 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
2651 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
2652 SET GTID_NEXT = 'ANONYMOUS';
2653 [START] CREATE TABLE t1 (a INT) SELECT 1;
2654 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2655 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2656 [END] CREATE TABLE t1 (a INT) SELECT 1;
2657 include/assert.inc [No warning or error should be generated.]
2658 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2659 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2660 ROLLBACK;
2661 SET GTID_NEXT = 'AUTOMATIC';
2662 include/assert.inc [Both counters should be 0]
2663 DROP TABLE IF EXISTS t1;
2664 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
2665 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
2666 SET GTID_NEXT = 'ANONYMOUS';
2667 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2668 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2669 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2670 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2671 include/assert.inc [No warning or error should be generated.]
2672 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2673 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2674 ROLLBACK;
2675 SET GTID_NEXT = 'AUTOMATIC';
2676 include/assert.inc [Both counters should be 0]
2677 DROP TABLE IF EXISTS t1;
2678 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
2679 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
2680 SET GTID_NEXT = 'ANONYMOUS';
2681 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2682 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2683 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2684 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2685 include/assert.inc [No warning or error should be generated.]
2686 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2687 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2688 ROLLBACK;
2689 SET GTID_NEXT = 'AUTOMATIC';
2690 include/assert.inc [Both counters should be 0]
2691 DROP TABLE IF EXISTS t1;
2692 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
2693 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
2694 SET GTID_NEXT = 'ANONYMOUS';
2695 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2696 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2697 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2698 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2699 include/assert.inc [No warning or error should be generated.]
2700 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2701 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2702 ROLLBACK;
2703 SET GTID_NEXT = 'AUTOMATIC';
2704 include/assert.inc [Both counters should be 0]
2705 DROP TABLE IF EXISTS t1;
2706 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
2707 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
2708 SET GTID_NEXT = 'ANONYMOUS';
2709 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2710 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2711 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2712 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2713 include/assert.inc [No warning or error should be generated.]
2714 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2715 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2716 ROLLBACK;
2717 SET GTID_NEXT = 'AUTOMATIC';
2718 include/assert.inc [Both counters should be 0]
2719 DROP TABLE IF EXISTS t1;
2720 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
2721 SET SQL_LOG_BIN = 1;
2722 SET GLOBAL ENFORCE_GTID_CONSISTENCY = 2;
2723 SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
2724 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
2725 SET GLOBAL GTID_MODE = 2;
2726 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=ON_PERMISSIVE GTID_NEXT=AUTOMATIC ########
2727 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
2728 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
2729 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
2730 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
2731 INSERT INTO nonempty_innodb VALUES (1);
2732 INSERT INTO nonempty_myisam VALUES (1);
2733 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
2734 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
2735 SET GTID_NEXT = 'AUTOMATIC';
2736 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2737 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2738 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2739 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2740 include/assert.inc [No warning or error should be generated.]
2741 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2742 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2743 ROLLBACK;
2744 SET GTID_NEXT = 'AUTOMATIC';
2745 include/assert.inc [Both counters should be 0]
2746 DROP TABLE IF EXISTS t1;
2747 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
2748 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
2749 SET GTID_NEXT = 'AUTOMATIC';
2750 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2751 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2752 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2753 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2754 include/assert.inc [No warning or error should be generated.]
2755 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2756 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2757 ROLLBACK;
2758 SET GTID_NEXT = 'AUTOMATIC';
2759 include/assert.inc [Both counters should be 0]
2760 DROP TABLE IF EXISTS t1;
2761 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
2762 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
2763 SET GTID_NEXT = 'AUTOMATIC';
2764 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2765 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2766 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2767 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2768 include/assert.inc [No warning or error should be generated.]
2769 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2770 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2771 ROLLBACK;
2772 SET GTID_NEXT = 'AUTOMATIC';
2773 include/assert.inc [Both counters should be 0]
2774 DROP TABLE IF EXISTS t1;
2775 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
2776 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
2777 SET GTID_NEXT = 'AUTOMATIC';
2778 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2779 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2780 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2781 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2782 include/assert.inc [No warning or error should be generated.]
2783 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2784 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2785 ROLLBACK;
2786 SET GTID_NEXT = 'AUTOMATIC';
2787 include/assert.inc [Both counters should be 0]
2788 DROP TABLE IF EXISTS t1;
2789 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
2790 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
2791 SET GTID_NEXT = 'AUTOMATIC';
2792 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2793 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2794 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2795 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2796 include/assert.inc [No warning or error should be generated.]
2797 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2798 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2799 ROLLBACK;
2800 SET GTID_NEXT = 'AUTOMATIC';
2801 include/assert.inc [Both counters should be 0]
2802 DROP TABLE IF EXISTS t1;
2803 SET SQL_LOG_BIN = 0;
2804 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
2805 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
2806 SET GTID_NEXT = 'AUTOMATIC';
2807 [START] CREATE TABLE t1 (a INT) SELECT 1;
2808 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2809 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2810 [END] CREATE TABLE t1 (a INT) SELECT 1;
2811 include/assert.inc [No warning or error should be generated.]
2812 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2813 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2814 ROLLBACK;
2815 SET GTID_NEXT = 'AUTOMATIC';
2816 include/assert.inc [Both counters should be 0]
2817 DROP TABLE IF EXISTS t1;
2818 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
2819 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
2820 SET GTID_NEXT = 'AUTOMATIC';
2821 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2822 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2823 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2824 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2825 include/assert.inc [No warning or error should be generated.]
2826 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2827 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2828 ROLLBACK;
2829 SET GTID_NEXT = 'AUTOMATIC';
2830 include/assert.inc [Both counters should be 0]
2831 DROP TABLE IF EXISTS t1;
2832 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
2833 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
2834 SET GTID_NEXT = 'AUTOMATIC';
2835 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2836 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2837 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2838 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2839 include/assert.inc [No warning or error should be generated.]
2840 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2841 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2842 ROLLBACK;
2843 SET GTID_NEXT = 'AUTOMATIC';
2844 include/assert.inc [Both counters should be 0]
2845 DROP TABLE IF EXISTS t1;
2846 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
2847 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
2848 SET GTID_NEXT = 'AUTOMATIC';
2849 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2850 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2851 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2852 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
2853 include/assert.inc [No warning or error should be generated.]
2854 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2855 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2856 ROLLBACK;
2857 SET GTID_NEXT = 'AUTOMATIC';
2858 include/assert.inc [Both counters should be 0]
2859 DROP TABLE IF EXISTS t1;
2860 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
2861 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
2862 SET GTID_NEXT = 'AUTOMATIC';
2863 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2864 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2865 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2866 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
2867 include/assert.inc [No warning or error should be generated.]
2868 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2869 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2870 ROLLBACK;
2871 SET GTID_NEXT = 'AUTOMATIC';
2872 include/assert.inc [Both counters should be 0]
2873 DROP TABLE IF EXISTS t1;
2874 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
2875 SET SQL_LOG_BIN = 1;
2876 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=ON_PERMISSIVE GTID_NEXT=ANONYMOUS ########
2877 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
2878 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
2879 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
2880 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
2881 INSERT INTO nonempty_innodb VALUES (1);
2882 INSERT INTO nonempty_myisam VALUES (1);
2883 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
2884 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2885 SET GTID_NEXT = 'ANONYMOUS';
2886 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2887 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2888 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2889 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
2890 include/assert.inc [No warning or error should be generated.]
2891 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2892 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2893 ROLLBACK;
2894 SET GTID_NEXT = 'AUTOMATIC';
2895 include/assert.inc [Both counters should be 0]
2896 DROP TABLE IF EXISTS t1;
2897 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
2898 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2899 SET GTID_NEXT = 'ANONYMOUS';
2900 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2901 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2902 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2903 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2904 include/assert.inc [No warning or error should be generated.]
2905 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2906 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2907 ROLLBACK;
2908 SET GTID_NEXT = 'AUTOMATIC';
2909 include/assert.inc [Both counters should be 0]
2910 DROP TABLE IF EXISTS t1;
2911 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
2912 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2913 SET GTID_NEXT = 'ANONYMOUS';
2914 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2915 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2916 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2917 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2918 include/assert.inc [No warning or error should be generated.]
2919 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2920 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2921 ROLLBACK;
2922 SET GTID_NEXT = 'AUTOMATIC';
2923 include/assert.inc [Both counters should be 0]
2924 DROP TABLE IF EXISTS t1;
2925 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
2926 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2927 SET GTID_NEXT = 'ANONYMOUS';
2928 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2929 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2930 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2931 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
2932 include/assert.inc [No warning or error should be generated.]
2933 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2934 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2935 ROLLBACK;
2936 SET GTID_NEXT = 'AUTOMATIC';
2937 include/assert.inc [Both counters should be 0]
2938 DROP TABLE IF EXISTS t1;
2939 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
2940 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2941 SET GTID_NEXT = 'ANONYMOUS';
2942 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2943 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2944 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2945 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
2946 include/assert.inc [No warning or error should be generated.]
2947 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2948 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2949 ROLLBACK;
2950 SET GTID_NEXT = 'AUTOMATIC';
2951 include/assert.inc [Both counters should be 0]
2952 DROP TABLE IF EXISTS t1;
2953 SET SQL_LOG_BIN = 0;
2954 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
2955 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2956 SET GTID_NEXT = 'ANONYMOUS';
2957 [START] CREATE TABLE t1 (a INT) SELECT 1;
2958 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2959 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2960 [END] CREATE TABLE t1 (a INT) SELECT 1;
2961 include/assert.inc [No warning or error should be generated.]
2962 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2963 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2964 ROLLBACK;
2965 SET GTID_NEXT = 'AUTOMATIC';
2966 include/assert.inc [Both counters should be 0]
2967 DROP TABLE IF EXISTS t1;
2968 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
2969 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2970 SET GTID_NEXT = 'ANONYMOUS';
2971 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2972 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2973 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2974 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
2975 include/assert.inc [No warning or error should be generated.]
2976 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2977 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2978 ROLLBACK;
2979 SET GTID_NEXT = 'AUTOMATIC';
2980 include/assert.inc [Both counters should be 0]
2981 DROP TABLE IF EXISTS t1;
2982 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
2983 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2984 SET GTID_NEXT = 'ANONYMOUS';
2985 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2986 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2987 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2988 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
2989 include/assert.inc [No warning or error should be generated.]
2990 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2991 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2992 ROLLBACK;
2993 SET GTID_NEXT = 'AUTOMATIC';
2994 include/assert.inc [Both counters should be 0]
2995 DROP TABLE IF EXISTS t1;
2996 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
2997 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2998 SET GTID_NEXT = 'ANONYMOUS';
2999 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3000 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3001 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3002 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3003 include/assert.inc [No warning or error should be generated.]
3004 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3005 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3006 ROLLBACK;
3007 SET GTID_NEXT = 'AUTOMATIC';
3008 include/assert.inc [Both counters should be 0]
3009 DROP TABLE IF EXISTS t1;
3010 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
3011 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
3012 SET GTID_NEXT = 'ANONYMOUS';
3013 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3014 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3015 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3016 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3017 include/assert.inc [No warning or error should be generated.]
3018 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3019 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3020 ROLLBACK;
3021 SET GTID_NEXT = 'AUTOMATIC';
3022 include/assert.inc [Both counters should be 0]
3023 DROP TABLE IF EXISTS t1;
3024 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
3025 SET SQL_LOG_BIN = 1;
3026 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=ON_PERMISSIVE GTID_NEXT=GTID ########
3027 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
3028 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
3029 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
3030 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
3031 INSERT INTO nonempty_innodb VALUES (1);
3032 INSERT INTO nonempty_myisam VALUES (1);
3033 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
3034 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
3035 SET GTID_NEXT = 'GTID';
3036 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3037 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3038 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3039 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3040 include/assert.inc [No warning or error should be generated.]
3041 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3042 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3043 ROLLBACK;
3044 SET GTID_NEXT = 'AUTOMATIC';
3045 include/assert.inc [Both counters should be 0]
3046 DROP TABLE IF EXISTS t1;
3047 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
3048 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
3049 SET GTID_NEXT = 'GTID';
3050 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3051 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3052 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3053 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3054 include/assert.inc [No warning or error should be generated.]
3055 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3056 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3057 ROLLBACK;
3058 SET GTID_NEXT = 'AUTOMATIC';
3059 include/assert.inc [Both counters should be 0]
3060 DROP TABLE IF EXISTS t1;
3061 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
3062 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
3063 SET GTID_NEXT = 'GTID';
3064 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3065 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3066 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3067 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3068 include/assert.inc [No warning or error should be generated.]
3069 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3070 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3071 ROLLBACK;
3072 SET GTID_NEXT = 'AUTOMATIC';
3073 include/assert.inc [Both counters should be 0]
3074 DROP TABLE IF EXISTS t1;
3075 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
3076 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
3077 SET GTID_NEXT = 'GTID';
3078 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3079 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3080 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3081 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3082 include/assert.inc [No warning or error should be generated.]
3083 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3084 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3085 ROLLBACK;
3086 SET GTID_NEXT = 'AUTOMATIC';
3087 include/assert.inc [Both counters should be 0]
3088 DROP TABLE IF EXISTS t1;
3089 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
3090 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
3091 SET GTID_NEXT = 'GTID';
3092 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3093 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3094 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3095 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3096 include/assert.inc [No warning or error should be generated.]
3097 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3098 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3099 ROLLBACK;
3100 SET GTID_NEXT = 'AUTOMATIC';
3101 include/assert.inc [Both counters should be 0]
3102 DROP TABLE IF EXISTS t1;
3103 SET SQL_LOG_BIN = 0;
3104 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
3105 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
3106 SET GTID_NEXT = 'GTID';
3107 [START] CREATE TABLE t1 (a INT) SELECT 1;
3108 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3109 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3110 [END] CREATE TABLE t1 (a INT) SELECT 1;
3111 include/assert.inc [No warning or error should be generated.]
3112 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3113 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3114 ROLLBACK;
3115 SET GTID_NEXT = 'AUTOMATIC';
3116 include/assert.inc [Both counters should be 0]
3117 DROP TABLE IF EXISTS t1;
3118 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
3119 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
3120 SET GTID_NEXT = 'GTID';
3121 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3122 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3123 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3124 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3125 include/assert.inc [No warning or error should be generated.]
3126 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3127 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3128 ROLLBACK;
3129 SET GTID_NEXT = 'AUTOMATIC';
3130 include/assert.inc [Both counters should be 0]
3131 DROP TABLE IF EXISTS t1;
3132 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
3133 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
3134 SET GTID_NEXT = 'GTID';
3135 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3136 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3137 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3138 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3139 include/assert.inc [No warning or error should be generated.]
3140 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3141 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3142 ROLLBACK;
3143 SET GTID_NEXT = 'AUTOMATIC';
3144 include/assert.inc [Both counters should be 0]
3145 DROP TABLE IF EXISTS t1;
3146 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
3147 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
3148 SET GTID_NEXT = 'GTID';
3149 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3150 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3151 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3152 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3153 include/assert.inc [No warning or error should be generated.]
3154 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3155 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3156 ROLLBACK;
3157 SET GTID_NEXT = 'AUTOMATIC';
3158 include/assert.inc [Both counters should be 0]
3159 DROP TABLE IF EXISTS t1;
3160 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
3161 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
3162 SET GTID_NEXT = 'GTID';
3163 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3164 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3165 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3166 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3167 include/assert.inc [No warning or error should be generated.]
3168 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3169 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3170 ROLLBACK;
3171 SET GTID_NEXT = 'AUTOMATIC';
3172 include/assert.inc [Both counters should be 0]
3173 DROP TABLE IF EXISTS t1;
3174 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
3175 SET SQL_LOG_BIN = 1;
3176 SET GLOBAL GTID_MODE = 1;
3177 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF_PERMISSIVE GTID_NEXT=AUTOMATIC ########
3178 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
3179 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
3180 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
3181 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
3182 INSERT INTO nonempty_innodb VALUES (1);
3183 INSERT INTO nonempty_myisam VALUES (1);
3184 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
3185 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
3186 SET GTID_NEXT = 'AUTOMATIC';
3187 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3188 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3189 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3190 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3191 include/assert.inc [No warning or error should be generated.]
3192 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3193 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3194 ROLLBACK;
3195 SET GTID_NEXT = 'AUTOMATIC';
3196 include/assert.inc [Both counters should be 0]
3197 DROP TABLE IF EXISTS t1;
3198 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
3199 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
3200 SET GTID_NEXT = 'AUTOMATIC';
3201 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3202 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3203 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3204 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3205 include/assert.inc [No warning or error should be generated.]
3206 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3207 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3208 ROLLBACK;
3209 SET GTID_NEXT = 'AUTOMATIC';
3210 include/assert.inc [Both counters should be 0]
3211 DROP TABLE IF EXISTS t1;
3212 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
3213 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
3214 SET GTID_NEXT = 'AUTOMATIC';
3215 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3216 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3217 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3218 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3219 include/assert.inc [No warning or error should be generated.]
3220 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3221 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3222 ROLLBACK;
3223 SET GTID_NEXT = 'AUTOMATIC';
3224 include/assert.inc [Both counters should be 0]
3225 DROP TABLE IF EXISTS t1;
3226 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
3227 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
3228 SET GTID_NEXT = 'AUTOMATIC';
3229 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3230 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3231 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3232 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3233 include/assert.inc [No warning or error should be generated.]
3234 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3235 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3236 ROLLBACK;
3237 SET GTID_NEXT = 'AUTOMATIC';
3238 include/assert.inc [Both counters should be 0]
3239 DROP TABLE IF EXISTS t1;
3240 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
3241 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
3242 SET GTID_NEXT = 'AUTOMATIC';
3243 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3244 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3245 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3246 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3247 include/assert.inc [No warning or error should be generated.]
3248 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3249 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3250 ROLLBACK;
3251 SET GTID_NEXT = 'AUTOMATIC';
3252 include/assert.inc [Both counters should be 0]
3253 DROP TABLE IF EXISTS t1;
3254 SET SQL_LOG_BIN = 0;
3255 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
3256 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
3257 SET GTID_NEXT = 'AUTOMATIC';
3258 [START] CREATE TABLE t1 (a INT) SELECT 1;
3259 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3260 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3261 [END] CREATE TABLE t1 (a INT) SELECT 1;
3262 include/assert.inc [No warning or error should be generated.]
3263 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3264 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3265 ROLLBACK;
3266 SET GTID_NEXT = 'AUTOMATIC';
3267 include/assert.inc [Both counters should be 0]
3268 DROP TABLE IF EXISTS t1;
3269 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
3270 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
3271 SET GTID_NEXT = 'AUTOMATIC';
3272 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3273 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3274 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3275 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3276 include/assert.inc [No warning or error should be generated.]
3277 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3278 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3279 ROLLBACK;
3280 SET GTID_NEXT = 'AUTOMATIC';
3281 include/assert.inc [Both counters should be 0]
3282 DROP TABLE IF EXISTS t1;
3283 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
3284 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
3285 SET GTID_NEXT = 'AUTOMATIC';
3286 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3287 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3288 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3289 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3290 include/assert.inc [No warning or error should be generated.]
3291 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3292 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3293 ROLLBACK;
3294 SET GTID_NEXT = 'AUTOMATIC';
3295 include/assert.inc [Both counters should be 0]
3296 DROP TABLE IF EXISTS t1;
3297 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
3298 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
3299 SET GTID_NEXT = 'AUTOMATIC';
3300 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3301 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3302 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3303 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3304 include/assert.inc [No warning or error should be generated.]
3305 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3306 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3307 ROLLBACK;
3308 SET GTID_NEXT = 'AUTOMATIC';
3309 include/assert.inc [Both counters should be 0]
3310 DROP TABLE IF EXISTS t1;
3311 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
3312 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
3313 SET GTID_NEXT = 'AUTOMATIC';
3314 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3315 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3316 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3317 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3318 include/assert.inc [No warning or error should be generated.]
3319 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3320 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3321 ROLLBACK;
3322 SET GTID_NEXT = 'AUTOMATIC';
3323 include/assert.inc [Both counters should be 0]
3324 DROP TABLE IF EXISTS t1;
3325 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
3326 SET SQL_LOG_BIN = 1;
3327 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF_PERMISSIVE GTID_NEXT=ANONYMOUS ########
3328 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
3329 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
3330 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
3331 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
3332 INSERT INTO nonempty_innodb VALUES (1);
3333 INSERT INTO nonempty_myisam VALUES (1);
3334 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
3335 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
3336 SET GTID_NEXT = 'ANONYMOUS';
3337 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3338 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3339 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3340 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3341 include/assert.inc [No warning or error should be generated.]
3342 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3343 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3344 ROLLBACK;
3345 SET GTID_NEXT = 'AUTOMATIC';
3346 include/assert.inc [Both counters should be 0]
3347 DROP TABLE IF EXISTS t1;
3348 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
3349 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
3350 SET GTID_NEXT = 'ANONYMOUS';
3351 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3352 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3353 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3354 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3355 include/assert.inc [No warning or error should be generated.]
3356 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3357 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3358 ROLLBACK;
3359 SET GTID_NEXT = 'AUTOMATIC';
3360 include/assert.inc [Both counters should be 0]
3361 DROP TABLE IF EXISTS t1;
3362 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
3363 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
3364 SET GTID_NEXT = 'ANONYMOUS';
3365 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3366 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3367 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3368 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3369 include/assert.inc [No warning or error should be generated.]
3370 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3371 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3372 ROLLBACK;
3373 SET GTID_NEXT = 'AUTOMATIC';
3374 include/assert.inc [Both counters should be 0]
3375 DROP TABLE IF EXISTS t1;
3376 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
3377 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
3378 SET GTID_NEXT = 'ANONYMOUS';
3379 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3380 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3381 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3382 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3383 include/assert.inc [No warning or error should be generated.]
3384 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3385 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3386 ROLLBACK;
3387 SET GTID_NEXT = 'AUTOMATIC';
3388 include/assert.inc [Both counters should be 0]
3389 DROP TABLE IF EXISTS t1;
3390 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
3391 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
3392 SET GTID_NEXT = 'ANONYMOUS';
3393 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3394 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3395 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3396 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3397 include/assert.inc [No warning or error should be generated.]
3398 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3399 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3400 ROLLBACK;
3401 SET GTID_NEXT = 'AUTOMATIC';
3402 include/assert.inc [Both counters should be 0]
3403 DROP TABLE IF EXISTS t1;
3404 SET SQL_LOG_BIN = 0;
3405 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
3406 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
3407 SET GTID_NEXT = 'ANONYMOUS';
3408 [START] CREATE TABLE t1 (a INT) SELECT 1;
3409 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3410 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3411 [END] CREATE TABLE t1 (a INT) SELECT 1;
3412 include/assert.inc [No warning or error should be generated.]
3413 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3414 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3415 ROLLBACK;
3416 SET GTID_NEXT = 'AUTOMATIC';
3417 include/assert.inc [Both counters should be 0]
3418 DROP TABLE IF EXISTS t1;
3419 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
3420 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
3421 SET GTID_NEXT = 'ANONYMOUS';
3422 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3423 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3424 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3425 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3426 include/assert.inc [No warning or error should be generated.]
3427 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3428 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3429 ROLLBACK;
3430 SET GTID_NEXT = 'AUTOMATIC';
3431 include/assert.inc [Both counters should be 0]
3432 DROP TABLE IF EXISTS t1;
3433 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
3434 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
3435 SET GTID_NEXT = 'ANONYMOUS';
3436 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3437 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3438 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3439 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3440 include/assert.inc [No warning or error should be generated.]
3441 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3442 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3443 ROLLBACK;
3444 SET GTID_NEXT = 'AUTOMATIC';
3445 include/assert.inc [Both counters should be 0]
3446 DROP TABLE IF EXISTS t1;
3447 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
3448 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
3449 SET GTID_NEXT = 'ANONYMOUS';
3450 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3451 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3452 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3453 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3454 include/assert.inc [No warning or error should be generated.]
3455 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3456 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3457 ROLLBACK;
3458 SET GTID_NEXT = 'AUTOMATIC';
3459 include/assert.inc [Both counters should be 0]
3460 DROP TABLE IF EXISTS t1;
3461 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
3462 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
3463 SET GTID_NEXT = 'ANONYMOUS';
3464 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3465 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3466 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3467 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3468 include/assert.inc [No warning or error should be generated.]
3469 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3470 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3471 ROLLBACK;
3472 SET GTID_NEXT = 'AUTOMATIC';
3473 include/assert.inc [Both counters should be 0]
3474 DROP TABLE IF EXISTS t1;
3475 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
3476 SET SQL_LOG_BIN = 1;
3477 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF_PERMISSIVE GTID_NEXT=GTID ########
3478 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
3479 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
3480 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
3481 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
3482 INSERT INTO nonempty_innodb VALUES (1);
3483 INSERT INTO nonempty_myisam VALUES (1);
3484 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
3485 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
3486 SET GTID_NEXT = 'GTID';
3487 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3488 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3489 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3490 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3491 include/assert.inc [No warning or error should be generated.]
3492 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3493 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3494 ROLLBACK;
3495 SET GTID_NEXT = 'AUTOMATIC';
3496 include/assert.inc [Both counters should be 0]
3497 DROP TABLE IF EXISTS t1;
3498 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
3499 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
3500 SET GTID_NEXT = 'GTID';
3501 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3502 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3503 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3504 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3505 include/assert.inc [No warning or error should be generated.]
3506 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3507 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3508 ROLLBACK;
3509 SET GTID_NEXT = 'AUTOMATIC';
3510 include/assert.inc [Both counters should be 0]
3511 DROP TABLE IF EXISTS t1;
3512 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
3513 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
3514 SET GTID_NEXT = 'GTID';
3515 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3516 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3517 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3518 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3519 include/assert.inc [No warning or error should be generated.]
3520 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3521 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3522 ROLLBACK;
3523 SET GTID_NEXT = 'AUTOMATIC';
3524 include/assert.inc [Both counters should be 0]
3525 DROP TABLE IF EXISTS t1;
3526 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
3527 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
3528 SET GTID_NEXT = 'GTID';
3529 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3530 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3531 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3532 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3533 include/assert.inc [No warning or error should be generated.]
3534 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3535 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3536 ROLLBACK;
3537 SET GTID_NEXT = 'AUTOMATIC';
3538 include/assert.inc [Both counters should be 0]
3539 DROP TABLE IF EXISTS t1;
3540 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
3541 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
3542 SET GTID_NEXT = 'GTID';
3543 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3544 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3545 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3546 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3547 include/assert.inc [No warning or error should be generated.]
3548 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3549 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3550 ROLLBACK;
3551 SET GTID_NEXT = 'AUTOMATIC';
3552 include/assert.inc [Both counters should be 0]
3553 DROP TABLE IF EXISTS t1;
3554 SET SQL_LOG_BIN = 0;
3555 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
3556 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
3557 SET GTID_NEXT = 'GTID';
3558 [START] CREATE TABLE t1 (a INT) SELECT 1;
3559 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3560 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3561 [END] CREATE TABLE t1 (a INT) SELECT 1;
3562 include/assert.inc [No warning or error should be generated.]
3563 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3564 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3565 ROLLBACK;
3566 SET GTID_NEXT = 'AUTOMATIC';
3567 include/assert.inc [Both counters should be 0]
3568 DROP TABLE IF EXISTS t1;
3569 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
3570 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
3571 SET GTID_NEXT = 'GTID';
3572 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3573 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3574 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3575 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3576 include/assert.inc [No warning or error should be generated.]
3577 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3578 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3579 ROLLBACK;
3580 SET GTID_NEXT = 'AUTOMATIC';
3581 include/assert.inc [Both counters should be 0]
3582 DROP TABLE IF EXISTS t1;
3583 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
3584 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
3585 SET GTID_NEXT = 'GTID';
3586 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3587 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3588 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3589 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3590 include/assert.inc [No warning or error should be generated.]
3591 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3592 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3593 ROLLBACK;
3594 SET GTID_NEXT = 'AUTOMATIC';
3595 include/assert.inc [Both counters should be 0]
3596 DROP TABLE IF EXISTS t1;
3597 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
3598 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
3599 SET GTID_NEXT = 'GTID';
3600 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3601 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3602 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3603 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3604 include/assert.inc [No warning or error should be generated.]
3605 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3606 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3607 ROLLBACK;
3608 SET GTID_NEXT = 'AUTOMATIC';
3609 include/assert.inc [Both counters should be 0]
3610 DROP TABLE IF EXISTS t1;
3611 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
3612 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
3613 SET GTID_NEXT = 'GTID';
3614 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3615 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3616 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3617 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3618 include/assert.inc [No warning or error should be generated.]
3619 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3620 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3621 ROLLBACK;
3622 SET GTID_NEXT = 'AUTOMATIC';
3623 include/assert.inc [Both counters should be 0]
3624 DROP TABLE IF EXISTS t1;
3625 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
3626 SET SQL_LOG_BIN = 1;
3627 SET GLOBAL GTID_MODE = 0;
3628 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF GTID_NEXT=AUTOMATIC ########
3629 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
3630 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
3631 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
3632 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
3633 INSERT INTO nonempty_innodb VALUES (1);
3634 INSERT INTO nonempty_myisam VALUES (1);
3635 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
3636 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
3637 SET GTID_NEXT = 'AUTOMATIC';
3638 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3639 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3640 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3641 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3642 include/assert.inc [No warning or error should be generated.]
3643 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3644 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3645 ROLLBACK;
3646 SET GTID_NEXT = 'AUTOMATIC';
3647 include/assert.inc [Both counters should be 0]
3648 DROP TABLE IF EXISTS t1;
3649 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
3650 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
3651 SET GTID_NEXT = 'AUTOMATIC';
3652 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3653 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3654 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3655 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3656 include/assert.inc [No warning or error should be generated.]
3657 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3658 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3659 ROLLBACK;
3660 SET GTID_NEXT = 'AUTOMATIC';
3661 include/assert.inc [Both counters should be 0]
3662 DROP TABLE IF EXISTS t1;
3663 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
3664 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
3665 SET GTID_NEXT = 'AUTOMATIC';
3666 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3667 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3668 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3669 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3670 include/assert.inc [No warning or error should be generated.]
3671 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3672 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3673 ROLLBACK;
3674 SET GTID_NEXT = 'AUTOMATIC';
3675 include/assert.inc [Both counters should be 0]
3676 DROP TABLE IF EXISTS t1;
3677 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
3678 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
3679 SET GTID_NEXT = 'AUTOMATIC';
3680 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3681 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3682 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3683 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3684 include/assert.inc [No warning or error should be generated.]
3685 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3686 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3687 ROLLBACK;
3688 SET GTID_NEXT = 'AUTOMATIC';
3689 include/assert.inc [Both counters should be 0]
3690 DROP TABLE IF EXISTS t1;
3691 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
3692 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
3693 SET GTID_NEXT = 'AUTOMATIC';
3694 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3695 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3696 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3697 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3698 include/assert.inc [No warning or error should be generated.]
3699 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3700 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3701 ROLLBACK;
3702 SET GTID_NEXT = 'AUTOMATIC';
3703 include/assert.inc [Both counters should be 0]
3704 DROP TABLE IF EXISTS t1;
3705 SET SQL_LOG_BIN = 0;
3706 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
3707 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
3708 SET GTID_NEXT = 'AUTOMATIC';
3709 [START] CREATE TABLE t1 (a INT) SELECT 1;
3710 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3711 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3712 [END] CREATE TABLE t1 (a INT) SELECT 1;
3713 include/assert.inc [No warning or error should be generated.]
3714 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3715 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3716 ROLLBACK;
3717 SET GTID_NEXT = 'AUTOMATIC';
3718 include/assert.inc [Both counters should be 0]
3719 DROP TABLE IF EXISTS t1;
3720 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
3721 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
3722 SET GTID_NEXT = 'AUTOMATIC';
3723 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3724 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3725 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3726 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3727 include/assert.inc [No warning or error should be generated.]
3728 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3729 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3730 ROLLBACK;
3731 SET GTID_NEXT = 'AUTOMATIC';
3732 include/assert.inc [Both counters should be 0]
3733 DROP TABLE IF EXISTS t1;
3734 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
3735 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
3736 SET GTID_NEXT = 'AUTOMATIC';
3737 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3738 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3739 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3740 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3741 include/assert.inc [No warning or error should be generated.]
3742 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3743 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3744 ROLLBACK;
3745 SET GTID_NEXT = 'AUTOMATIC';
3746 include/assert.inc [Both counters should be 0]
3747 DROP TABLE IF EXISTS t1;
3748 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
3749 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
3750 SET GTID_NEXT = 'AUTOMATIC';
3751 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3752 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3753 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3754 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3755 include/assert.inc [No warning or error should be generated.]
3756 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3757 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3758 ROLLBACK;
3759 SET GTID_NEXT = 'AUTOMATIC';
3760 include/assert.inc [Both counters should be 0]
3761 DROP TABLE IF EXISTS t1;
3762 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
3763 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
3764 SET GTID_NEXT = 'AUTOMATIC';
3765 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3766 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3767 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3768 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3769 include/assert.inc [No warning or error should be generated.]
3770 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3771 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3772 ROLLBACK;
3773 SET GTID_NEXT = 'AUTOMATIC';
3774 include/assert.inc [Both counters should be 0]
3775 DROP TABLE IF EXISTS t1;
3776 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
3777 SET SQL_LOG_BIN = 1;
3778 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF GTID_NEXT=ANONYMOUS ########
3779 CREATE TABLE empty_innodb (a INT) ENGINE = InnoDB;
3780 CREATE TABLE empty_myisam (a INT) ENGINE = MyISAM;
3781 CREATE TABLE nonempty_innodb (a INT) ENGINE = InnoDB;
3782 CREATE TABLE nonempty_myisam (a INT) ENGINE = MyISAM;
3783 INSERT INTO nonempty_innodb VALUES (1);
3784 INSERT INTO nonempty_myisam VALUES (1);
3785 ---- CREATE TEMPORARY ... SELECT (value, 1 row) ----
3786 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
3787 SET GTID_NEXT = 'ANONYMOUS';
3788 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3789 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3790 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3791 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT 1;
3792 include/assert.inc [No warning or error should be generated.]
3793 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3794 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3795 ROLLBACK;
3796 SET GTID_NEXT = 'AUTOMATIC';
3797 include/assert.inc [Both counters should be 0]
3798 DROP TABLE IF EXISTS t1;
3799 ---- CREATE TEMPORARY ... SELECT (InnoDB, 1 row) ----
3800 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
3801 SET GTID_NEXT = 'ANONYMOUS';
3802 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3803 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3804 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3805 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3806 include/assert.inc [No warning or error should be generated.]
3807 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3808 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3809 ROLLBACK;
3810 SET GTID_NEXT = 'AUTOMATIC';
3811 include/assert.inc [Both counters should be 0]
3812 DROP TABLE IF EXISTS t1;
3813 ---- CREATE TEMPORARY ... SELECT (MyISAM, 1 row) ----
3814 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
3815 SET GTID_NEXT = 'ANONYMOUS';
3816 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3817 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3818 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3819 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3820 include/assert.inc [No warning or error should be generated.]
3821 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3822 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3823 ROLLBACK;
3824 SET GTID_NEXT = 'AUTOMATIC';
3825 include/assert.inc [Both counters should be 0]
3826 DROP TABLE IF EXISTS t1;
3827 ---- CREATE TEMPORARY ... SELECT (InnoDB, 0 row) ----
3828 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
3829 SET GTID_NEXT = 'ANONYMOUS';
3830 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3831 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3832 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3833 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_innodb;
3834 include/assert.inc [No warning or error should be generated.]
3835 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3836 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3837 ROLLBACK;
3838 SET GTID_NEXT = 'AUTOMATIC';
3839 include/assert.inc [Both counters should be 0]
3840 DROP TABLE IF EXISTS t1;
3841 ---- CREATE TEMPORARY ... SELECT (MyISAM, 0 row) ----
3842 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
3843 SET GTID_NEXT = 'ANONYMOUS';
3844 [START] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3845 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3846 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3847 [END] CREATE TEMPORARY TABLE t1 (a INT) SELECT * FROM empty_myisam;
3848 include/assert.inc [No warning or error should be generated.]
3849 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3850 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3851 ROLLBACK;
3852 SET GTID_NEXT = 'AUTOMATIC';
3853 include/assert.inc [Both counters should be 0]
3854 DROP TABLE IF EXISTS t1;
3855 SET SQL_LOG_BIN = 0;
3856 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (value, 1 row) ----
3857 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
3858 SET GTID_NEXT = 'ANONYMOUS';
3859 [START] CREATE TABLE t1 (a INT) SELECT 1;
3860 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3861 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3862 [END] CREATE TABLE t1 (a INT) SELECT 1;
3863 include/assert.inc [No warning or error should be generated.]
3864 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3865 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3866 ROLLBACK;
3867 SET GTID_NEXT = 'AUTOMATIC';
3868 include/assert.inc [Both counters should be 0]
3869 DROP TABLE IF EXISTS t1;
3870 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 1 row) ----
3871 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
3872 SET GTID_NEXT = 'ANONYMOUS';
3873 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3874 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3875 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3876 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_innodb;
3877 include/assert.inc [No warning or error should be generated.]
3878 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3879 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3880 ROLLBACK;
3881 SET GTID_NEXT = 'AUTOMATIC';
3882 include/assert.inc [Both counters should be 0]
3883 DROP TABLE IF EXISTS t1;
3884 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 1 row) ----
3885 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
3886 SET GTID_NEXT = 'ANONYMOUS';
3887 [START] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3888 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3889 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3890 [END] CREATE TABLE t1 (a INT) SELECT * FROM nonempty_myisam;
3891 include/assert.inc [No warning or error should be generated.]
3892 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3893 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3894 ROLLBACK;
3895 SET GTID_NEXT = 'AUTOMATIC';
3896 include/assert.inc [Both counters should be 0]
3897 DROP TABLE IF EXISTS t1;
3898 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (InnoDB, 0 row) ----
3899 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
3900 SET GTID_NEXT = 'ANONYMOUS';
3901 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3902 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3903 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3904 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_innodb;
3905 include/assert.inc [No warning or error should be generated.]
3906 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3907 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3908 ROLLBACK;
3909 SET GTID_NEXT = 'AUTOMATIC';
3910 include/assert.inc [Both counters should be 0]
3911 DROP TABLE IF EXISTS t1;
3912 ---- CREATE ... SELECT, SQL_LOG_BIN=0 (MyISAM, 0 row) ----
3913 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
3914 SET GTID_NEXT = 'ANONYMOUS';
3915 [START] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3916 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3917 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3918 [END] CREATE TABLE t1 (a INT) SELECT * FROM empty_myisam;
3919 include/assert.inc [No warning or error should be generated.]
3920 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3921 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
3922 ROLLBACK;
3923 SET GTID_NEXT = 'AUTOMATIC';
3924 include/assert.inc [Both counters should be 0]
3925 DROP TABLE IF EXISTS t1;
3926 DROP TABLE empty_innodb, empty_myisam, nonempty_innodb, nonempty_myisam;
3927 SET SQL_LOG_BIN = 1;
3928 SET GLOBAL ENFORCE_GTID_CONSISTENCY = OFF;
3929 SET GLOBAL SQL_NOTES = @old_sql_notes;
3930 include/rpl_end.inc
3931 include/end_replace_gtid_combination.inc [gtid_mode=off/on -> default_storage_engine=InnoDB/MyISAM]