Debian Codegraph @

mysql-test/suite/engines/rr_trx/r/rr_id_900.result

raw
1 SET autocommit = 0;
2 START TRANSACTION;
3
4 *** Delete a row and re-insert with same `pk`:
5
6 *** Disabling result log
7 SELECT @pk:=`pk`,
8 @unique1:=`int1_unique`,
9 @unique2:=`int2_unique`
10 FROM t1 WHERE `pk` MOD 5 = 4 AND `pk` > 900 AND `is_consistent` = 1 LIMIT 1 FOR UPDATE;
11 *** Enabling result log
12 DELETE FROM t1 WHERE `pk` = @pk;
13 *** Doing insert of row with pk = @pk if above statement succeeded (query log disabled)...
14 COMMIT;
15 START TRANSACTION;
16
17 *** Delete a row and re-insert with `pk` = NULL:
18
19 *** Disabling result log
20 SELECT @pk:=`pk`,
21 @unique1:=`int1_unique`,
22 @unique2:=`int2_unique`
23 FROM t1 WHERE `pk` MOD 5 = 4 AND `pk` > 901 AND `is_consistent` = 1 LIMIT 1 FOR UPDATE;
24 *** Enabling result log
25 DELETE FROM t1 WHERE `pk` = @pk;
26 *** Doing insert of row with pk = NULL if above statement succeeded (query log disabled)...
27 COMMIT;
28 START TRANSACTION;
29
30 *** Delete up to two (2) "consistent" rows (zero-sum; table sum unchanged)
31
32 DELETE FROM t1 WHERE `pk` > 902 AND `pk` MOD 5 = 3 AND `is_consistent` = 1 LIMIT 2;
33 COMMIT;