Debian Codegraph @

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

raw
1 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
2 INSERT INTO t1 VALUES (1);
3 XA START 'x';
4 UPDATE t1 set a=2;
5 XA END 'x';
6 XA PREPARE 'x';
7 call mtr.add_suppression("Found 1 prepared XA transactions");
8 # Kill and restart
9 SELECT * FROM t1 LOCK IN SHARE MODE;
10 # restart
11 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
12 SELECT * FROM t1;
13 a
14 2
15 XA ROLLBACK 'x';
16 SELECT * FROM t1;
17 a
18 1
19 DROP TABLE t1;
20 #
21 # Bug #31437127 - ERROR LOG REPORTS INVALID (OLD?) TABLE OR DATABASE NAME:
22 # ERROR] [MY-010520] [Server] Invalid (old?) table or database name 't1#p#p1'
23 #
24 call mtr.add_suppression("Found .* prepared XA transactions");
25 CREATE TABLE t1(a INT PRIMARY KEY, b INT) PARTITION BY HASH(a) PARTITIONS 4;
26 XA BEGIN '123';
27 INSERT INTO t1 VALUES(1,2);
28 XA END '123';
29 XA PREPARE '123';
30 # restart
31 XA RECOVER;
32 formatID gtrid_length bqual_length data
33 1 3 0 123
34 XA COMMIT '123';
35 DROP TABLE t1;