Debian Codegraph @

mysql-test/suite/engines/rr_trx/r/rr_replace_7-8.result

raw
1 SET autocommit = 0;
2 START TRANSACTION;
3 *** Disabling result log
4 SELECT @pk:=`pk`, @unique:=`int1_unique`
5 FROM t1
6 WHERE `pk` MOD 5 <> 0
7 AND `pk` > 200 + (CONNECTION_ID() MOD 1000)
8 AND `int1_unique` NOT IN (SELECT `int1_unique` FROM t1 WHERE (`pk` < 1000 AND `pk` MOD 5 = 0) OR `is_consistent` = 0)
9 AND -`int1_unique` NOT IN (SELECT `int2_unique` FROM t1 WHERE (`pk` < 1000 AND `pk` MOD 5 = 0) OR `is_consistent` = 0)
10 AND `is_consistent`= 1
11 LIMIT 1 FOR UPDATE;
12 *** Enabling result log
13 REPLACE INTO t1 SET `pk` = @pk,
14 `id` = 7,
15 `int1` = 7,
16 `int1_key` = -7,
17 `int1_unique` = @unique,
18 `int2` = -7,
19 `int2_key` = 7,
20 `int2_unique` = -@unique,
21 `connection_id` = CONNECTION_ID(),
22 `is_consistent` = 1;
23 COMMIT;
24 START TRANSACTION;
25 REPLACE INTO t1
26 SELECT * FROM t1
27 WHERE `pk` > 1000 + CONNECTION_ID() MOD 777
28 AND `int1_unique` NOT IN (SELECT `int1_unique` FROM t1 WHERE `pk` < 1000 OR `is_consistent` = 0)
29 AND `int2_unique` NOT IN (SELECT `int2_unique` FROM t1 WHERE `pk` < 1000 OR `is_consistent` = 0)
30 AND `pk` MOD 5 <> 0
31 AND `is_consistent` = 1
32 ORDER BY `pk` LIMIT 1;
33 *** Updating replaced row (if applicable)
34 COMMIT;