Debian Codegraph @

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

raw
1 CREATE TABLE t (
2 `a` INT NOT NULL,
3 PRIMARY KEY (`a`)
4 ) ENGINE=InnoDB;
5 INSERT INTO t VALUES(10);
6 INSERT INTO t VALUES(20);
7 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
8 XA START '1';
9 SELECT * FROM t WHERE a > 20 FOR UPDATE;
10 a
11 INSERT INTO t VALUES(40);
12 XA END '1';
13 XA PREPARE '1';
14 connect con1,localhost,root;
15 SET innodb_lock_wait_timeout=1;
16 INSERT INTO t VALUES(50);
17 connection default;
18 XA COMMIT '1';
19 XA START '1';
20 SELECT * FROM t WHERE a > 20 LOCK IN SHARE MODE;
21 a
22 40
23 50
24 INSERT INTO t VALUES (5);
25 XA END '1';
26 XA PREPARE '1';
27 connection con1;
28 INSERT INTO t VALUES (60);
29 INSERT INTO t VALUES (30);
30 disconnect con1;
31 connection default;
32 XA COMMIT '1';
33 DROP TABLE t;