Debian Codegraph @

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

raw
1 CREATE TABLE t (
2 `a` INT NOT NULL,
3 `b` INT NOT NULL,
4 PRIMARY KEY (`a`)
5 ) ENGINE=InnoDB;
6 SET GLOBAL innodb_limit_optimistic_insert_debug = 3;
7 INSERT INTO t VALUES(10, 0);
8 INSERT INTO t VALUES(20, 0);
9 INSERT INTO t VALUES(30, 0);
10 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
11 XA START '1';
12 REPLACE INTO t VALUES(10, 1);
13 REPLACE INTO t VALUES(20, 1);
14 SET DEBUG_SYNC= 'ib_after_row_insert SIGNAL inserted WAIT_FOR cont';
15 REPLACE INTO t VALUES(30, 1);
16 connect con1,localhost,root;
17 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
18 XA START '2';
19 SET DEBUG_SYNC= 'now WAIT_FOR inserted';
20 INSERT INTO t VALUES(40, 2);
21 SET DEBUG_SYNC= 'now SIGNAL cont';
22 connection default;
23 XA END '1';
24 XA PREPARE '1';
25 connection default;
26 XA COMMIT '1';
27 connection con1;
28 XA END '2';
29 XA PREPARE '2';
30 XA COMMIT '2';
31 disconnect con1;
32 connection default;
33 SET DEBUG_SYNC= "RESET";
34 DROP TABLE t;