Debian Codegraph @

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

raw
1 include/begin_replace_gtid_combination.inc [gtid_mode=off/on -> binlog_direct_non_transactional_updates=0/1]
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 myisam1 (a INT) ENGINE = MyISAM;
14 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
15 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
16 ---- InnoDB followed by MyISAM in one trx ----
17 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
18 SET GTID_NEXT = 'AUTOMATIC';
19 BEGIN; INSERT INTO innodb VALUES (1);
20 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
21 INSERT INTO myisam1 VALUES (1);
22 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
23 include/assert.inc [One warning/error should be generated.]
24 include/assert.inc [It should be an Error, not a Warning.]
25 include/assert.inc [Text should be "violates GTID consistency"]
26 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
27 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
28 ROLLBACK;
29 SET GTID_NEXT = 'AUTOMATIC';
30 include/assert.inc [Both counters should be 0]
31 ---- InnoDB and MyISAM in one autocommit statement ----
32 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
33 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
34 SET GTID_NEXT = 'AUTOMATIC';
35 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
36 INSERT INTO innodb VALUES (1);
37 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
38 include/assert.inc [One warning/error should be generated.]
39 include/assert.inc [It should be an Error, not a Warning.]
40 include/assert.inc [Text should be "violates GTID consistency"]
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 ---- InnoDB and MyISAM in one statement inside trx ----
47 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
48 SET GTID_NEXT = 'AUTOMATIC';
49 BEGIN;
50 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
51 INSERT INTO innodb VALUES (1);
52 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
53 include/assert.inc [One warning/error should be generated.]
54 include/assert.inc [It should be an Error, not a Warning.]
55 include/assert.inc [Text should be "violates GTID consistency"]
56 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
57 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
58 ROLLBACK;
59 SET GTID_NEXT = 'AUTOMATIC';
60 include/assert.inc [Both counters should be 0]
61 DROP TRIGGER trig;
62 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
63 SET SESSION BINLOG_FORMAT = STATEMENT;
64 Warnings:
65 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
66 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
67 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
68 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
69 SET GTID_NEXT = 'AUTOMATIC';
70 BEGIN; INSERT INTO innodb VALUES (1);
71 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
72 INSERT INTO tmp_myisam1 VALUES (1);
73 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
74 include/assert.inc [One warning/error should be generated.]
75 include/assert.inc [It should be an Error, not a Warning.]
76 include/assert.inc [Text should be "violates GTID consistency"]
77 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
78 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
79 ROLLBACK;
80 SET GTID_NEXT = 'AUTOMATIC';
81 include/assert.inc [Both counters should be 0]
82 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
83 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
84 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
85 SET GTID_NEXT = 'AUTOMATIC';
86 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
87 INSERT INTO innodb VALUES (1);
88 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
89 include/assert.inc [One warning/error should be generated.]
90 include/assert.inc [It should be an Error, not a Warning.]
91 include/assert.inc [Text should be "violates GTID consistency"]
92 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
93 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
94 ROLLBACK;
95 SET GTID_NEXT = 'AUTOMATIC';
96 include/assert.inc [Both counters should be 0]
97 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
98 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC
99 SET GTID_NEXT = 'AUTOMATIC';
100 BEGIN;
101 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
102 INSERT INTO innodb VALUES (1);
103 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
104 include/assert.inc [One warning/error should be generated.]
105 include/assert.inc [It should be an Error, not a Warning.]
106 include/assert.inc [Text should be "violates GTID consistency"]
107 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
108 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
109 ROLLBACK;
110 SET GTID_NEXT = 'AUTOMATIC';
111 include/assert.inc [Both counters should be 0]
112 DROP TRIGGER trig;
113 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
114 SET BINLOG_FORMAT = #;
115 Warnings:
116 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
117 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=ON_PERMISSIVE GTID_NEXT=ANONYMOUS ########
118 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
119 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
120 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
121 ---- InnoDB followed by MyISAM in one trx ----
122 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
123 SET GTID_NEXT = 'ANONYMOUS';
124 BEGIN; INSERT INTO innodb VALUES (1);
125 [START] INSERT INTO myisam1 VALUES (1);
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 1]
128 [END] INSERT INTO myisam1 VALUES (1);
129 include/assert.inc [No warning or error should be generated.]
130 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
131 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
132 ROLLBACK;
133 SET GTID_NEXT = 'AUTOMATIC';
134 include/assert.inc [Both counters should be 0]
135 ---- InnoDB and MyISAM in one autocommit statement ----
136 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
137 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
138 SET GTID_NEXT = 'ANONYMOUS';
139 [START] INSERT INTO innodb VALUES (1);
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 1]
142 [END] INSERT INTO innodb VALUES (1);
143 include/assert.inc [No warning or error should be generated.]
144 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
145 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
146 ROLLBACK;
147 SET GTID_NEXT = 'AUTOMATIC';
148 include/assert.inc [Both counters should be 0]
149 ---- InnoDB and MyISAM in one statement inside trx ----
150 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
151 SET GTID_NEXT = 'ANONYMOUS';
152 BEGIN;
153 [START] INSERT INTO innodb VALUES (1);
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 1]
156 [END] INSERT INTO innodb VALUES (1);
157 include/assert.inc [No warning or error should be generated.]
158 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
159 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
160 ROLLBACK;
161 SET GTID_NEXT = 'AUTOMATIC';
162 include/assert.inc [Both counters should be 0]
163 DROP TRIGGER trig;
164 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
165 SET SESSION BINLOG_FORMAT = STATEMENT;
166 Warnings:
167 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
168 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
169 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
170 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
171 SET GTID_NEXT = 'ANONYMOUS';
172 BEGIN; INSERT INTO innodb VALUES (1);
173 [START] INSERT INTO tmp_myisam1 VALUES (1);
174 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
175 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
176 [END] INSERT INTO tmp_myisam1 VALUES (1);
177 include/assert.inc [No warning or error should be generated.]
178 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
179 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
180 ROLLBACK;
181 Warnings:
182 Warning 1196 Some non-transactional changed tables couldn't be rolled back
183 SET GTID_NEXT = 'AUTOMATIC';
184 include/assert.inc [Both counters should be 0]
185 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
186 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
187 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
188 SET GTID_NEXT = 'ANONYMOUS';
189 [START] INSERT INTO innodb VALUES (1);
190 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
191 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
192 [END] INSERT INTO innodb VALUES (1);
193 include/assert.inc [No warning or error should be generated.]
194 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
195 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
196 ROLLBACK;
197 SET GTID_NEXT = 'AUTOMATIC';
198 include/assert.inc [Both counters should be 0]
199 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
200 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS
201 SET GTID_NEXT = 'ANONYMOUS';
202 BEGIN;
203 [START] INSERT INTO innodb VALUES (1);
204 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
205 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
206 [END] INSERT INTO innodb VALUES (1);
207 include/assert.inc [No warning or error should be generated.]
208 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
209 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
210 ROLLBACK;
211 SET GTID_NEXT = 'AUTOMATIC';
212 include/assert.inc [Both counters should be 0]
213 DROP TRIGGER trig;
214 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
215 SET BINLOG_FORMAT = #;
216 Warnings:
217 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
218 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=ON_PERMISSIVE GTID_NEXT=GTID ########
219 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
220 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
221 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
222 ---- InnoDB followed by MyISAM in one trx ----
223 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
224 SET GTID_NEXT = 'GTID';
225 BEGIN; INSERT INTO innodb VALUES (1);
226 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
227 INSERT INTO myisam1 VALUES (1);
228 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
229 include/assert.inc [One warning/error should be generated.]
230 include/assert.inc [It should be an Error, not a Warning.]
231 include/assert.inc [Text should be "violates GTID consistency"]
232 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
233 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
234 ROLLBACK;
235 SET GTID_NEXT = 'AUTOMATIC';
236 include/assert.inc [Both counters should be 0]
237 ---- InnoDB and MyISAM in one autocommit statement ----
238 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
239 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
240 SET GTID_NEXT = 'GTID';
241 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
242 INSERT INTO innodb VALUES (1);
243 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
244 include/assert.inc [One warning/error should be generated.]
245 include/assert.inc [It should be an Error, not a Warning.]
246 include/assert.inc [Text should be "violates GTID consistency"]
247 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
248 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
249 ROLLBACK;
250 SET GTID_NEXT = 'AUTOMATIC';
251 include/assert.inc [Both counters should be 0]
252 ---- InnoDB and MyISAM in one statement inside trx ----
253 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
254 SET GTID_NEXT = 'GTID';
255 BEGIN;
256 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
257 INSERT INTO innodb VALUES (1);
258 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
259 include/assert.inc [One warning/error should be generated.]
260 include/assert.inc [It should be an Error, not a Warning.]
261 include/assert.inc [Text should be "violates GTID consistency"]
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 TRIGGER trig;
268 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
269 SET SESSION BINLOG_FORMAT = STATEMENT;
270 Warnings:
271 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
272 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
273 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
274 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
275 SET GTID_NEXT = 'GTID';
276 BEGIN; INSERT INTO innodb VALUES (1);
277 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
278 INSERT INTO tmp_myisam1 VALUES (1);
279 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
280 include/assert.inc [One warning/error should be generated.]
281 include/assert.inc [It should be an Error, not a Warning.]
282 include/assert.inc [Text should be "violates GTID consistency"]
283 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
284 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
285 ROLLBACK;
286 SET GTID_NEXT = 'AUTOMATIC';
287 include/assert.inc [Both counters should be 0]
288 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
289 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
290 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
291 SET GTID_NEXT = 'GTID';
292 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
293 INSERT INTO innodb VALUES (1);
294 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
295 include/assert.inc [One warning/error should be generated.]
296 include/assert.inc [It should be an Error, not a Warning.]
297 include/assert.inc [Text should be "violates GTID consistency"]
298 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
299 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
300 ROLLBACK;
301 SET GTID_NEXT = 'AUTOMATIC';
302 include/assert.inc [Both counters should be 0]
303 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
304 # enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID
305 SET GTID_NEXT = 'GTID';
306 BEGIN;
307 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
308 INSERT INTO innodb VALUES (1);
309 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
310 include/assert.inc [One warning/error should be generated.]
311 include/assert.inc [It should be an Error, not a Warning.]
312 include/assert.inc [Text should be "violates GTID consistency"]
313 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
314 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
315 ROLLBACK;
316 SET GTID_NEXT = 'AUTOMATIC';
317 include/assert.inc [Both counters should be 0]
318 DROP TRIGGER trig;
319 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
320 SET BINLOG_FORMAT = #;
321 Warnings:
322 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
323 SET GLOBAL GTID_MODE = 1;
324 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF_PERMISSIVE GTID_NEXT=AUTOMATIC ########
325 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
326 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
327 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
328 ---- InnoDB followed by MyISAM in one trx ----
329 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
330 SET GTID_NEXT = 'AUTOMATIC';
331 BEGIN; INSERT INTO innodb VALUES (1);
332 [START] INSERT INTO myisam1 VALUES (1);
333 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
334 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
335 [END] INSERT INTO myisam1 VALUES (1);
336 include/assert.inc [No warning or error should be generated.]
337 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
338 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
339 ROLLBACK;
340 SET GTID_NEXT = 'AUTOMATIC';
341 include/assert.inc [Both counters should be 0]
342 ---- InnoDB and MyISAM in one autocommit statement ----
343 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
344 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
345 SET GTID_NEXT = 'AUTOMATIC';
346 [START] INSERT INTO innodb VALUES (1);
347 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
348 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
349 [END] INSERT INTO innodb VALUES (1);
350 include/assert.inc [No warning or error should be generated.]
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 ROLLBACK;
354 SET GTID_NEXT = 'AUTOMATIC';
355 include/assert.inc [Both counters should be 0]
356 ---- InnoDB and MyISAM in one statement inside trx ----
357 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
358 SET GTID_NEXT = 'AUTOMATIC';
359 BEGIN;
360 [START] INSERT INTO innodb VALUES (1);
361 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
362 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
363 [END] INSERT INTO innodb VALUES (1);
364 include/assert.inc [No warning or error should be generated.]
365 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
366 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
367 ROLLBACK;
368 SET GTID_NEXT = 'AUTOMATIC';
369 include/assert.inc [Both counters should be 0]
370 DROP TRIGGER trig;
371 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
372 SET SESSION BINLOG_FORMAT = STATEMENT;
373 Warnings:
374 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
375 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
376 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
377 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
378 SET GTID_NEXT = 'AUTOMATIC';
379 BEGIN; INSERT INTO innodb VALUES (1);
380 [START] INSERT INTO tmp_myisam1 VALUES (1);
381 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
382 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
383 [END] INSERT INTO tmp_myisam1 VALUES (1);
384 include/assert.inc [No warning or error should be generated.]
385 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
386 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
387 ROLLBACK;
388 Warnings:
389 Warning 1196 Some non-transactional changed tables couldn't be rolled back
390 SET GTID_NEXT = 'AUTOMATIC';
391 include/assert.inc [Both counters should be 0]
392 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
393 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
394 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
395 SET GTID_NEXT = 'AUTOMATIC';
396 [START] INSERT INTO innodb VALUES (1);
397 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
398 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
399 [END] INSERT INTO innodb VALUES (1);
400 include/assert.inc [No warning or error should be generated.]
401 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
402 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
403 ROLLBACK;
404 SET GTID_NEXT = 'AUTOMATIC';
405 include/assert.inc [Both counters should be 0]
406 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
407 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC
408 SET GTID_NEXT = 'AUTOMATIC';
409 BEGIN;
410 [START] INSERT INTO innodb VALUES (1);
411 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
412 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
413 [END] INSERT INTO innodb VALUES (1);
414 include/assert.inc [No warning or error should be generated.]
415 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
416 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
417 ROLLBACK;
418 SET GTID_NEXT = 'AUTOMATIC';
419 include/assert.inc [Both counters should be 0]
420 DROP TRIGGER trig;
421 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
422 SET BINLOG_FORMAT = #;
423 Warnings:
424 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
425 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF_PERMISSIVE GTID_NEXT=ANONYMOUS ########
426 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
427 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
428 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
429 ---- InnoDB followed by MyISAM in one trx ----
430 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
431 SET GTID_NEXT = 'ANONYMOUS';
432 BEGIN; INSERT INTO innodb VALUES (1);
433 [START] INSERT INTO myisam1 VALUES (1);
434 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
435 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
436 [END] INSERT INTO myisam1 VALUES (1);
437 include/assert.inc [No warning or error should be generated.]
438 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
439 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
440 ROLLBACK;
441 SET GTID_NEXT = 'AUTOMATIC';
442 include/assert.inc [Both counters should be 0]
443 ---- InnoDB and MyISAM in one autocommit statement ----
444 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
445 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
446 SET GTID_NEXT = 'ANONYMOUS';
447 [START] INSERT INTO innodb VALUES (1);
448 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
449 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
450 [END] INSERT INTO innodb VALUES (1);
451 include/assert.inc [No warning or error should be generated.]
452 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
453 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
454 ROLLBACK;
455 SET GTID_NEXT = 'AUTOMATIC';
456 include/assert.inc [Both counters should be 0]
457 ---- InnoDB and MyISAM in one statement inside trx ----
458 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
459 SET GTID_NEXT = 'ANONYMOUS';
460 BEGIN;
461 [START] INSERT INTO innodb VALUES (1);
462 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
463 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
464 [END] INSERT INTO innodb VALUES (1);
465 include/assert.inc [No warning or error should be generated.]
466 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
467 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
468 ROLLBACK;
469 SET GTID_NEXT = 'AUTOMATIC';
470 include/assert.inc [Both counters should be 0]
471 DROP TRIGGER trig;
472 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
473 SET SESSION BINLOG_FORMAT = STATEMENT;
474 Warnings:
475 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
476 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
477 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
478 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
479 SET GTID_NEXT = 'ANONYMOUS';
480 BEGIN; INSERT INTO innodb VALUES (1);
481 [START] INSERT INTO tmp_myisam1 VALUES (1);
482 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
483 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
484 [END] INSERT INTO tmp_myisam1 VALUES (1);
485 include/assert.inc [No warning or error should be generated.]
486 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
487 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
488 ROLLBACK;
489 Warnings:
490 Warning 1196 Some non-transactional changed tables couldn't be rolled back
491 SET GTID_NEXT = 'AUTOMATIC';
492 include/assert.inc [Both counters should be 0]
493 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
494 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
495 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
496 SET GTID_NEXT = 'ANONYMOUS';
497 [START] INSERT INTO innodb VALUES (1);
498 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
499 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
500 [END] INSERT INTO innodb VALUES (1);
501 include/assert.inc [No warning or error should be generated.]
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 ROLLBACK;
505 SET GTID_NEXT = 'AUTOMATIC';
506 include/assert.inc [Both counters should be 0]
507 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
508 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS
509 SET GTID_NEXT = 'ANONYMOUS';
510 BEGIN;
511 [START] INSERT INTO innodb VALUES (1);
512 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
513 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
514 [END] INSERT INTO innodb VALUES (1);
515 include/assert.inc [No warning or error should be generated.]
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 1]
518 ROLLBACK;
519 SET GTID_NEXT = 'AUTOMATIC';
520 include/assert.inc [Both counters should be 0]
521 DROP TRIGGER trig;
522 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
523 SET BINLOG_FORMAT = #;
524 Warnings:
525 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
526 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF_PERMISSIVE GTID_NEXT=GTID ########
527 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
528 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
529 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
530 ---- InnoDB followed by MyISAM in one trx ----
531 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
532 SET GTID_NEXT = 'GTID';
533 BEGIN; INSERT INTO innodb VALUES (1);
534 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
535 INSERT INTO myisam1 VALUES (1);
536 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
537 include/assert.inc [One warning/error should be generated.]
538 include/assert.inc [It should be an Error, not a Warning.]
539 include/assert.inc [Text should be "violates GTID consistency"]
540 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
541 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
542 ROLLBACK;
543 SET GTID_NEXT = 'AUTOMATIC';
544 include/assert.inc [Both counters should be 0]
545 ---- InnoDB and MyISAM in one autocommit statement ----
546 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
547 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
548 SET GTID_NEXT = 'GTID';
549 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
550 INSERT INTO innodb VALUES (1);
551 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
552 include/assert.inc [One warning/error should be generated.]
553 include/assert.inc [It should be an Error, not a Warning.]
554 include/assert.inc [Text should be "violates GTID consistency"]
555 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
556 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
557 ROLLBACK;
558 SET GTID_NEXT = 'AUTOMATIC';
559 include/assert.inc [Both counters should be 0]
560 ---- InnoDB and MyISAM in one statement inside trx ----
561 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
562 SET GTID_NEXT = 'GTID';
563 BEGIN;
564 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
565 INSERT INTO innodb VALUES (1);
566 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
567 include/assert.inc [One warning/error should be generated.]
568 include/assert.inc [It should be an Error, not a Warning.]
569 include/assert.inc [Text should be "violates GTID consistency"]
570 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
571 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
572 ROLLBACK;
573 SET GTID_NEXT = 'AUTOMATIC';
574 include/assert.inc [Both counters should be 0]
575 DROP TRIGGER trig;
576 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
577 SET SESSION BINLOG_FORMAT = STATEMENT;
578 Warnings:
579 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
580 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
581 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
582 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
583 SET GTID_NEXT = 'GTID';
584 BEGIN; INSERT INTO innodb VALUES (1);
585 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
586 INSERT INTO tmp_myisam1 VALUES (1);
587 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
588 include/assert.inc [One warning/error should be generated.]
589 include/assert.inc [It should be an Error, not a Warning.]
590 include/assert.inc [Text should be "violates GTID consistency"]
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 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
597 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
598 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
599 SET GTID_NEXT = 'GTID';
600 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
601 INSERT INTO innodb VALUES (1);
602 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
603 include/assert.inc [One warning/error should be generated.]
604 include/assert.inc [It should be an Error, not a Warning.]
605 include/assert.inc [Text should be "violates GTID consistency"]
606 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
607 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
608 ROLLBACK;
609 SET GTID_NEXT = 'AUTOMATIC';
610 include/assert.inc [Both counters should be 0]
611 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
612 # enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID
613 SET GTID_NEXT = 'GTID';
614 BEGIN;
615 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
616 INSERT INTO innodb VALUES (1);
617 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
618 include/assert.inc [One warning/error should be generated.]
619 include/assert.inc [It should be an Error, not a Warning.]
620 include/assert.inc [Text should be "violates GTID consistency"]
621 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
622 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
623 ROLLBACK;
624 SET GTID_NEXT = 'AUTOMATIC';
625 include/assert.inc [Both counters should be 0]
626 DROP TRIGGER trig;
627 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
628 SET BINLOG_FORMAT = #;
629 Warnings:
630 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
631 SET GLOBAL GTID_MODE = 0;
632 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF GTID_NEXT=AUTOMATIC ########
633 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
634 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
635 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
636 ---- InnoDB followed by MyISAM in one trx ----
637 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
638 SET GTID_NEXT = 'AUTOMATIC';
639 BEGIN; INSERT INTO innodb VALUES (1);
640 [START] INSERT INTO myisam1 VALUES (1);
641 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
642 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
643 [END] INSERT INTO myisam1 VALUES (1);
644 include/assert.inc [No warning or error should be generated.]
645 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
646 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
647 ROLLBACK;
648 SET GTID_NEXT = 'AUTOMATIC';
649 include/assert.inc [Both counters should be 0]
650 ---- InnoDB and MyISAM in one autocommit statement ----
651 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
652 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
653 SET GTID_NEXT = 'AUTOMATIC';
654 [START] INSERT INTO innodb VALUES (1);
655 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
656 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
657 [END] INSERT INTO innodb VALUES (1);
658 include/assert.inc [No warning or error should be generated.]
659 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
660 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
661 ROLLBACK;
662 SET GTID_NEXT = 'AUTOMATIC';
663 include/assert.inc [Both counters should be 0]
664 ---- InnoDB and MyISAM in one statement inside trx ----
665 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
666 SET GTID_NEXT = 'AUTOMATIC';
667 BEGIN;
668 [START] INSERT INTO innodb VALUES (1);
669 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
670 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
671 [END] INSERT INTO innodb VALUES (1);
672 include/assert.inc [No warning or error should be generated.]
673 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
674 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
675 ROLLBACK;
676 SET GTID_NEXT = 'AUTOMATIC';
677 include/assert.inc [Both counters should be 0]
678 DROP TRIGGER trig;
679 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
680 SET SESSION BINLOG_FORMAT = STATEMENT;
681 Warnings:
682 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
683 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
684 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
685 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
686 SET GTID_NEXT = 'AUTOMATIC';
687 BEGIN; INSERT INTO innodb VALUES (1);
688 [START] INSERT INTO tmp_myisam1 VALUES (1);
689 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
690 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
691 [END] INSERT INTO tmp_myisam1 VALUES (1);
692 include/assert.inc [No warning or error should be generated.]
693 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
694 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
695 ROLLBACK;
696 Warnings:
697 Warning 1196 Some non-transactional changed tables couldn't be rolled back
698 SET GTID_NEXT = 'AUTOMATIC';
699 include/assert.inc [Both counters should be 0]
700 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
701 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
702 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
703 SET GTID_NEXT = 'AUTOMATIC';
704 [START] INSERT INTO innodb VALUES (1);
705 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
706 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
707 [END] INSERT INTO innodb VALUES (1);
708 include/assert.inc [No warning or error should be generated.]
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 ROLLBACK;
712 SET GTID_NEXT = 'AUTOMATIC';
713 include/assert.inc [Both counters should be 0]
714 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
715 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC
716 SET GTID_NEXT = 'AUTOMATIC';
717 BEGIN;
718 [START] INSERT INTO innodb VALUES (1);
719 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
720 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
721 [END] INSERT INTO innodb VALUES (1);
722 include/assert.inc [No warning or error should be generated.]
723 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
724 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
725 ROLLBACK;
726 SET GTID_NEXT = 'AUTOMATIC';
727 include/assert.inc [Both counters should be 0]
728 DROP TRIGGER trig;
729 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
730 SET BINLOG_FORMAT = #;
731 Warnings:
732 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
733 ######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF GTID_NEXT=ANONYMOUS ########
734 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
735 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
736 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
737 ---- InnoDB followed by MyISAM in one trx ----
738 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
739 SET GTID_NEXT = 'ANONYMOUS';
740 BEGIN; INSERT INTO innodb VALUES (1);
741 [START] INSERT INTO myisam1 VALUES (1);
742 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
743 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
744 [END] INSERT INTO myisam1 VALUES (1);
745 include/assert.inc [No warning or error should be generated.]
746 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
747 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
748 ROLLBACK;
749 SET GTID_NEXT = 'AUTOMATIC';
750 include/assert.inc [Both counters should be 0]
751 ---- InnoDB and MyISAM in one autocommit statement ----
752 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
753 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
754 SET GTID_NEXT = 'ANONYMOUS';
755 [START] INSERT INTO innodb VALUES (1);
756 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
757 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
758 [END] INSERT INTO innodb VALUES (1);
759 include/assert.inc [No warning or error should be generated.]
760 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
761 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
762 ROLLBACK;
763 SET GTID_NEXT = 'AUTOMATIC';
764 include/assert.inc [Both counters should be 0]
765 ---- InnoDB and MyISAM in one statement inside trx ----
766 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
767 SET GTID_NEXT = 'ANONYMOUS';
768 BEGIN;
769 [START] INSERT INTO innodb VALUES (1);
770 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
771 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
772 [END] INSERT INTO innodb VALUES (1);
773 include/assert.inc [No warning or error should be generated.]
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 1]
776 ROLLBACK;
777 SET GTID_NEXT = 'AUTOMATIC';
778 include/assert.inc [Both counters should be 0]
779 DROP TRIGGER trig;
780 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
781 SET SESSION BINLOG_FORMAT = STATEMENT;
782 Warnings:
783 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
784 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
785 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
786 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
787 SET GTID_NEXT = 'ANONYMOUS';
788 BEGIN; INSERT INTO innodb VALUES (1);
789 [START] INSERT INTO tmp_myisam1 VALUES (1);
790 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
791 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
792 [END] INSERT INTO tmp_myisam1 VALUES (1);
793 include/assert.inc [No warning or error should be generated.]
794 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
795 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
796 ROLLBACK;
797 Warnings:
798 Warning 1196 Some non-transactional changed tables couldn't be rolled back
799 SET GTID_NEXT = 'AUTOMATIC';
800 include/assert.inc [Both counters should be 0]
801 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
802 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
803 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
804 SET GTID_NEXT = 'ANONYMOUS';
805 [START] INSERT INTO innodb VALUES (1);
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 1]
808 [END] INSERT INTO innodb VALUES (1);
809 include/assert.inc [No warning or error should be generated.]
810 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
811 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
812 ROLLBACK;
813 SET GTID_NEXT = 'AUTOMATIC';
814 include/assert.inc [Both counters should be 0]
815 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
816 # enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS
817 SET GTID_NEXT = 'ANONYMOUS';
818 BEGIN;
819 [START] INSERT INTO innodb VALUES (1);
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 1]
822 [END] INSERT INTO innodb VALUES (1);
823 include/assert.inc [No warning or error should be generated.]
824 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
825 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
826 ROLLBACK;
827 SET GTID_NEXT = 'AUTOMATIC';
828 include/assert.inc [Both counters should be 0]
829 DROP TRIGGER trig;
830 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
831 SET BINLOG_FORMAT = #;
832 Warnings:
833 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
834 SET GLOBAL ENFORCE_GTID_CONSISTENCY = 1;
835 SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
836 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
837 SET GLOBAL GTID_MODE = ON;
838 SET GLOBAL GTID_MODE = 3;
839 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON GTID_NEXT=AUTOMATIC ########
840 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
841 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
842 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
843 ---- InnoDB followed by MyISAM in one trx ----
844 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
845 SET GTID_NEXT = 'AUTOMATIC';
846 BEGIN; INSERT INTO innodb VALUES (1);
847 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
848 INSERT INTO myisam1 VALUES (1);
849 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
850 include/assert.inc [One warning/error should be generated.]
851 include/assert.inc [It should be an Error, not a Warning.]
852 include/assert.inc [Text should be "violates GTID consistency"]
853 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
854 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
855 ROLLBACK;
856 SET GTID_NEXT = 'AUTOMATIC';
857 include/assert.inc [Both counters should be 0]
858 ---- InnoDB and MyISAM in one autocommit statement ----
859 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
860 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
861 SET GTID_NEXT = 'AUTOMATIC';
862 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
863 INSERT INTO innodb VALUES (1);
864 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
865 include/assert.inc [One warning/error should be generated.]
866 include/assert.inc [It should be an Error, not a Warning.]
867 include/assert.inc [Text should be "violates GTID consistency"]
868 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
869 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
870 ROLLBACK;
871 SET GTID_NEXT = 'AUTOMATIC';
872 include/assert.inc [Both counters should be 0]
873 ---- InnoDB and MyISAM in one statement inside trx ----
874 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
875 SET GTID_NEXT = 'AUTOMATIC';
876 BEGIN;
877 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
878 INSERT INTO innodb VALUES (1);
879 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
880 include/assert.inc [One warning/error should be generated.]
881 include/assert.inc [It should be an Error, not a Warning.]
882 include/assert.inc [Text should be "violates GTID consistency"]
883 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
884 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
885 ROLLBACK;
886 SET GTID_NEXT = 'AUTOMATIC';
887 include/assert.inc [Both counters should be 0]
888 DROP TRIGGER trig;
889 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
890 SET SESSION BINLOG_FORMAT = STATEMENT;
891 Warnings:
892 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
893 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
894 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
895 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
896 SET GTID_NEXT = 'AUTOMATIC';
897 BEGIN; INSERT INTO innodb VALUES (1);
898 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
899 INSERT INTO tmp_myisam1 VALUES (1);
900 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
901 include/assert.inc [One warning/error should be generated.]
902 include/assert.inc [It should be an Error, not a Warning.]
903 include/assert.inc [Text should be "violates GTID consistency"]
904 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
905 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
906 ROLLBACK;
907 SET GTID_NEXT = 'AUTOMATIC';
908 include/assert.inc [Both counters should be 0]
909 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
910 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
911 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
912 SET GTID_NEXT = 'AUTOMATIC';
913 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
914 INSERT INTO innodb VALUES (1);
915 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
916 include/assert.inc [One warning/error should be generated.]
917 include/assert.inc [It should be an Error, not a Warning.]
918 include/assert.inc [Text should be "violates GTID consistency"]
919 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
920 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
921 ROLLBACK;
922 SET GTID_NEXT = 'AUTOMATIC';
923 include/assert.inc [Both counters should be 0]
924 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
925 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC
926 SET GTID_NEXT = 'AUTOMATIC';
927 BEGIN;
928 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
929 INSERT INTO innodb VALUES (1);
930 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
931 include/assert.inc [One warning/error should be generated.]
932 include/assert.inc [It should be an Error, not a Warning.]
933 include/assert.inc [Text should be "violates GTID consistency"]
934 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
935 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
936 ROLLBACK;
937 SET GTID_NEXT = 'AUTOMATIC';
938 include/assert.inc [Both counters should be 0]
939 DROP TRIGGER trig;
940 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
941 SET BINLOG_FORMAT = #;
942 Warnings:
943 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
944 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON GTID_NEXT=GTID ########
945 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
946 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
947 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
948 ---- InnoDB followed by MyISAM in one trx ----
949 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
950 SET GTID_NEXT = 'GTID';
951 BEGIN; INSERT INTO innodb VALUES (1);
952 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
953 INSERT INTO myisam1 VALUES (1);
954 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
955 include/assert.inc [One warning/error should be generated.]
956 include/assert.inc [It should be an Error, not a Warning.]
957 include/assert.inc [Text should be "violates GTID consistency"]
958 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
959 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
960 ROLLBACK;
961 SET GTID_NEXT = 'AUTOMATIC';
962 include/assert.inc [Both counters should be 0]
963 ---- InnoDB and MyISAM in one autocommit statement ----
964 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
965 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
966 SET GTID_NEXT = 'GTID';
967 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
968 INSERT INTO innodb VALUES (1);
969 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
970 include/assert.inc [One warning/error should be generated.]
971 include/assert.inc [It should be an Error, not a Warning.]
972 include/assert.inc [Text should be "violates GTID consistency"]
973 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
974 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
975 ROLLBACK;
976 SET GTID_NEXT = 'AUTOMATIC';
977 include/assert.inc [Both counters should be 0]
978 ---- InnoDB and MyISAM in one statement inside trx ----
979 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
980 SET GTID_NEXT = 'GTID';
981 BEGIN;
982 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
983 INSERT INTO innodb VALUES (1);
984 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
985 include/assert.inc [One warning/error should be generated.]
986 include/assert.inc [It should be an Error, not a Warning.]
987 include/assert.inc [Text should be "violates GTID consistency"]
988 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
989 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
990 ROLLBACK;
991 SET GTID_NEXT = 'AUTOMATIC';
992 include/assert.inc [Both counters should be 0]
993 DROP TRIGGER trig;
994 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
995 SET SESSION BINLOG_FORMAT = STATEMENT;
996 Warnings:
997 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
998 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
999 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
1000 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1001 SET GTID_NEXT = 'GTID';
1002 BEGIN; INSERT INTO innodb VALUES (1);
1003 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1004 INSERT INTO tmp_myisam1 VALUES (1);
1005 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1006 include/assert.inc [One warning/error should be generated.]
1007 include/assert.inc [It should be an Error, not a Warning.]
1008 include/assert.inc [Text should be "violates GTID consistency"]
1009 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1010 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1011 ROLLBACK;
1012 SET GTID_NEXT = 'AUTOMATIC';
1013 include/assert.inc [Both counters should be 0]
1014 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
1015 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
1016 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1017 SET GTID_NEXT = 'GTID';
1018 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1019 INSERT INTO innodb VALUES (1);
1020 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1021 include/assert.inc [One warning/error should be generated.]
1022 include/assert.inc [It should be an Error, not a Warning.]
1023 include/assert.inc [Text should be "violates GTID consistency"]
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 ROLLBACK;
1027 SET GTID_NEXT = 'AUTOMATIC';
1028 include/assert.inc [Both counters should be 0]
1029 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
1030 # enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID
1031 SET GTID_NEXT = 'GTID';
1032 BEGIN;
1033 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1034 INSERT INTO innodb VALUES (1);
1035 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1036 include/assert.inc [One warning/error should be generated.]
1037 include/assert.inc [It should be an Error, not a Warning.]
1038 include/assert.inc [Text should be "violates GTID consistency"]
1039 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1040 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1041 ROLLBACK;
1042 SET GTID_NEXT = 'AUTOMATIC';
1043 include/assert.inc [Both counters should be 0]
1044 DROP TRIGGER trig;
1045 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
1046 SET BINLOG_FORMAT = #;
1047 Warnings:
1048 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1049 SET GLOBAL GTID_MODE = 2;
1050 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON_PERMISSIVE GTID_NEXT=AUTOMATIC ########
1051 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
1052 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
1053 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
1054 ---- InnoDB followed by MyISAM in one trx ----
1055 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1056 SET GTID_NEXT = 'AUTOMATIC';
1057 BEGIN; INSERT INTO innodb VALUES (1);
1058 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1059 INSERT INTO myisam1 VALUES (1);
1060 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1061 include/assert.inc [One warning/error should be generated.]
1062 include/assert.inc [It should be an Error, not a Warning.]
1063 include/assert.inc [Text should be "violates GTID consistency"]
1064 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1065 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1066 ROLLBACK;
1067 SET GTID_NEXT = 'AUTOMATIC';
1068 include/assert.inc [Both counters should be 0]
1069 ---- InnoDB and MyISAM in one autocommit statement ----
1070 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
1071 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1072 SET GTID_NEXT = 'AUTOMATIC';
1073 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1074 INSERT INTO innodb VALUES (1);
1075 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1076 include/assert.inc [One warning/error should be generated.]
1077 include/assert.inc [It should be an Error, not a Warning.]
1078 include/assert.inc [Text should be "violates GTID consistency"]
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 ---- InnoDB and MyISAM in one statement inside trx ----
1085 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1086 SET GTID_NEXT = 'AUTOMATIC';
1087 BEGIN;
1088 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1089 INSERT INTO innodb VALUES (1);
1090 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1091 include/assert.inc [One warning/error should be generated.]
1092 include/assert.inc [It should be an Error, not a Warning.]
1093 include/assert.inc [Text should be "violates GTID consistency"]
1094 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1095 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1096 ROLLBACK;
1097 SET GTID_NEXT = 'AUTOMATIC';
1098 include/assert.inc [Both counters should be 0]
1099 DROP TRIGGER trig;
1100 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
1101 SET SESSION BINLOG_FORMAT = STATEMENT;
1102 Warnings:
1103 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1104 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
1105 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
1106 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1107 SET GTID_NEXT = 'AUTOMATIC';
1108 BEGIN; INSERT INTO innodb VALUES (1);
1109 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1110 INSERT INTO tmp_myisam1 VALUES (1);
1111 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1112 include/assert.inc [One warning/error should be generated.]
1113 include/assert.inc [It should be an Error, not a Warning.]
1114 include/assert.inc [Text should be "violates GTID consistency"]
1115 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1116 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1117 ROLLBACK;
1118 SET GTID_NEXT = 'AUTOMATIC';
1119 include/assert.inc [Both counters should be 0]
1120 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
1121 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
1122 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1123 SET GTID_NEXT = 'AUTOMATIC';
1124 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1125 INSERT INTO innodb VALUES (1);
1126 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1127 include/assert.inc [One warning/error should be generated.]
1128 include/assert.inc [It should be an Error, not a Warning.]
1129 include/assert.inc [Text should be "violates GTID consistency"]
1130 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1131 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1132 ROLLBACK;
1133 SET GTID_NEXT = 'AUTOMATIC';
1134 include/assert.inc [Both counters should be 0]
1135 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
1136 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC
1137 SET GTID_NEXT = 'AUTOMATIC';
1138 BEGIN;
1139 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1140 INSERT INTO innodb VALUES (1);
1141 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1142 include/assert.inc [One warning/error should be generated.]
1143 include/assert.inc [It should be an Error, not a Warning.]
1144 include/assert.inc [Text should be "violates GTID consistency"]
1145 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1146 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1147 ROLLBACK;
1148 SET GTID_NEXT = 'AUTOMATIC';
1149 include/assert.inc [Both counters should be 0]
1150 DROP TRIGGER trig;
1151 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
1152 SET BINLOG_FORMAT = #;
1153 Warnings:
1154 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1155 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON_PERMISSIVE GTID_NEXT=ANONYMOUS ########
1156 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
1157 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
1158 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
1159 ---- InnoDB followed by MyISAM in one trx ----
1160 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1161 SET GTID_NEXT = 'ANONYMOUS';
1162 BEGIN; INSERT INTO innodb VALUES (1);
1163 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1164 INSERT INTO myisam1 VALUES (1);
1165 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1166 include/assert.inc [One warning/error should be generated.]
1167 include/assert.inc [It should be an Error, not a Warning.]
1168 include/assert.inc [Text should be "violates GTID consistency"]
1169 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1170 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1171 ROLLBACK;
1172 SET GTID_NEXT = 'AUTOMATIC';
1173 include/assert.inc [Both counters should be 0]
1174 ---- InnoDB and MyISAM in one autocommit statement ----
1175 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
1176 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1177 SET GTID_NEXT = 'ANONYMOUS';
1178 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1179 INSERT INTO innodb VALUES (1);
1180 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1181 include/assert.inc [One warning/error should be generated.]
1182 include/assert.inc [It should be an Error, not a Warning.]
1183 include/assert.inc [Text should be "violates GTID consistency"]
1184 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1185 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1186 ROLLBACK;
1187 SET GTID_NEXT = 'AUTOMATIC';
1188 include/assert.inc [Both counters should be 0]
1189 ---- InnoDB and MyISAM in one statement inside trx ----
1190 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1191 SET GTID_NEXT = 'ANONYMOUS';
1192 BEGIN;
1193 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1194 INSERT INTO innodb VALUES (1);
1195 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1196 include/assert.inc [One warning/error should be generated.]
1197 include/assert.inc [It should be an Error, not a Warning.]
1198 include/assert.inc [Text should be "violates GTID consistency"]
1199 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1200 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1201 ROLLBACK;
1202 SET GTID_NEXT = 'AUTOMATIC';
1203 include/assert.inc [Both counters should be 0]
1204 DROP TRIGGER trig;
1205 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
1206 SET SESSION BINLOG_FORMAT = STATEMENT;
1207 Warnings:
1208 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1209 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
1210 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
1211 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1212 SET GTID_NEXT = 'ANONYMOUS';
1213 BEGIN; INSERT INTO innodb VALUES (1);
1214 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1215 INSERT INTO tmp_myisam1 VALUES (1);
1216 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1217 include/assert.inc [One warning/error should be generated.]
1218 include/assert.inc [It should be an Error, not a Warning.]
1219 include/assert.inc [Text should be "violates GTID consistency"]
1220 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1221 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1222 ROLLBACK;
1223 SET GTID_NEXT = 'AUTOMATIC';
1224 include/assert.inc [Both counters should be 0]
1225 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
1226 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
1227 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1228 SET GTID_NEXT = 'ANONYMOUS';
1229 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1230 INSERT INTO innodb VALUES (1);
1231 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1232 include/assert.inc [One warning/error should be generated.]
1233 include/assert.inc [It should be an Error, not a Warning.]
1234 include/assert.inc [Text should be "violates GTID consistency"]
1235 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1236 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1237 ROLLBACK;
1238 SET GTID_NEXT = 'AUTOMATIC';
1239 include/assert.inc [Both counters should be 0]
1240 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
1241 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS
1242 SET GTID_NEXT = 'ANONYMOUS';
1243 BEGIN;
1244 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1245 INSERT INTO innodb VALUES (1);
1246 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1247 include/assert.inc [One warning/error should be generated.]
1248 include/assert.inc [It should be an Error, not a Warning.]
1249 include/assert.inc [Text should be "violates GTID consistency"]
1250 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1251 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1252 ROLLBACK;
1253 SET GTID_NEXT = 'AUTOMATIC';
1254 include/assert.inc [Both counters should be 0]
1255 DROP TRIGGER trig;
1256 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
1257 SET BINLOG_FORMAT = #;
1258 Warnings:
1259 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1260 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON_PERMISSIVE GTID_NEXT=GTID ########
1261 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
1262 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
1263 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
1264 ---- InnoDB followed by MyISAM in one trx ----
1265 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1266 SET GTID_NEXT = 'GTID';
1267 BEGIN; INSERT INTO innodb VALUES (1);
1268 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1269 INSERT INTO myisam1 VALUES (1);
1270 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1271 include/assert.inc [One warning/error should be generated.]
1272 include/assert.inc [It should be an Error, not a Warning.]
1273 include/assert.inc [Text should be "violates GTID consistency"]
1274 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1275 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1276 ROLLBACK;
1277 SET GTID_NEXT = 'AUTOMATIC';
1278 include/assert.inc [Both counters should be 0]
1279 ---- InnoDB and MyISAM in one autocommit statement ----
1280 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
1281 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1282 SET GTID_NEXT = 'GTID';
1283 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1284 INSERT INTO innodb VALUES (1);
1285 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1286 include/assert.inc [One warning/error should be generated.]
1287 include/assert.inc [It should be an Error, not a Warning.]
1288 include/assert.inc [Text should be "violates GTID consistency"]
1289 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1290 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1291 ROLLBACK;
1292 SET GTID_NEXT = 'AUTOMATIC';
1293 include/assert.inc [Both counters should be 0]
1294 ---- InnoDB and MyISAM in one statement inside trx ----
1295 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1296 SET GTID_NEXT = 'GTID';
1297 BEGIN;
1298 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1299 INSERT INTO innodb VALUES (1);
1300 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1301 include/assert.inc [One warning/error should be generated.]
1302 include/assert.inc [It should be an Error, not a Warning.]
1303 include/assert.inc [Text should be "violates GTID consistency"]
1304 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1305 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1306 ROLLBACK;
1307 SET GTID_NEXT = 'AUTOMATIC';
1308 include/assert.inc [Both counters should be 0]
1309 DROP TRIGGER trig;
1310 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
1311 SET SESSION BINLOG_FORMAT = STATEMENT;
1312 Warnings:
1313 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1314 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
1315 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
1316 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1317 SET GTID_NEXT = 'GTID';
1318 BEGIN; INSERT INTO innodb VALUES (1);
1319 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1320 INSERT INTO tmp_myisam1 VALUES (1);
1321 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1322 include/assert.inc [One warning/error should be generated.]
1323 include/assert.inc [It should be an Error, not a Warning.]
1324 include/assert.inc [Text should be "violates GTID consistency"]
1325 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1326 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1327 ROLLBACK;
1328 SET GTID_NEXT = 'AUTOMATIC';
1329 include/assert.inc [Both counters should be 0]
1330 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
1331 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
1332 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1333 SET GTID_NEXT = 'GTID';
1334 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1335 INSERT INTO innodb VALUES (1);
1336 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1337 include/assert.inc [One warning/error should be generated.]
1338 include/assert.inc [It should be an Error, not a Warning.]
1339 include/assert.inc [Text should be "violates GTID consistency"]
1340 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1341 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1342 ROLLBACK;
1343 SET GTID_NEXT = 'AUTOMATIC';
1344 include/assert.inc [Both counters should be 0]
1345 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
1346 # enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID
1347 SET GTID_NEXT = 'GTID';
1348 BEGIN;
1349 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1350 INSERT INTO innodb VALUES (1);
1351 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1352 include/assert.inc [One warning/error should be generated.]
1353 include/assert.inc [It should be an Error, not a Warning.]
1354 include/assert.inc [Text should be "violates GTID consistency"]
1355 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1356 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1357 ROLLBACK;
1358 SET GTID_NEXT = 'AUTOMATIC';
1359 include/assert.inc [Both counters should be 0]
1360 DROP TRIGGER trig;
1361 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
1362 SET BINLOG_FORMAT = #;
1363 Warnings:
1364 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1365 SET GLOBAL GTID_MODE = 1;
1366 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF_PERMISSIVE GTID_NEXT=AUTOMATIC ########
1367 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
1368 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
1369 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
1370 ---- InnoDB followed by MyISAM in one trx ----
1371 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
1372 SET GTID_NEXT = 'AUTOMATIC';
1373 BEGIN; INSERT INTO innodb VALUES (1);
1374 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1375 INSERT INTO myisam1 VALUES (1);
1376 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1377 include/assert.inc [One warning/error should be generated.]
1378 include/assert.inc [It should be an Error, not a Warning.]
1379 include/assert.inc [Text should be "violates GTID consistency"]
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 ROLLBACK;
1383 SET GTID_NEXT = 'AUTOMATIC';
1384 include/assert.inc [Both counters should be 0]
1385 ---- InnoDB and MyISAM in one autocommit statement ----
1386 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
1387 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
1388 SET GTID_NEXT = 'AUTOMATIC';
1389 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1390 INSERT INTO innodb VALUES (1);
1391 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1392 include/assert.inc [One warning/error should be generated.]
1393 include/assert.inc [It should be an Error, not a Warning.]
1394 include/assert.inc [Text should be "violates GTID consistency"]
1395 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1396 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1397 ROLLBACK;
1398 SET GTID_NEXT = 'AUTOMATIC';
1399 include/assert.inc [Both counters should be 0]
1400 ---- InnoDB and MyISAM in one statement inside trx ----
1401 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
1402 SET GTID_NEXT = 'AUTOMATIC';
1403 BEGIN;
1404 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1405 INSERT INTO innodb VALUES (1);
1406 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1407 include/assert.inc [One warning/error should be generated.]
1408 include/assert.inc [It should be an Error, not a Warning.]
1409 include/assert.inc [Text should be "violates GTID consistency"]
1410 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1411 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1412 ROLLBACK;
1413 SET GTID_NEXT = 'AUTOMATIC';
1414 include/assert.inc [Both counters should be 0]
1415 DROP TRIGGER trig;
1416 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
1417 SET SESSION BINLOG_FORMAT = STATEMENT;
1418 Warnings:
1419 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1420 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
1421 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
1422 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
1423 SET GTID_NEXT = 'AUTOMATIC';
1424 BEGIN; INSERT INTO innodb VALUES (1);
1425 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1426 INSERT INTO tmp_myisam1 VALUES (1);
1427 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1428 include/assert.inc [One warning/error should be generated.]
1429 include/assert.inc [It should be an Error, not a Warning.]
1430 include/assert.inc [Text should be "violates GTID consistency"]
1431 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1432 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1433 ROLLBACK;
1434 SET GTID_NEXT = 'AUTOMATIC';
1435 include/assert.inc [Both counters should be 0]
1436 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
1437 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
1438 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
1439 SET GTID_NEXT = 'AUTOMATIC';
1440 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1441 INSERT INTO innodb VALUES (1);
1442 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1443 include/assert.inc [One warning/error should be generated.]
1444 include/assert.inc [It should be an Error, not a Warning.]
1445 include/assert.inc [Text should be "violates GTID consistency"]
1446 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1447 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1448 ROLLBACK;
1449 SET GTID_NEXT = 'AUTOMATIC';
1450 include/assert.inc [Both counters should be 0]
1451 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
1452 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC
1453 SET GTID_NEXT = 'AUTOMATIC';
1454 BEGIN;
1455 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1456 INSERT INTO innodb VALUES (1);
1457 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1458 include/assert.inc [One warning/error should be generated.]
1459 include/assert.inc [It should be an Error, not a Warning.]
1460 include/assert.inc [Text should be "violates GTID consistency"]
1461 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1462 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1463 ROLLBACK;
1464 SET GTID_NEXT = 'AUTOMATIC';
1465 include/assert.inc [Both counters should be 0]
1466 DROP TRIGGER trig;
1467 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
1468 SET BINLOG_FORMAT = #;
1469 Warnings:
1470 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1471 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF_PERMISSIVE GTID_NEXT=ANONYMOUS ########
1472 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
1473 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
1474 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
1475 ---- InnoDB followed by MyISAM in one trx ----
1476 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
1477 SET GTID_NEXT = 'ANONYMOUS';
1478 BEGIN; INSERT INTO innodb VALUES (1);
1479 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1480 INSERT INTO myisam1 VALUES (1);
1481 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1482 include/assert.inc [One warning/error should be generated.]
1483 include/assert.inc [It should be an Error, not a Warning.]
1484 include/assert.inc [Text should be "violates GTID consistency"]
1485 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1486 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1487 ROLLBACK;
1488 SET GTID_NEXT = 'AUTOMATIC';
1489 include/assert.inc [Both counters should be 0]
1490 ---- InnoDB and MyISAM in one autocommit statement ----
1491 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
1492 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
1493 SET GTID_NEXT = 'ANONYMOUS';
1494 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1495 INSERT INTO innodb VALUES (1);
1496 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1497 include/assert.inc [One warning/error should be generated.]
1498 include/assert.inc [It should be an Error, not a Warning.]
1499 include/assert.inc [Text should be "violates GTID consistency"]
1500 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1501 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1502 ROLLBACK;
1503 SET GTID_NEXT = 'AUTOMATIC';
1504 include/assert.inc [Both counters should be 0]
1505 ---- InnoDB and MyISAM in one statement inside trx ----
1506 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
1507 SET GTID_NEXT = 'ANONYMOUS';
1508 BEGIN;
1509 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1510 INSERT INTO innodb VALUES (1);
1511 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1512 include/assert.inc [One warning/error should be generated.]
1513 include/assert.inc [It should be an Error, not a Warning.]
1514 include/assert.inc [Text should be "violates GTID consistency"]
1515 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1516 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1517 ROLLBACK;
1518 SET GTID_NEXT = 'AUTOMATIC';
1519 include/assert.inc [Both counters should be 0]
1520 DROP TRIGGER trig;
1521 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
1522 SET SESSION BINLOG_FORMAT = STATEMENT;
1523 Warnings:
1524 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1525 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
1526 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
1527 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
1528 SET GTID_NEXT = 'ANONYMOUS';
1529 BEGIN; INSERT INTO innodb VALUES (1);
1530 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1531 INSERT INTO tmp_myisam1 VALUES (1);
1532 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1533 include/assert.inc [One warning/error should be generated.]
1534 include/assert.inc [It should be an Error, not a Warning.]
1535 include/assert.inc [Text should be "violates GTID consistency"]
1536 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1537 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1538 ROLLBACK;
1539 SET GTID_NEXT = 'AUTOMATIC';
1540 include/assert.inc [Both counters should be 0]
1541 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
1542 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
1543 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
1544 SET GTID_NEXT = 'ANONYMOUS';
1545 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1546 INSERT INTO innodb VALUES (1);
1547 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1548 include/assert.inc [One warning/error should be generated.]
1549 include/assert.inc [It should be an Error, not a Warning.]
1550 include/assert.inc [Text should be "violates GTID consistency"]
1551 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1552 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1553 ROLLBACK;
1554 SET GTID_NEXT = 'AUTOMATIC';
1555 include/assert.inc [Both counters should be 0]
1556 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
1557 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS
1558 SET GTID_NEXT = 'ANONYMOUS';
1559 BEGIN;
1560 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1561 INSERT INTO innodb VALUES (1);
1562 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1563 include/assert.inc [One warning/error should be generated.]
1564 include/assert.inc [It should be an Error, not a Warning.]
1565 include/assert.inc [Text should be "violates GTID consistency"]
1566 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1567 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1568 ROLLBACK;
1569 SET GTID_NEXT = 'AUTOMATIC';
1570 include/assert.inc [Both counters should be 0]
1571 DROP TRIGGER trig;
1572 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
1573 SET BINLOG_FORMAT = #;
1574 Warnings:
1575 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1576 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF_PERMISSIVE GTID_NEXT=GTID ########
1577 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
1578 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
1579 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
1580 ---- InnoDB followed by MyISAM in one trx ----
1581 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
1582 SET GTID_NEXT = 'GTID';
1583 BEGIN; INSERT INTO innodb VALUES (1);
1584 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1585 INSERT INTO myisam1 VALUES (1);
1586 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1587 include/assert.inc [One warning/error should be generated.]
1588 include/assert.inc [It should be an Error, not a Warning.]
1589 include/assert.inc [Text should be "violates GTID consistency"]
1590 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1591 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1592 ROLLBACK;
1593 SET GTID_NEXT = 'AUTOMATIC';
1594 include/assert.inc [Both counters should be 0]
1595 ---- InnoDB and MyISAM in one autocommit statement ----
1596 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
1597 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
1598 SET GTID_NEXT = 'GTID';
1599 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1600 INSERT INTO innodb VALUES (1);
1601 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1602 include/assert.inc [One warning/error should be generated.]
1603 include/assert.inc [It should be an Error, not a Warning.]
1604 include/assert.inc [Text should be "violates GTID consistency"]
1605 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1606 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1607 ROLLBACK;
1608 SET GTID_NEXT = 'AUTOMATIC';
1609 include/assert.inc [Both counters should be 0]
1610 ---- InnoDB and MyISAM in one statement inside trx ----
1611 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
1612 SET GTID_NEXT = 'GTID';
1613 BEGIN;
1614 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1615 INSERT INTO innodb VALUES (1);
1616 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1617 include/assert.inc [One warning/error should be generated.]
1618 include/assert.inc [It should be an Error, not a Warning.]
1619 include/assert.inc [Text should be "violates GTID consistency"]
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 TRIGGER trig;
1626 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
1627 SET SESSION BINLOG_FORMAT = STATEMENT;
1628 Warnings:
1629 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1630 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
1631 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
1632 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
1633 SET GTID_NEXT = 'GTID';
1634 BEGIN; INSERT INTO innodb VALUES (1);
1635 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1636 INSERT INTO tmp_myisam1 VALUES (1);
1637 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1638 include/assert.inc [One warning/error should be generated.]
1639 include/assert.inc [It should be an Error, not a Warning.]
1640 include/assert.inc [Text should be "violates GTID consistency"]
1641 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1642 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1643 ROLLBACK;
1644 SET GTID_NEXT = 'AUTOMATIC';
1645 include/assert.inc [Both counters should be 0]
1646 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
1647 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
1648 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
1649 SET GTID_NEXT = 'GTID';
1650 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1651 INSERT INTO innodb VALUES (1);
1652 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1653 include/assert.inc [One warning/error should be generated.]
1654 include/assert.inc [It should be an Error, not a Warning.]
1655 include/assert.inc [Text should be "violates GTID consistency"]
1656 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1657 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1658 ROLLBACK;
1659 SET GTID_NEXT = 'AUTOMATIC';
1660 include/assert.inc [Both counters should be 0]
1661 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
1662 # enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID
1663 SET GTID_NEXT = 'GTID';
1664 BEGIN;
1665 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1666 INSERT INTO innodb VALUES (1);
1667 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1668 include/assert.inc [One warning/error should be generated.]
1669 include/assert.inc [It should be an Error, not a Warning.]
1670 include/assert.inc [Text should be "violates GTID consistency"]
1671 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1672 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1673 ROLLBACK;
1674 SET GTID_NEXT = 'AUTOMATIC';
1675 include/assert.inc [Both counters should be 0]
1676 DROP TRIGGER trig;
1677 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
1678 SET BINLOG_FORMAT = #;
1679 Warnings:
1680 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1681 SET GLOBAL GTID_MODE = 0;
1682 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF GTID_NEXT=AUTOMATIC ########
1683 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
1684 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
1685 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
1686 ---- InnoDB followed by MyISAM in one trx ----
1687 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
1688 SET GTID_NEXT = 'AUTOMATIC';
1689 BEGIN; INSERT INTO innodb VALUES (1);
1690 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1691 INSERT INTO myisam1 VALUES (1);
1692 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1693 include/assert.inc [One warning/error should be generated.]
1694 include/assert.inc [It should be an Error, not a Warning.]
1695 include/assert.inc [Text should be "violates GTID consistency"]
1696 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1697 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1698 ROLLBACK;
1699 SET GTID_NEXT = 'AUTOMATIC';
1700 include/assert.inc [Both counters should be 0]
1701 ---- InnoDB and MyISAM in one autocommit statement ----
1702 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
1703 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
1704 SET GTID_NEXT = 'AUTOMATIC';
1705 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1706 INSERT INTO innodb VALUES (1);
1707 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1708 include/assert.inc [One warning/error should be generated.]
1709 include/assert.inc [It should be an Error, not a Warning.]
1710 include/assert.inc [Text should be "violates GTID consistency"]
1711 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1712 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1713 ROLLBACK;
1714 SET GTID_NEXT = 'AUTOMATIC';
1715 include/assert.inc [Both counters should be 0]
1716 ---- InnoDB and MyISAM in one statement inside trx ----
1717 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
1718 SET GTID_NEXT = 'AUTOMATIC';
1719 BEGIN;
1720 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1721 INSERT INTO innodb VALUES (1);
1722 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1723 include/assert.inc [One warning/error should be generated.]
1724 include/assert.inc [It should be an Error, not a Warning.]
1725 include/assert.inc [Text should be "violates GTID consistency"]
1726 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1727 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1728 ROLLBACK;
1729 SET GTID_NEXT = 'AUTOMATIC';
1730 include/assert.inc [Both counters should be 0]
1731 DROP TRIGGER trig;
1732 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
1733 SET SESSION BINLOG_FORMAT = STATEMENT;
1734 Warnings:
1735 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1736 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
1737 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
1738 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
1739 SET GTID_NEXT = 'AUTOMATIC';
1740 BEGIN; INSERT INTO innodb VALUES (1);
1741 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1742 INSERT INTO tmp_myisam1 VALUES (1);
1743 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1744 include/assert.inc [One warning/error should be generated.]
1745 include/assert.inc [It should be an Error, not a Warning.]
1746 include/assert.inc [Text should be "violates GTID consistency"]
1747 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1748 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1749 ROLLBACK;
1750 SET GTID_NEXT = 'AUTOMATIC';
1751 include/assert.inc [Both counters should be 0]
1752 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
1753 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
1754 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
1755 SET GTID_NEXT = 'AUTOMATIC';
1756 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1757 INSERT INTO innodb VALUES (1);
1758 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1759 include/assert.inc [One warning/error should be generated.]
1760 include/assert.inc [It should be an Error, not a Warning.]
1761 include/assert.inc [Text should be "violates GTID consistency"]
1762 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1763 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1764 ROLLBACK;
1765 SET GTID_NEXT = 'AUTOMATIC';
1766 include/assert.inc [Both counters should be 0]
1767 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
1768 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC
1769 SET GTID_NEXT = 'AUTOMATIC';
1770 BEGIN;
1771 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1772 INSERT INTO innodb VALUES (1);
1773 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1774 include/assert.inc [One warning/error should be generated.]
1775 include/assert.inc [It should be an Error, not a Warning.]
1776 include/assert.inc [Text should be "violates GTID consistency"]
1777 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1778 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1779 ROLLBACK;
1780 SET GTID_NEXT = 'AUTOMATIC';
1781 include/assert.inc [Both counters should be 0]
1782 DROP TRIGGER trig;
1783 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
1784 SET BINLOG_FORMAT = #;
1785 Warnings:
1786 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1787 ######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF GTID_NEXT=ANONYMOUS ########
1788 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
1789 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
1790 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
1791 ---- InnoDB followed by MyISAM in one trx ----
1792 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
1793 SET GTID_NEXT = 'ANONYMOUS';
1794 BEGIN; INSERT INTO innodb VALUES (1);
1795 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1796 INSERT INTO myisam1 VALUES (1);
1797 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1798 include/assert.inc [One warning/error should be generated.]
1799 include/assert.inc [It should be an Error, not a Warning.]
1800 include/assert.inc [Text should be "violates GTID consistency"]
1801 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1802 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1803 ROLLBACK;
1804 SET GTID_NEXT = 'AUTOMATIC';
1805 include/assert.inc [Both counters should be 0]
1806 ---- InnoDB and MyISAM in one autocommit statement ----
1807 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
1808 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
1809 SET GTID_NEXT = 'ANONYMOUS';
1810 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1811 INSERT INTO innodb VALUES (1);
1812 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1813 include/assert.inc [One warning/error should be generated.]
1814 include/assert.inc [It should be an Error, not a Warning.]
1815 include/assert.inc [Text should be "violates GTID consistency"]
1816 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1817 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1818 ROLLBACK;
1819 SET GTID_NEXT = 'AUTOMATIC';
1820 include/assert.inc [Both counters should be 0]
1821 ---- InnoDB and MyISAM in one statement inside trx ----
1822 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
1823 SET GTID_NEXT = 'ANONYMOUS';
1824 BEGIN;
1825 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1826 INSERT INTO innodb VALUES (1);
1827 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1828 include/assert.inc [One warning/error should be generated.]
1829 include/assert.inc [It should be an Error, not a Warning.]
1830 include/assert.inc [Text should be "violates GTID consistency"]
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 ROLLBACK;
1834 SET GTID_NEXT = 'AUTOMATIC';
1835 include/assert.inc [Both counters should be 0]
1836 DROP TRIGGER trig;
1837 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
1838 SET SESSION BINLOG_FORMAT = STATEMENT;
1839 Warnings:
1840 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1841 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
1842 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
1843 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
1844 SET GTID_NEXT = 'ANONYMOUS';
1845 BEGIN; INSERT INTO innodb VALUES (1);
1846 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1847 INSERT INTO tmp_myisam1 VALUES (1);
1848 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1849 include/assert.inc [One warning/error should be generated.]
1850 include/assert.inc [It should be an Error, not a Warning.]
1851 include/assert.inc [Text should be "violates GTID consistency"]
1852 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1853 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1854 ROLLBACK;
1855 SET GTID_NEXT = 'AUTOMATIC';
1856 include/assert.inc [Both counters should be 0]
1857 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
1858 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
1859 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
1860 SET GTID_NEXT = 'ANONYMOUS';
1861 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1862 INSERT INTO innodb VALUES (1);
1863 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1864 include/assert.inc [One warning/error should be generated.]
1865 include/assert.inc [It should be an Error, not a Warning.]
1866 include/assert.inc [Text should be "violates GTID consistency"]
1867 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1868 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1869 ROLLBACK;
1870 SET GTID_NEXT = 'AUTOMATIC';
1871 include/assert.inc [Both counters should be 0]
1872 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
1873 # enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS
1874 SET GTID_NEXT = 'ANONYMOUS';
1875 BEGIN;
1876 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1877 INSERT INTO innodb VALUES (1);
1878 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1879 include/assert.inc [One warning/error should be generated.]
1880 include/assert.inc [It should be an Error, not a Warning.]
1881 include/assert.inc [Text should be "violates GTID consistency"]
1882 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1883 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1884 ROLLBACK;
1885 SET GTID_NEXT = 'AUTOMATIC';
1886 include/assert.inc [Both counters should be 0]
1887 DROP TRIGGER trig;
1888 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
1889 SET BINLOG_FORMAT = #;
1890 Warnings:
1891 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1892 SET GLOBAL ENFORCE_GTID_CONSISTENCY = 2;
1893 SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
1894 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
1895 SET GLOBAL GTID_MODE = 2;
1896 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=ON_PERMISSIVE GTID_NEXT=AUTOMATIC ########
1897 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
1898 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
1899 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
1900 ---- InnoDB followed by MyISAM in one trx ----
1901 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
1902 SET GTID_NEXT = 'AUTOMATIC';
1903 BEGIN; INSERT INTO innodb VALUES (1);
1904 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1905 INSERT INTO myisam1 VALUES (1);
1906 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1907 include/assert.inc [One warning/error should be generated.]
1908 include/assert.inc [It should be an Error, not a Warning.]
1909 include/assert.inc [Text should be "violates GTID consistency"]
1910 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1911 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1912 ROLLBACK;
1913 SET GTID_NEXT = 'AUTOMATIC';
1914 include/assert.inc [Both counters should be 0]
1915 ---- InnoDB and MyISAM in one autocommit statement ----
1916 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
1917 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
1918 SET GTID_NEXT = 'AUTOMATIC';
1919 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1920 INSERT INTO innodb VALUES (1);
1921 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1922 include/assert.inc [One warning/error should be generated.]
1923 include/assert.inc [It should be an Error, not a Warning.]
1924 include/assert.inc [Text should be "violates GTID consistency"]
1925 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1926 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1927 ROLLBACK;
1928 SET GTID_NEXT = 'AUTOMATIC';
1929 include/assert.inc [Both counters should be 0]
1930 ---- InnoDB and MyISAM in one statement inside trx ----
1931 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
1932 SET GTID_NEXT = 'AUTOMATIC';
1933 BEGIN;
1934 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1935 INSERT INTO innodb VALUES (1);
1936 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1937 include/assert.inc [One warning/error should be generated.]
1938 include/assert.inc [It should be an Error, not a Warning.]
1939 include/assert.inc [Text should be "violates GTID consistency"]
1940 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1941 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1942 ROLLBACK;
1943 SET GTID_NEXT = 'AUTOMATIC';
1944 include/assert.inc [Both counters should be 0]
1945 DROP TRIGGER trig;
1946 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
1947 SET SESSION BINLOG_FORMAT = STATEMENT;
1948 Warnings:
1949 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1950 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
1951 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
1952 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
1953 SET GTID_NEXT = 'AUTOMATIC';
1954 BEGIN; INSERT INTO innodb VALUES (1);
1955 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1956 INSERT INTO tmp_myisam1 VALUES (1);
1957 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1958 include/assert.inc [One warning/error should be generated.]
1959 include/assert.inc [It should be an Error, not a Warning.]
1960 include/assert.inc [Text should be "violates GTID consistency"]
1961 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1962 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1963 ROLLBACK;
1964 SET GTID_NEXT = 'AUTOMATIC';
1965 include/assert.inc [Both counters should be 0]
1966 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
1967 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
1968 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
1969 SET GTID_NEXT = 'AUTOMATIC';
1970 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1971 INSERT INTO innodb VALUES (1);
1972 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1973 include/assert.inc [One warning/error should be generated.]
1974 include/assert.inc [It should be an Error, not a Warning.]
1975 include/assert.inc [Text should be "violates GTID consistency"]
1976 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1977 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1978 ROLLBACK;
1979 SET GTID_NEXT = 'AUTOMATIC';
1980 include/assert.inc [Both counters should be 0]
1981 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
1982 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC
1983 SET GTID_NEXT = 'AUTOMATIC';
1984 BEGIN;
1985 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
1986 INSERT INTO innodb VALUES (1);
1987 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
1988 include/assert.inc [One warning/error should be generated.]
1989 include/assert.inc [It should be an Error, not a Warning.]
1990 include/assert.inc [Text should be "violates GTID consistency"]
1991 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1992 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
1993 ROLLBACK;
1994 SET GTID_NEXT = 'AUTOMATIC';
1995 include/assert.inc [Both counters should be 0]
1996 DROP TRIGGER trig;
1997 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
1998 SET BINLOG_FORMAT = #;
1999 Warnings:
2000 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2001 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=ON_PERMISSIVE GTID_NEXT=ANONYMOUS ########
2002 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
2003 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
2004 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
2005 ---- InnoDB followed by MyISAM in one trx ----
2006 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2007 SET GTID_NEXT = 'ANONYMOUS';
2008 BEGIN; INSERT INTO innodb VALUES (1);
2009 [START] INSERT INTO myisam1 VALUES (1);
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 1]
2012 [END] INSERT INTO myisam1 VALUES (1);
2013 include/assert.inc [One warning/error should be generated.]
2014 include/assert.inc [It should be a Warning, not an Error.]
2015 include/assert.inc [Text should be "violates GTID consistency"]
2016 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2017 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2018 ROLLBACK;
2019 SET GTID_NEXT = 'AUTOMATIC';
2020 include/assert.inc [Both counters should be 0]
2021 ---- InnoDB and MyISAM in one autocommit statement ----
2022 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
2023 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2024 SET GTID_NEXT = 'ANONYMOUS';
2025 [START] INSERT INTO innodb VALUES (1);
2026 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2027 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2028 [END] INSERT INTO innodb VALUES (1);
2029 Warnings:
2030 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2031 include/assert.inc [One warning/error should be generated.]
2032 include/assert.inc [It should be a Warning, not an Error.]
2033 include/assert.inc [Text should be "violates GTID consistency"]
2034 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2035 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2036 ROLLBACK;
2037 SET GTID_NEXT = 'AUTOMATIC';
2038 include/assert.inc [Both counters should be 0]
2039 ---- InnoDB and MyISAM in one statement inside trx ----
2040 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2041 SET GTID_NEXT = 'ANONYMOUS';
2042 BEGIN;
2043 [START] INSERT INTO innodb VALUES (1);
2044 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2045 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2046 [END] INSERT INTO innodb VALUES (1);
2047 include/assert.inc [One warning/error should be generated.]
2048 include/assert.inc [It should be a Warning, not an Error.]
2049 include/assert.inc [Text should be "violates GTID consistency"]
2050 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2051 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2052 ROLLBACK;
2053 SET GTID_NEXT = 'AUTOMATIC';
2054 include/assert.inc [Both counters should be 0]
2055 DROP TRIGGER trig;
2056 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
2057 SET SESSION BINLOG_FORMAT = STATEMENT;
2058 Warnings:
2059 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2060 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
2061 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
2062 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2063 SET GTID_NEXT = 'ANONYMOUS';
2064 BEGIN; INSERT INTO innodb VALUES (1);
2065 [START] INSERT INTO tmp_myisam1 VALUES (1);
2066 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2067 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2068 [END] INSERT INTO tmp_myisam1 VALUES (1);
2069 Warnings:
2070 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2071 include/assert.inc [One warning/error should be generated.]
2072 include/assert.inc [It should be a Warning, not an Error.]
2073 include/assert.inc [Text should be "violates GTID consistency"]
2074 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2075 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2076 ROLLBACK;
2077 Warnings:
2078 Warning 1196 Some non-transactional changed tables couldn't be rolled back
2079 SET GTID_NEXT = 'AUTOMATIC';
2080 include/assert.inc [Both counters should be 0]
2081 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
2082 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
2083 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2084 SET GTID_NEXT = 'ANONYMOUS';
2085 [START] INSERT INTO innodb VALUES (1);
2086 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2087 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2088 [END] INSERT INTO innodb VALUES (1);
2089 Warnings:
2090 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2091 include/assert.inc [One warning/error should be generated.]
2092 include/assert.inc [It should be a Warning, not an Error.]
2093 include/assert.inc [Text should be "violates GTID consistency"]
2094 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2095 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2096 ROLLBACK;
2097 SET GTID_NEXT = 'AUTOMATIC';
2098 include/assert.inc [Both counters should be 0]
2099 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
2100 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS
2101 SET GTID_NEXT = 'ANONYMOUS';
2102 BEGIN;
2103 [START] INSERT INTO innodb VALUES (1);
2104 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2105 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2106 [END] INSERT INTO innodb VALUES (1);
2107 include/assert.inc [One warning/error should be generated.]
2108 include/assert.inc [It should be a Warning, not an Error.]
2109 include/assert.inc [Text should be "violates GTID consistency"]
2110 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2111 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2112 ROLLBACK;
2113 SET GTID_NEXT = 'AUTOMATIC';
2114 include/assert.inc [Both counters should be 0]
2115 DROP TRIGGER trig;
2116 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
2117 SET BINLOG_FORMAT = #;
2118 Warnings:
2119 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2120 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=ON_PERMISSIVE GTID_NEXT=GTID ########
2121 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
2122 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
2123 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
2124 ---- InnoDB followed by MyISAM in one trx ----
2125 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
2126 SET GTID_NEXT = 'GTID';
2127 BEGIN; INSERT INTO innodb VALUES (1);
2128 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2129 INSERT INTO myisam1 VALUES (1);
2130 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2131 include/assert.inc [One warning/error should be generated.]
2132 include/assert.inc [It should be an Error, not a Warning.]
2133 include/assert.inc [Text should be "violates GTID consistency"]
2134 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2135 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2136 ROLLBACK;
2137 SET GTID_NEXT = 'AUTOMATIC';
2138 include/assert.inc [Both counters should be 0]
2139 ---- InnoDB and MyISAM in one autocommit statement ----
2140 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
2141 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
2142 SET GTID_NEXT = 'GTID';
2143 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2144 INSERT INTO innodb VALUES (1);
2145 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2146 include/assert.inc [One warning/error should be generated.]
2147 include/assert.inc [It should be an Error, not a Warning.]
2148 include/assert.inc [Text should be "violates GTID consistency"]
2149 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2150 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2151 ROLLBACK;
2152 SET GTID_NEXT = 'AUTOMATIC';
2153 include/assert.inc [Both counters should be 0]
2154 ---- InnoDB and MyISAM in one statement inside trx ----
2155 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
2156 SET GTID_NEXT = 'GTID';
2157 BEGIN;
2158 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2159 INSERT INTO innodb VALUES (1);
2160 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2161 include/assert.inc [One warning/error should be generated.]
2162 include/assert.inc [It should be an Error, not a Warning.]
2163 include/assert.inc [Text should be "violates GTID consistency"]
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 TRIGGER trig;
2170 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
2171 SET SESSION BINLOG_FORMAT = STATEMENT;
2172 Warnings:
2173 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2174 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
2175 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
2176 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
2177 SET GTID_NEXT = 'GTID';
2178 BEGIN; INSERT INTO innodb VALUES (1);
2179 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2180 INSERT INTO tmp_myisam1 VALUES (1);
2181 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2182 include/assert.inc [One warning/error should be generated.]
2183 include/assert.inc [It should be an Error, not a Warning.]
2184 include/assert.inc [Text should be "violates GTID consistency"]
2185 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2186 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2187 ROLLBACK;
2188 SET GTID_NEXT = 'AUTOMATIC';
2189 include/assert.inc [Both counters should be 0]
2190 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
2191 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
2192 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
2193 SET GTID_NEXT = 'GTID';
2194 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2195 INSERT INTO innodb VALUES (1);
2196 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2197 include/assert.inc [One warning/error should be generated.]
2198 include/assert.inc [It should be an Error, not a Warning.]
2199 include/assert.inc [Text should be "violates GTID consistency"]
2200 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2201 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2202 ROLLBACK;
2203 SET GTID_NEXT = 'AUTOMATIC';
2204 include/assert.inc [Both counters should be 0]
2205 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
2206 # enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID
2207 SET GTID_NEXT = 'GTID';
2208 BEGIN;
2209 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2210 INSERT INTO innodb VALUES (1);
2211 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2212 include/assert.inc [One warning/error should be generated.]
2213 include/assert.inc [It should be an Error, not a Warning.]
2214 include/assert.inc [Text should be "violates GTID consistency"]
2215 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2216 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2217 ROLLBACK;
2218 SET GTID_NEXT = 'AUTOMATIC';
2219 include/assert.inc [Both counters should be 0]
2220 DROP TRIGGER trig;
2221 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
2222 SET BINLOG_FORMAT = #;
2223 Warnings:
2224 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2225 SET GLOBAL GTID_MODE = 1;
2226 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF_PERMISSIVE GTID_NEXT=AUTOMATIC ########
2227 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
2228 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
2229 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
2230 ---- InnoDB followed by MyISAM in one trx ----
2231 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
2232 SET GTID_NEXT = 'AUTOMATIC';
2233 BEGIN; INSERT INTO innodb VALUES (1);
2234 [START] INSERT INTO myisam1 VALUES (1);
2235 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2236 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2237 [END] INSERT INTO myisam1 VALUES (1);
2238 include/assert.inc [One warning/error should be generated.]
2239 include/assert.inc [It should be a Warning, not an Error.]
2240 include/assert.inc [Text should be "violates GTID consistency"]
2241 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2242 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2243 ROLLBACK;
2244 SET GTID_NEXT = 'AUTOMATIC';
2245 include/assert.inc [Both counters should be 0]
2246 ---- InnoDB and MyISAM in one autocommit statement ----
2247 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
2248 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
2249 SET GTID_NEXT = 'AUTOMATIC';
2250 [START] INSERT INTO innodb VALUES (1);
2251 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2252 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2253 [END] INSERT INTO innodb VALUES (1);
2254 Warnings:
2255 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2256 include/assert.inc [One warning/error should be generated.]
2257 include/assert.inc [It should be a Warning, not an Error.]
2258 include/assert.inc [Text should be "violates GTID consistency"]
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 ROLLBACK;
2262 SET GTID_NEXT = 'AUTOMATIC';
2263 include/assert.inc [Both counters should be 0]
2264 ---- InnoDB and MyISAM in one statement inside trx ----
2265 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
2266 SET GTID_NEXT = 'AUTOMATIC';
2267 BEGIN;
2268 [START] INSERT INTO innodb VALUES (1);
2269 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2270 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2271 [END] INSERT INTO innodb VALUES (1);
2272 include/assert.inc [One warning/error should be generated.]
2273 include/assert.inc [It should be a Warning, not an Error.]
2274 include/assert.inc [Text should be "violates GTID consistency"]
2275 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2276 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2277 ROLLBACK;
2278 SET GTID_NEXT = 'AUTOMATIC';
2279 include/assert.inc [Both counters should be 0]
2280 DROP TRIGGER trig;
2281 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
2282 SET SESSION BINLOG_FORMAT = STATEMENT;
2283 Warnings:
2284 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2285 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
2286 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
2287 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
2288 SET GTID_NEXT = 'AUTOMATIC';
2289 BEGIN; INSERT INTO innodb VALUES (1);
2290 [START] INSERT INTO tmp_myisam1 VALUES (1);
2291 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2292 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2293 [END] INSERT INTO tmp_myisam1 VALUES (1);
2294 Warnings:
2295 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2296 include/assert.inc [One warning/error should be generated.]
2297 include/assert.inc [It should be a Warning, not an Error.]
2298 include/assert.inc [Text should be "violates GTID consistency"]
2299 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2300 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2301 ROLLBACK;
2302 Warnings:
2303 Warning 1196 Some non-transactional changed tables couldn't be rolled back
2304 SET GTID_NEXT = 'AUTOMATIC';
2305 include/assert.inc [Both counters should be 0]
2306 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
2307 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
2308 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
2309 SET GTID_NEXT = 'AUTOMATIC';
2310 [START] INSERT INTO innodb VALUES (1);
2311 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2312 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2313 [END] INSERT INTO innodb VALUES (1);
2314 Warnings:
2315 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2316 include/assert.inc [One warning/error should be generated.]
2317 include/assert.inc [It should be a Warning, not an Error.]
2318 include/assert.inc [Text should be "violates GTID consistency"]
2319 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2320 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2321 ROLLBACK;
2322 SET GTID_NEXT = 'AUTOMATIC';
2323 include/assert.inc [Both counters should be 0]
2324 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
2325 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC
2326 SET GTID_NEXT = 'AUTOMATIC';
2327 BEGIN;
2328 [START] INSERT INTO innodb VALUES (1);
2329 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2330 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2331 [END] INSERT INTO innodb VALUES (1);
2332 include/assert.inc [One warning/error should be generated.]
2333 include/assert.inc [It should be a Warning, not an Error.]
2334 include/assert.inc [Text should be "violates GTID consistency"]
2335 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2336 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2337 ROLLBACK;
2338 SET GTID_NEXT = 'AUTOMATIC';
2339 include/assert.inc [Both counters should be 0]
2340 DROP TRIGGER trig;
2341 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
2342 SET BINLOG_FORMAT = #;
2343 Warnings:
2344 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2345 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF_PERMISSIVE GTID_NEXT=ANONYMOUS ########
2346 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
2347 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
2348 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
2349 ---- InnoDB followed by MyISAM in one trx ----
2350 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
2351 SET GTID_NEXT = 'ANONYMOUS';
2352 BEGIN; INSERT INTO innodb VALUES (1);
2353 [START] INSERT INTO myisam1 VALUES (1);
2354 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2355 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2356 [END] INSERT INTO myisam1 VALUES (1);
2357 include/assert.inc [One warning/error should be generated.]
2358 include/assert.inc [It should be a Warning, not an Error.]
2359 include/assert.inc [Text should be "violates GTID consistency"]
2360 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2361 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2362 ROLLBACK;
2363 SET GTID_NEXT = 'AUTOMATIC';
2364 include/assert.inc [Both counters should be 0]
2365 ---- InnoDB and MyISAM in one autocommit statement ----
2366 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
2367 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
2368 SET GTID_NEXT = 'ANONYMOUS';
2369 [START] INSERT INTO innodb VALUES (1);
2370 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2371 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2372 [END] INSERT INTO innodb VALUES (1);
2373 Warnings:
2374 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2375 include/assert.inc [One warning/error should be generated.]
2376 include/assert.inc [It should be a Warning, not an Error.]
2377 include/assert.inc [Text should be "violates GTID consistency"]
2378 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2379 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2380 ROLLBACK;
2381 SET GTID_NEXT = 'AUTOMATIC';
2382 include/assert.inc [Both counters should be 0]
2383 ---- InnoDB and MyISAM in one statement inside trx ----
2384 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
2385 SET GTID_NEXT = 'ANONYMOUS';
2386 BEGIN;
2387 [START] INSERT INTO innodb VALUES (1);
2388 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2389 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2390 [END] INSERT INTO innodb VALUES (1);
2391 include/assert.inc [One warning/error should be generated.]
2392 include/assert.inc [It should be a Warning, not an Error.]
2393 include/assert.inc [Text should be "violates GTID consistency"]
2394 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2395 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2396 ROLLBACK;
2397 SET GTID_NEXT = 'AUTOMATIC';
2398 include/assert.inc [Both counters should be 0]
2399 DROP TRIGGER trig;
2400 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
2401 SET SESSION BINLOG_FORMAT = STATEMENT;
2402 Warnings:
2403 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2404 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
2405 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
2406 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
2407 SET GTID_NEXT = 'ANONYMOUS';
2408 BEGIN; INSERT INTO innodb VALUES (1);
2409 [START] INSERT INTO tmp_myisam1 VALUES (1);
2410 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2411 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2412 [END] INSERT INTO tmp_myisam1 VALUES (1);
2413 Warnings:
2414 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2415 include/assert.inc [One warning/error should be generated.]
2416 include/assert.inc [It should be a Warning, not an Error.]
2417 include/assert.inc [Text should be "violates GTID consistency"]
2418 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2419 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2420 ROLLBACK;
2421 Warnings:
2422 Warning 1196 Some non-transactional changed tables couldn't be rolled back
2423 SET GTID_NEXT = 'AUTOMATIC';
2424 include/assert.inc [Both counters should be 0]
2425 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
2426 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
2427 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
2428 SET GTID_NEXT = 'ANONYMOUS';
2429 [START] INSERT INTO innodb VALUES (1);
2430 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2431 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2432 [END] INSERT INTO innodb VALUES (1);
2433 Warnings:
2434 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2435 include/assert.inc [One warning/error should be generated.]
2436 include/assert.inc [It should be a Warning, not an Error.]
2437 include/assert.inc [Text should be "violates GTID consistency"]
2438 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2439 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2440 ROLLBACK;
2441 SET GTID_NEXT = 'AUTOMATIC';
2442 include/assert.inc [Both counters should be 0]
2443 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
2444 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS
2445 SET GTID_NEXT = 'ANONYMOUS';
2446 BEGIN;
2447 [START] INSERT INTO innodb VALUES (1);
2448 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2449 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2450 [END] INSERT INTO innodb VALUES (1);
2451 include/assert.inc [One warning/error should be generated.]
2452 include/assert.inc [It should be a Warning, not an Error.]
2453 include/assert.inc [Text should be "violates GTID consistency"]
2454 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2455 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2456 ROLLBACK;
2457 SET GTID_NEXT = 'AUTOMATIC';
2458 include/assert.inc [Both counters should be 0]
2459 DROP TRIGGER trig;
2460 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
2461 SET BINLOG_FORMAT = #;
2462 Warnings:
2463 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2464 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF_PERMISSIVE GTID_NEXT=GTID ########
2465 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
2466 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
2467 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
2468 ---- InnoDB followed by MyISAM in one trx ----
2469 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
2470 SET GTID_NEXT = 'GTID';
2471 BEGIN; INSERT INTO innodb VALUES (1);
2472 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2473 INSERT INTO myisam1 VALUES (1);
2474 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2475 include/assert.inc [One warning/error should be generated.]
2476 include/assert.inc [It should be an Error, not a Warning.]
2477 include/assert.inc [Text should be "violates GTID consistency"]
2478 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2479 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2480 ROLLBACK;
2481 SET GTID_NEXT = 'AUTOMATIC';
2482 include/assert.inc [Both counters should be 0]
2483 ---- InnoDB and MyISAM in one autocommit statement ----
2484 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
2485 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
2486 SET GTID_NEXT = 'GTID';
2487 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2488 INSERT INTO innodb VALUES (1);
2489 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2490 include/assert.inc [One warning/error should be generated.]
2491 include/assert.inc [It should be an Error, not a Warning.]
2492 include/assert.inc [Text should be "violates GTID consistency"]
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 ---- InnoDB and MyISAM in one statement inside trx ----
2499 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
2500 SET GTID_NEXT = 'GTID';
2501 BEGIN;
2502 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2503 INSERT INTO innodb VALUES (1);
2504 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2505 include/assert.inc [One warning/error should be generated.]
2506 include/assert.inc [It should be an Error, not a Warning.]
2507 include/assert.inc [Text should be "violates GTID consistency"]
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 TRIGGER trig;
2514 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
2515 SET SESSION BINLOG_FORMAT = STATEMENT;
2516 Warnings:
2517 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2518 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
2519 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
2520 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
2521 SET GTID_NEXT = 'GTID';
2522 BEGIN; INSERT INTO innodb VALUES (1);
2523 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2524 INSERT INTO tmp_myisam1 VALUES (1);
2525 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2526 include/assert.inc [One warning/error should be generated.]
2527 include/assert.inc [It should be an Error, not a Warning.]
2528 include/assert.inc [Text should be "violates GTID consistency"]
2529 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2530 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2531 ROLLBACK;
2532 SET GTID_NEXT = 'AUTOMATIC';
2533 include/assert.inc [Both counters should be 0]
2534 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
2535 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
2536 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
2537 SET GTID_NEXT = 'GTID';
2538 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2539 INSERT INTO innodb VALUES (1);
2540 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2541 include/assert.inc [One warning/error should be generated.]
2542 include/assert.inc [It should be an Error, not a Warning.]
2543 include/assert.inc [Text should be "violates GTID consistency"]
2544 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2545 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2546 ROLLBACK;
2547 SET GTID_NEXT = 'AUTOMATIC';
2548 include/assert.inc [Both counters should be 0]
2549 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
2550 # enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID
2551 SET GTID_NEXT = 'GTID';
2552 BEGIN;
2553 error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
2554 INSERT INTO innodb VALUES (1);
2555 ERROR HY000: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2556 include/assert.inc [One warning/error should be generated.]
2557 include/assert.inc [It should be an Error, not a Warning.]
2558 include/assert.inc [Text should be "violates GTID consistency"]
2559 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2560 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2561 ROLLBACK;
2562 SET GTID_NEXT = 'AUTOMATIC';
2563 include/assert.inc [Both counters should be 0]
2564 DROP TRIGGER trig;
2565 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
2566 SET BINLOG_FORMAT = #;
2567 Warnings:
2568 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2569 SET GLOBAL GTID_MODE = 0;
2570 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF GTID_NEXT=AUTOMATIC ########
2571 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
2572 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
2573 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
2574 ---- InnoDB followed by MyISAM in one trx ----
2575 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
2576 SET GTID_NEXT = 'AUTOMATIC';
2577 BEGIN; INSERT INTO innodb VALUES (1);
2578 [START] INSERT INTO myisam1 VALUES (1);
2579 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2580 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2581 [END] INSERT INTO myisam1 VALUES (1);
2582 include/assert.inc [One warning/error should be generated.]
2583 include/assert.inc [It should be a Warning, not an Error.]
2584 include/assert.inc [Text should be "violates GTID consistency"]
2585 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2586 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2587 ROLLBACK;
2588 SET GTID_NEXT = 'AUTOMATIC';
2589 include/assert.inc [Both counters should be 0]
2590 ---- InnoDB and MyISAM in one autocommit statement ----
2591 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
2592 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
2593 SET GTID_NEXT = 'AUTOMATIC';
2594 [START] INSERT INTO innodb VALUES (1);
2595 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2596 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2597 [END] INSERT INTO innodb VALUES (1);
2598 Warnings:
2599 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2600 include/assert.inc [One warning/error should be generated.]
2601 include/assert.inc [It should be a Warning, not an Error.]
2602 include/assert.inc [Text should be "violates GTID consistency"]
2603 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2604 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2605 ROLLBACK;
2606 SET GTID_NEXT = 'AUTOMATIC';
2607 include/assert.inc [Both counters should be 0]
2608 ---- InnoDB and MyISAM in one statement inside trx ----
2609 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
2610 SET GTID_NEXT = 'AUTOMATIC';
2611 BEGIN;
2612 [START] INSERT INTO innodb VALUES (1);
2613 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2614 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2615 [END] INSERT INTO innodb VALUES (1);
2616 include/assert.inc [One warning/error should be generated.]
2617 include/assert.inc [It should be a Warning, not an Error.]
2618 include/assert.inc [Text should be "violates GTID consistency"]
2619 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2620 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2621 ROLLBACK;
2622 SET GTID_NEXT = 'AUTOMATIC';
2623 include/assert.inc [Both counters should be 0]
2624 DROP TRIGGER trig;
2625 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
2626 SET SESSION BINLOG_FORMAT = STATEMENT;
2627 Warnings:
2628 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2629 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
2630 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
2631 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
2632 SET GTID_NEXT = 'AUTOMATIC';
2633 BEGIN; INSERT INTO innodb VALUES (1);
2634 [START] INSERT INTO tmp_myisam1 VALUES (1);
2635 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2636 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2637 [END] INSERT INTO tmp_myisam1 VALUES (1);
2638 Warnings:
2639 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2640 include/assert.inc [One warning/error should be generated.]
2641 include/assert.inc [It should be a Warning, not an Error.]
2642 include/assert.inc [Text should be "violates GTID consistency"]
2643 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2644 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2645 ROLLBACK;
2646 Warnings:
2647 Warning 1196 Some non-transactional changed tables couldn't be rolled back
2648 SET GTID_NEXT = 'AUTOMATIC';
2649 include/assert.inc [Both counters should be 0]
2650 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
2651 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
2652 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
2653 SET GTID_NEXT = 'AUTOMATIC';
2654 [START] INSERT INTO innodb VALUES (1);
2655 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2656 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2657 [END] INSERT INTO innodb VALUES (1);
2658 Warnings:
2659 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2660 include/assert.inc [One warning/error should be generated.]
2661 include/assert.inc [It should be a Warning, not an Error.]
2662 include/assert.inc [Text should be "violates GTID consistency"]
2663 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2664 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2665 ROLLBACK;
2666 SET GTID_NEXT = 'AUTOMATIC';
2667 include/assert.inc [Both counters should be 0]
2668 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
2669 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC
2670 SET GTID_NEXT = 'AUTOMATIC';
2671 BEGIN;
2672 [START] INSERT INTO innodb VALUES (1);
2673 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2674 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2675 [END] INSERT INTO innodb VALUES (1);
2676 include/assert.inc [One warning/error should be generated.]
2677 include/assert.inc [It should be a Warning, not an Error.]
2678 include/assert.inc [Text should be "violates GTID consistency"]
2679 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2680 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2681 ROLLBACK;
2682 SET GTID_NEXT = 'AUTOMATIC';
2683 include/assert.inc [Both counters should be 0]
2684 DROP TRIGGER trig;
2685 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
2686 SET BINLOG_FORMAT = #;
2687 Warnings:
2688 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2689 ######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF GTID_NEXT=ANONYMOUS ########
2690 CREATE TABLE myisam1 (a INT) ENGINE = MyISAM;
2691 CREATE TABLE myisam2 (a INT) ENGINE = MyISAM;
2692 CREATE TABLE innodb (a INT) ENGINE = InnoDB;
2693 ---- InnoDB followed by MyISAM in one trx ----
2694 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
2695 SET GTID_NEXT = 'ANONYMOUS';
2696 BEGIN; INSERT INTO innodb VALUES (1);
2697 [START] INSERT INTO myisam1 VALUES (1);
2698 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2699 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2700 [END] INSERT INTO myisam1 VALUES (1);
2701 include/assert.inc [One warning/error should be generated.]
2702 include/assert.inc [It should be a Warning, not an Error.]
2703 include/assert.inc [Text should be "violates GTID consistency"]
2704 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2705 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2706 ROLLBACK;
2707 SET GTID_NEXT = 'AUTOMATIC';
2708 include/assert.inc [Both counters should be 0]
2709 ---- InnoDB and MyISAM in one autocommit statement ----
2710 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO myisam1 VALUES (1);
2711 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
2712 SET GTID_NEXT = 'ANONYMOUS';
2713 [START] INSERT INTO innodb VALUES (1);
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 1]
2716 [END] INSERT INTO innodb VALUES (1);
2717 Warnings:
2718 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2719 include/assert.inc [One warning/error should be generated.]
2720 include/assert.inc [It should be a Warning, not an Error.]
2721 include/assert.inc [Text should be "violates GTID consistency"]
2722 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2723 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2724 ROLLBACK;
2725 SET GTID_NEXT = 'AUTOMATIC';
2726 include/assert.inc [Both counters should be 0]
2727 ---- InnoDB and MyISAM in one statement inside trx ----
2728 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
2729 SET GTID_NEXT = 'ANONYMOUS';
2730 BEGIN;
2731 [START] INSERT INTO innodb VALUES (1);
2732 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2733 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2734 [END] INSERT INTO innodb VALUES (1);
2735 include/assert.inc [One warning/error should be generated.]
2736 include/assert.inc [It should be a Warning, not an Error.]
2737 include/assert.inc [Text should be "violates GTID consistency"]
2738 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2739 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2740 ROLLBACK;
2741 SET GTID_NEXT = 'AUTOMATIC';
2742 include/assert.inc [Both counters should be 0]
2743 DROP TRIGGER trig;
2744 ---- InnoDB followed by temp MyISAM in one trx, binlog_format=stm ----
2745 SET SESSION BINLOG_FORMAT = STATEMENT;
2746 Warnings:
2747 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2748 CREATE TEMPORARY TABLE tmp_myisam1 (a INT) ENGINE = MyISAM;
2749 CREATE TEMPORARY TABLE tmp_myisam2 (a INT) ENGINE = MyISAM;
2750 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
2751 SET GTID_NEXT = 'ANONYMOUS';
2752 BEGIN; INSERT INTO innodb VALUES (1);
2753 [START] INSERT INTO tmp_myisam1 VALUES (1);
2754 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2755 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2756 [END] INSERT INTO tmp_myisam1 VALUES (1);
2757 Warnings:
2758 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2759 include/assert.inc [One warning/error should be generated.]
2760 include/assert.inc [It should be a Warning, not an Error.]
2761 include/assert.inc [Text should be "violates GTID consistency"]
2762 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2763 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2764 ROLLBACK;
2765 Warnings:
2766 Warning 1196 Some non-transactional changed tables couldn't be rolled back
2767 SET GTID_NEXT = 'AUTOMATIC';
2768 include/assert.inc [Both counters should be 0]
2769 ---- InnoDB and temp MyISAM in one autocommit statement, binlog_format=stm ----
2770 CREATE TRIGGER trig BEFORE INSERT ON innodb FOR EACH ROW INSERT INTO tmp_myisam1 VALUES (1);
2771 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
2772 SET GTID_NEXT = 'ANONYMOUS';
2773 [START] INSERT INTO innodb VALUES (1);
2774 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2775 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2776 [END] INSERT INTO innodb VALUES (1);
2777 Warnings:
2778 Warning 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
2779 include/assert.inc [One warning/error should be generated.]
2780 include/assert.inc [It should be a Warning, not an Error.]
2781 include/assert.inc [Text should be "violates GTID consistency"]
2782 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2783 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2784 ROLLBACK;
2785 SET GTID_NEXT = 'AUTOMATIC';
2786 include/assert.inc [Both counters should be 0]
2787 ---- InnoDB and temp MyISAM in one statement inside trx, binlog_format=stm ----
2788 # enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS
2789 SET GTID_NEXT = 'ANONYMOUS';
2790 BEGIN;
2791 [START] INSERT INTO innodb VALUES (1);
2792 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2793 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2794 [END] INSERT INTO innodb VALUES (1);
2795 include/assert.inc [One warning/error should be generated.]
2796 include/assert.inc [It should be a Warning, not an Error.]
2797 include/assert.inc [Text should be "violates GTID consistency"]
2798 include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0]
2799 include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1]
2800 ROLLBACK;
2801 SET GTID_NEXT = 'AUTOMATIC';
2802 include/assert.inc [Both counters should be 0]
2803 DROP TRIGGER trig;
2804 DROP TABLE myisam1, myisam2, tmp_myisam1, tmp_myisam2, innodb;
2805 SET BINLOG_FORMAT = #;
2806 Warnings:
2807 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2808 SET GLOBAL ENFORCE_GTID_CONSISTENCY = OFF;
2809 SET GLOBAL SQL_NOTES = @old_sql_notes;
2810 include/rpl_end.inc
2811 include/end_replace_gtid_combination.inc [gtid_mode=off/on -> binlog_direct_non_transactional_updates=0/1]