Debian Codegraph @

mysql-test/suite/innodb/r/trigger_function_lock_compare.result

raw
1 #
2 # BUG#32636792: IN THE TRIGGER, INSERT INTO SELECT LOCKS THE SELECTED
3 # ROWS, EVEN READ-COMMITTED
4 #
5 Warnings:
6 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
7 Warnings:
8 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
9 ########## BINLOG FORMAT: ROW ###########
10 # Query: SELECT id FROM t1 WHERE val = 'a' INTO @v1
11 # Isolation level: READ UNCOMMITTED
12 # Comparing locks taken for the above query in regular case and when inside a trigger.
13 # Locks taken in trigger should always be same as that in regular case.
14 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
15
16 # Comparing locks taken for the above query in regular case and when inside a function.
17 # Locks taken in function should always be same as that in regular case.
18 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
19
20 # Isolation level: READ COMMITTED
21 # Comparing locks taken for the above query in regular case and when inside a trigger.
22 # Locks taken in trigger should always be same as that in regular case.
23 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
24
25 # Comparing locks taken for the above query in regular case and when inside a function.
26 # Locks taken in function should always be same as that in regular case.
27 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
28
29 # Isolation level: REPEATABLE READ
30 # Comparing locks taken for the above query in regular case and when inside a trigger.
31 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
32
33 # Comparing locks taken for the above query in regular case and when inside a function.
34 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
35
36 # Isolation level: SERIALIZABLE
37 # Comparing locks taken for the above query in regular case and when inside a trigger.
38 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
39
40 # Comparing locks taken for the above query in regular case and when inside a function.
41 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
42
43 # Query: SELECT id FROM t1 WHERE val = 'a' FOR SHARE INTO @v1
44 # Isolation level: READ UNCOMMITTED
45 # Comparing locks taken for the above query in regular case and when inside a trigger.
46 # Locks taken in trigger should always be same as that in regular case.
47 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
48
49 # Comparing locks taken for the above query in regular case and when inside a function.
50 # Locks taken in function should always be same as that in regular case.
51 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
52
53 # Isolation level: READ COMMITTED
54 # Comparing locks taken for the above query in regular case and when inside a trigger.
55 # Locks taken in trigger should always be same as that in regular case.
56 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
57
58 # Comparing locks taken for the above query in regular case and when inside a function.
59 # Locks taken in function should always be same as that in regular case.
60 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
61
62 # Isolation level: REPEATABLE READ
63 # Comparing locks taken for the above query in regular case and when inside a trigger.
64 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
65
66 # Comparing locks taken for the above query in regular case and when inside a function.
67 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
68
69 # Isolation level: SERIALIZABLE
70 # Comparing locks taken for the above query in regular case and when inside a trigger.
71 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
72
73 # Comparing locks taken for the above query in regular case and when inside a function.
74 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
75
76 # Query: SELECT id FROM t1 WHERE val = 'a' FOR UPDATE INTO @v1
77 # Isolation level: READ UNCOMMITTED
78 # Comparing locks taken for the above query in regular case and when inside a trigger.
79 # Locks taken in trigger should always be same as that in regular case.
80 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
81
82 # Comparing locks taken for the above query in regular case and when inside a function.
83 # Locks taken in function should always be same as that in regular case.
84 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
85
86 # Isolation level: READ COMMITTED
87 # Comparing locks taken for the above query in regular case and when inside a trigger.
88 # Locks taken in trigger should always be same as that in regular case.
89 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
90
91 # Comparing locks taken for the above query in regular case and when inside a function.
92 # Locks taken in function should always be same as that in regular case.
93 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
94
95 # Isolation level: REPEATABLE READ
96 # Comparing locks taken for the above query in regular case and when inside a trigger.
97 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
98
99 # Comparing locks taken for the above query in regular case and when inside a function.
100 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
101
102 # Isolation level: SERIALIZABLE
103 # Comparing locks taken for the above query in regular case and when inside a trigger.
104 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
105
106 # Comparing locks taken for the above query in regular case and when inside a function.
107 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
108
109 # Query: UPDATE t1 SET val='A' WHERE val = 'a'
110 # Isolation level: READ UNCOMMITTED
111 # Comparing locks taken for the above query in regular case and when inside a trigger.
112 # Locks taken in trigger should always be same as that in regular case.
113 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
114
115 # Comparing locks taken for the above query in regular case and when inside a function.
116 # Locks taken in function should always be same as that in regular case.
117 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
118
119 # Isolation level: READ COMMITTED
120 # Comparing locks taken for the above query in regular case and when inside a trigger.
121 # Locks taken in trigger should always be same as that in regular case.
122 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
123
124 # Comparing locks taken for the above query in regular case and when inside a function.
125 # Locks taken in function should always be same as that in regular case.
126 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
127
128 # Isolation level: REPEATABLE READ
129 # Comparing locks taken for the above query in regular case and when inside a trigger.
130 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
131
132 # Comparing locks taken for the above query in regular case and when inside a function.
133 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
134
135 # Isolation level: SERIALIZABLE
136 # Comparing locks taken for the above query in regular case and when inside a trigger.
137 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
138
139 # Comparing locks taken for the above query in regular case and when inside a function.
140 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
141
142 # Query: INSERT INTO t1 SELECT id+100,val FROM t2
143 # Isolation level: READ UNCOMMITTED
144 # Comparing locks taken for the above query in regular case and when inside a trigger.
145 # Locks taken in trigger should always be same as that in regular case.
146 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
147
148 # Comparing locks taken for the above query in regular case and when inside a function.
149 # Locks taken in function should always be same as that in regular case.
150 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
151
152 # Isolation level: READ COMMITTED
153 # Comparing locks taken for the above query in regular case and when inside a trigger.
154 # Locks taken in trigger should always be same as that in regular case.
155 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
156
157 # Comparing locks taken for the above query in regular case and when inside a function.
158 # Locks taken in function should always be same as that in regular case.
159 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
160
161 # Isolation level: REPEATABLE READ
162 # Comparing locks taken for the above query in regular case and when inside a trigger.
163 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
164
165 # Comparing locks taken for the above query in regular case and when inside a function.
166 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
167
168 # Isolation level: SERIALIZABLE
169 # Comparing locks taken for the above query in regular case and when inside a trigger.
170 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
171
172 # Comparing locks taken for the above query in regular case and when inside a function.
173 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
174
175 # Query: INSERT INTO t1 ( id, val ) SELECT 2, id FROM t1 WHERE val = 'a'
176 # Isolation level: READ UNCOMMITTED
177 # Comparing locks taken for the above query in regular case and when inside a trigger.
178 # Locks taken in trigger should always be same as that in regular case.
179 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
180
181 # Comparing locks taken for the above query in regular case and when inside a function.
182 # Locks taken in function should always be same as that in regular case.
183 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
184
185 # Isolation level: READ COMMITTED
186 # Comparing locks taken for the above query in regular case and when inside a trigger.
187 # Locks taken in trigger should always be same as that in regular case.
188 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
189
190 # Comparing locks taken for the above query in regular case and when inside a function.
191 # Locks taken in function should always be same as that in regular case.
192 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
193
194 # Isolation level: REPEATABLE READ
195 # Comparing locks taken for the above query in regular case and when inside a trigger.
196 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
197
198 # Comparing locks taken for the above query in regular case and when inside a function.
199 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
200
201 # Isolation level: SERIALIZABLE
202 # Comparing locks taken for the above query in regular case and when inside a trigger.
203 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
204
205 # Comparing locks taken for the above query in regular case and when inside a function.
206 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
207
208 # Query: REPLACE INTO t1 ( id, val ) SELECT 2, id FROM t1 WHERE val = 'a'
209 # Isolation level: READ UNCOMMITTED
210 # Comparing locks taken for the above query in regular case and when inside a trigger.
211 # Locks taken in trigger should always be same as that in regular case.
212 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
213
214 # Comparing locks taken for the above query in regular case and when inside a function.
215 # Locks taken in function should always be same as that in regular case.
216 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
217
218 # Isolation level: READ COMMITTED
219 # Comparing locks taken for the above query in regular case and when inside a trigger.
220 # Locks taken in trigger should always be same as that in regular case.
221 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
222
223 # Comparing locks taken for the above query in regular case and when inside a function.
224 # Locks taken in function should always be same as that in regular case.
225 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
226
227 # Isolation level: REPEATABLE READ
228 # Comparing locks taken for the above query in regular case and when inside a trigger.
229 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
230
231 # Comparing locks taken for the above query in regular case and when inside a function.
232 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
233
234 # Isolation level: SERIALIZABLE
235 # Comparing locks taken for the above query in regular case and when inside a trigger.
236 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
237
238 # Comparing locks taken for the above query in regular case and when inside a function.
239 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
240
241 # Query: INSERT INTO t1 VALUES (30, 'b');
242 UPDATE t2 SET val='c' WHERE val IN (SELECT val FROM t1 where id = 30)
243 # Isolation level: READ UNCOMMITTED
244 # Comparing locks taken for the above query in regular case and when inside a trigger.
245 # Locks taken in trigger should always be same as that in regular case.
246 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
247
248 # Comparing locks taken for the above query in regular case and when inside a function.
249 # Locks taken in function should always be same as that in regular case.
250 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
251
252 # Isolation level: READ COMMITTED
253 # Comparing locks taken for the above query in regular case and when inside a trigger.
254 # Locks taken in trigger should always be same as that in regular case.
255 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
256
257 # Comparing locks taken for the above query in regular case and when inside a function.
258 # Locks taken in function should always be same as that in regular case.
259 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
260
261 # Isolation level: REPEATABLE READ
262 # Comparing locks taken for the above query in regular case and when inside a trigger.
263 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
264
265 # Comparing locks taken for the above query in regular case and when inside a function.
266 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
267
268 # Isolation level: SERIALIZABLE
269 # Comparing locks taken for the above query in regular case and when inside a trigger.
270 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
271
272 # Comparing locks taken for the above query in regular case and when inside a function.
273 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
274
275 # Query: INSERT INTO t1 VALUES (2, 'A');
276 SELECT val FROM t1 WHERE id = 10 INTO @v1
277 # Isolation level: READ UNCOMMITTED
278 # Comparing locks taken for the above query in regular case and when inside a trigger.
279 # Locks taken in trigger should always be same as that in regular case.
280 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
281
282 # Comparing locks taken for the above query in regular case and when inside a function.
283 # Locks taken in function should always be same as that in regular case.
284 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
285
286 # Isolation level: READ COMMITTED
287 # Comparing locks taken for the above query in regular case and when inside a trigger.
288 # Locks taken in trigger should always be same as that in regular case.
289 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
290
291 # Comparing locks taken for the above query in regular case and when inside a function.
292 # Locks taken in function should always be same as that in regular case.
293 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
294
295 # Isolation level: REPEATABLE READ
296 # Comparing locks taken for the above query in regular case and when inside a trigger.
297 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
298
299 # Comparing locks taken for the above query in regular case and when inside a function.
300 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
301
302 # Isolation level: SERIALIZABLE
303 # Comparing locks taken for the above query in regular case and when inside a trigger.
304 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
305
306 # Comparing locks taken for the above query in regular case and when inside a function.
307 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
308
309 Warnings:
310 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
311 ########## BINLOG FORMAT: STATEMENT ###########
312 # Query: SELECT id FROM t1 WHERE val = 'a' INTO @v1
313 # Isolation level: REPEATABLE READ
314 # Comparing locks taken for the above query in regular case and when inside a trigger.
315 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
316
317 # Comparing locks taken for the above query in regular case and when inside a function.
318 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
319
320 # Isolation level: SERIALIZABLE
321 # Comparing locks taken for the above query in regular case and when inside a trigger.
322 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
323
324 # Comparing locks taken for the above query in regular case and when inside a function.
325 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
326
327 # Query: SELECT id FROM t1 WHERE val = 'a' FOR SHARE INTO @v1
328 # Isolation level: REPEATABLE READ
329 # Comparing locks taken for the above query in regular case and when inside a trigger.
330 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
331
332 # Comparing locks taken for the above query in regular case and when inside a function.
333 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
334
335 # Isolation level: SERIALIZABLE
336 # Comparing locks taken for the above query in regular case and when inside a trigger.
337 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
338
339 # Comparing locks taken for the above query in regular case and when inside a function.
340 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
341
342 # Query: SELECT id FROM t1 WHERE val = 'a' FOR UPDATE INTO @v1
343 # Isolation level: REPEATABLE READ
344 # Comparing locks taken for the above query in regular case and when inside a trigger.
345 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
346
347 # Comparing locks taken for the above query in regular case and when inside a function.
348 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
349
350 # Isolation level: SERIALIZABLE
351 # Comparing locks taken for the above query in regular case and when inside a trigger.
352 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
353
354 # Comparing locks taken for the above query in regular case and when inside a function.
355 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
356
357 # Query: UPDATE t1 SET val='A' WHERE val = 'a'
358 # Isolation level: REPEATABLE READ
359 # Comparing locks taken for the above query in regular case and when inside a trigger.
360 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
361
362 # Comparing locks taken for the above query in regular case and when inside a function.
363 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
364
365 # Isolation level: SERIALIZABLE
366 # Comparing locks taken for the above query in regular case and when inside a trigger.
367 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
368
369 # Comparing locks taken for the above query in regular case and when inside a function.
370 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
371
372 # Query: INSERT INTO t1 SELECT id+100,val FROM t2
373 # Isolation level: REPEATABLE READ
374 # Comparing locks taken for the above query in regular case and when inside a trigger.
375 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
376
377 # Comparing locks taken for the above query in regular case and when inside a function.
378 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
379
380 # Isolation level: SERIALIZABLE
381 # Comparing locks taken for the above query in regular case and when inside a trigger.
382 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
383
384 # Comparing locks taken for the above query in regular case and when inside a function.
385 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
386
387 # Query: INSERT INTO t1 ( id, val ) SELECT 2, id FROM t1 WHERE val = 'a'
388 # Isolation level: REPEATABLE READ
389 # Comparing locks taken for the above query in regular case and when inside a trigger.
390 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
391
392 # Comparing locks taken for the above query in regular case and when inside a function.
393 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
394
395 # Isolation level: SERIALIZABLE
396 # Comparing locks taken for the above query in regular case and when inside a trigger.
397 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
398
399 # Comparing locks taken for the above query in regular case and when inside a function.
400 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
401
402 # Query: REPLACE INTO t1 ( id, val ) SELECT 2, id FROM t1 WHERE val = 'a'
403 # Isolation level: REPEATABLE READ
404 # Comparing locks taken for the above query in regular case and when inside a trigger.
405 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
406
407 # Comparing locks taken for the above query in regular case and when inside a function.
408 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
409
410 # Isolation level: SERIALIZABLE
411 # Comparing locks taken for the above query in regular case and when inside a trigger.
412 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
413
414 # Comparing locks taken for the above query in regular case and when inside a function.
415 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
416
417 # Query: INSERT INTO t1 VALUES (30, 'b');
418 UPDATE t2 SET val='c' WHERE val IN (SELECT val FROM t1 where id = 30)
419 # Isolation level: REPEATABLE READ
420 # Comparing locks taken for the above query in regular case and when inside a trigger.
421 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
422
423 # Comparing locks taken for the above query in regular case and when inside a function.
424 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
425
426 # Isolation level: SERIALIZABLE
427 # Comparing locks taken for the above query in regular case and when inside a trigger.
428 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
429
430 # Comparing locks taken for the above query in regular case and when inside a function.
431 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
432
433 # Query: INSERT INTO t1 VALUES (2, 'A');
434 SELECT val FROM t1 WHERE id = 10 INTO @v1
435 # Isolation level: REPEATABLE READ
436 # Comparing locks taken for the above query in regular case and when inside a trigger.
437 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
438
439 # Comparing locks taken for the above query in regular case and when inside a function.
440 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
441
442 # Isolation level: SERIALIZABLE
443 # Comparing locks taken for the above query in regular case and when inside a trigger.
444 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
445
446 # Comparing locks taken for the above query in regular case and when inside a function.
447 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
448
449 Warnings:
450 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
451 ########## BINLOG FORMAT: ROW ###########
452 # Query: INSERT INTO t2 SELECT id+100,val FROM t1
453 # Isolation level: READ UNCOMMITTED
454 # Comparing locks taken for the above query in regular case and when inside a trigger.
455 # Locks taken in trigger should always be same as that in regular case.
456 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
457
458 # Comparing locks taken for the above query in regular case and when inside a function.
459 # Locks taken in function should always be same as that in regular case.
460 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
461
462 # Isolation level: READ COMMITTED
463 # Comparing locks taken for the above query in regular case and when inside a trigger.
464 # Locks taken in trigger should always be same as that in regular case.
465 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
466
467 # Comparing locks taken for the above query in regular case and when inside a function.
468 # Locks taken in function should always be same as that in regular case.
469 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
470
471 # Isolation level: REPEATABLE READ
472 # Comparing locks taken for the above query in regular case and when inside a trigger.
473 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
474
475
476 # Isolation level: SERIALIZABLE
477 # Comparing locks taken for the above query in regular case and when inside a trigger.
478 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
479
480 # Comparing locks taken for the above query in regular case and when inside a function.
481 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
482
483 # Query: CREATE TEMPORARY TABLE t3 SELECT id FROM t1;
484 DROP TEMPORARY TABLE t3
485 # Isolation level: READ UNCOMMITTED
486 # Comparing locks taken for the above query in regular case and when inside a trigger.
487 # Locks taken in trigger should always be same as that in regular case.
488 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
489
490 # Comparing locks taken for the above query in regular case and when inside a function.
491 # Locks taken in function should always be same as that in regular case.
492 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
493
494 # Isolation level: READ COMMITTED
495 # Comparing locks taken for the above query in regular case and when inside a trigger.
496 # Locks taken in trigger should always be same as that in regular case.
497 include/diff_tables.inc [locks_in_regular_case, locks_in_trigger]
498
499 # Comparing locks taken for the above query in regular case and when inside a function.
500 # Locks taken in function should always be same as that in regular case.
501 include/diff_tables.inc [locks_in_regular_case, locks_in_function]
502
503 # Isolation level: REPEATABLE READ
504 # Comparing locks taken for the above query in regular case and when inside a trigger.
505 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
506
507
508 # Isolation level: SERIALIZABLE
509 # Comparing locks taken for the above query in regular case and when inside a trigger.
510 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
511
512 # Comparing locks taken for the above query in regular case and when inside a function.
513 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
514
515 Warnings:
516 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
517 ########## BINLOG FORMAT: STATEMENT ###########
518 # Query: INSERT INTO t2 SELECT id+100,val FROM t1
519 # Isolation level: REPEATABLE READ
520 # Comparing locks taken for the above query in regular case and when inside a trigger.
521 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
522
523
524 # Isolation level: SERIALIZABLE
525 # Comparing locks taken for the above query in regular case and when inside a trigger.
526 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
527
528 # Comparing locks taken for the above query in regular case and when inside a function.
529 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
530
531 # Query: CREATE TEMPORARY TABLE t3 SELECT id FROM t1;
532 DROP TEMPORARY TABLE t3
533 # Isolation level: REPEATABLE READ
534 # Comparing locks taken for the above query in regular case and when inside a trigger.
535 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
536
537
538 # Isolation level: SERIALIZABLE
539 # Comparing locks taken for the above query in regular case and when inside a trigger.
540 include/assert.inc [Locks taken in trigger should always be stronger or equal to locks taken in regular case]
541
542 # Comparing locks taken for the above query in regular case and when inside a function.
543 include/assert.inc [Locks taken in function should always be stronger or equal to locks taken in regular case]
544
545 Warnings:
546 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.