Debian Codegraph @

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

raw
1 #
2 # MDEV-39263 Lost update despite innodb_snapshot_isolation
3 #
4 CREATE TABLE si_log(seq SERIAL, val INT UNSIGNED)
5 ENGINE=InnoDB STATS_PERSISTENT=0;
6 CREATE TABLE si_counter(val INT UNSIGNED) ENGINE=InnoDB STATS_PERSISTENT=0;
7 INSERT INTO si_counter VALUES(0);
8 CREATE PROCEDURE step()
9 BEGIN NOT ATOMIC
10 DECLARE EXIT HANDLER FOR 1020, 1213, 1205 BEGIN ROLLBACK; END;
11 START TRANSACTION WITH CONSISTENT SNAPSHOT;
12 SELECT val INTO @val FROM si_counter;
13 UPDATE si_counter SET val=@val+1;
14 INSERT INTO si_log (val) VALUES (@val);
15 DO SLEEP(0.0001);
16 COMMIT;
17 END|
18 CREATE PROCEDURE test(c INT UNSIGNED)
19 BEGIN
20 WHILE c DO
21 SET c=c-1;
22 call step();
23 START TRANSACTION;
24 SELECT COUNT(*) INTO @count FROM si_log;
25 SELECT SUM(val) INTO @sum FROM si_counter;
26 COMMIT;
27 IF (@count != @sum) THEN shutdown; END IF;
28 END WHILE;
29 END|
30 connect stop_purge,localhost,root;
31 START TRANSACTION WITH CONSISTENT SNAPSHOT;
32 connection default;
33 SET innodb_snapshot_isolation=ON;
34 disconnect stop_purge;
35 DROP TABLE si_log, si_counter;
36 DROP PROCEDURE test;
37 DROP PROCEDURE step;