2
SET @session_tx_isolation = @@SESSION.tx_isolation;
3
SET @global_tx_isolation = @@GLOBAL.tx_isolation;
4
** Connecting con0 using root **
6
SET SESSION AUTOCOMMIT = OFF;
7
** Connecting con1 using root **
9
SET SESSION AUTOCOMMIT = OFF;
10
** Connection default **
11
CREATE TABLE t1 (a int PRIMARY KEY, b int) ENGINE=INNODB;
12
INSERT INTO t1 VALUES(2, 2);
13
INSERT INTO t1 VALUES(4, 4);
14
INSERT INTO t1 VALUES(6, 6);
15
INSERT INTO t1 VALUES(8, 8);
16
INSERT INTO t1 VALUES(16, 16);
17
INSERT INTO t1 VALUES(18, 18);
18
INSERT INTO t1 VALUES(20, 20);
19
INSERT INTO t1 VALUES(22, 22);
20
INSERT INTO t1 VALUES(24, 24);
21
'#----------------------------FN_DYNVARS_184_01--------------------------------------#'
23
SET SESSION tx_isolation = 'READ-UNCOMMITTED';
25
SET SESSION tx_isolation = 'READ-UNCOMMITTED';
28
SELECT * FROM t1 WHERE a IN (2,4,6,8) FOR UPDATE;
34
UPDATE t1 SET b = 10 WHERE a IN (2,4,6,8);
48
INSERT INTO t1 VALUES(1, 1);
49
INSERT INTO t1 VALUES(3, 3);
65
DELETE FROM t1 WHERE a = 1 OR a = 3;
67
'#----------------------------FN_DYNVARS_184_02--------------------------------------#'
70
SELECT * FROM t1 WHERE a % 2 = 0 FOR UPDATE;
81
UPDATE t1 SET b = 10 WHERE a % 2 = 0;
95
INSERT INTO t1 VALUES(23, 23);
96
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
97
INSERT INTO t1 VALUES(25, 25);
98
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
99
Bug: Only even rows are being locked, error 1205 should'nt have occured
112
** Connection con0 **
114
'#----------------------------FN_DYNVARS_184_03--------------------------------------#'
115
** Connection con0 **
116
SET SESSION tx_isolation = 'READ-COMMITTED';
117
** Connection con1 **
118
SET SESSION tx_isolation = 'READ-COMMITTED';
119
** Connection con0 **
121
SELECT * FROM t1 WHERE a % 2 = 0 FOR UPDATE;
132
UPDATE t1 SET b = 11 WHERE a % 2 = 0;
133
** Connection con1 **
146
INSERT INTO t1 VALUES(5, 5);
147
INSERT INTO t1 VALUES(7, 7);
162
** Connection con0 **
164
'#----------------------------FN_DYNVARS_184_04--------------------------------------#'
165
** Connection con0 **
166
SET SESSION tx_isolation = 'REPEATABLE-READ';
167
** Connection con1 **
168
SET SESSION tx_isolation = 'REPEATABLE-READ';
169
** Connection con0 **
171
SELECT * FROM t1 WHERE a % 2 = 0 FOR UPDATE;
182
UPDATE t1 SET b = 12 WHERE a % 2 = 0;
183
** Connection con1 **
198
INSERT INTO t1 VALUES(9, 9);
199
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
200
INSERT INTO t1 VALUES(13, 13);
201
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
202
Expected error "Lock wait timeout"
217
** Connection con0 **
219
'#----------------------------FN_DYNVARS_184_05--------------------------------------#'
220
** Connection con0 **
222
SELECT * FROM t1 WHERE a IN (2,4,6,8,10,12,14,16,18,20,22,24,26) = 0 FOR UPDATE;
226
UPDATE t1 SET b = 13 WHERE a IN (2,4,6,8,10,12,14,16,18,20,22,24,26) = 0;
227
** Connection con1 **
242
INSERT INTO t1 VALUES(9, 9);
243
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
244
INSERT INTO t1 VALUES(13, 13);
245
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
246
Expected error "Lock wait timeout"
261
** Connection con0 **
263
'#----------------------------FN_DYNVARS_184_06--------------------------------------#'
264
** Connection con0 **
266
SELECT * FROM t1 WHERE a IN (2,4,6,8) = 0 FOR UPDATE;
275
UPDATE t1 SET b = 14 WHERE a IN (2,4,6,8) = 0;
276
** Connection con1 **
291
INSERT INTO t1 VALUES(9, 9);
292
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
293
INSERT INTO t1 VALUES(13, 13);
294
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
295
Expected error "Lock wait timeout"
310
** Connection con0 **
312
'#----------------------------FN_DYNVARS_184_07--------------------------------------#'
313
** Connection con0 **
314
SET SESSION tx_isolation = 'SERIALIZABLE';
315
** Connection con0 **
316
SET SESSION tx_isolation = 'SERIALIZABLE';
317
** Connection con0 **
319
SELECT * FROM t1 WHERE a % 2 = 0 FOR UPDATE;
330
UPDATE t1 SET b = 15 WHERE a % 2 = 0;
331
** Connection con0 **
334
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
335
INSERT INTO t1 VALUES(15, 15);
336
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
337
INSERT INTO t1 VALUES(17, 17);
338
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
340
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
342
** Connection con0 **
344
'#----------------------------FN_DYNVARS_184_08--------------------------------------#'
345
SET GLOBAL tx_isolation = 'READ-UNCOMMITTED';
346
** Connecting con_int1 using root **
347
** Connection con_int1 **
348
SELECT @@SESSION.tx_isolation;
349
@@SESSION.tx_isolation
351
READ-UNCOMMITTED Expected
352
SET SESSION tx_isolation = 'SERIALIZABLE';
353
** Connecting con_int2 using root **
354
** Connection con_int2 **
355
SELECT @@SESSION.tx_isolation;
356
@@SESSION.tx_isolation
358
READ-UNCOMMITTED Expected
359
SET SESSION tx_isolation = 'REPEATABLE-READ';
360
** Connection con_int2 **
361
SELECT @@SESSION.tx_isolation;
362
@@SESSION.tx_isolation
364
REPEATABLE-READ Expected
365
** Connection con_int1 **
366
SELECT @@SESSION.tx_isolation;
367
@@SESSION.tx_isolation
369
SERIALIZABLE Expected
370
SELECT @@GLOBAL.tx_isolation;
371
@@GLOBAL.tx_isolation
373
READ-UNCOMMITTED Expected
374
** Connection default **
375
Disconnecting Connections con_int1, con_int2
376
SET @@SESSION.tx_isolation = @session_tx_isolation;
377
SET @@GLOBAL.tx_isolation = @global_tx_isolation;
378
** Connection default **
379
Disconnecting Connections con0, con1