Debian Codegraph @

mysql-test/suite/innodb/t/innodb-xa.test

raw
1 --source include/have_innodb.inc
2
3 --error ER_XAER_NOTA
4 xa rollback 'xid2';
5 drop table if exists t1;
6 create table t1(a int)engine=innodb;
7 rollback;
8 xa start 'xid2';
9 insert into `t1` values (1);
10 savepoint `sv1`;
11 xa end 'xid2';
12 --error ER_XAER_RMFAIL
13 start transaction;
14 xa prepare 'xid2';
15 release savepoint `sv1`;
16 xa commit 'xid2';
17 drop table t1;
18
19 -- echo #
20 -- echo # MDEV-31928 Assertion xid ... < 128 failed in trx_undo_write_xid()
21 -- echo #
22
23 CREATE TABLE t (a INT PRIMARY KEY) ENGINE=INNODB;
24 --error ER_PARSE_ERROR
25 XA START 'gtrid_67890123456789012345678901234567890123456789012345678901234','bqual_6789012345678901234567890123456789012345678901234567890123',1234567890;
26 --error ER_PARSE_ERROR
27 XA START 'gtrid_6789012345678901234567890123456789012345678901234567890123','bqual_67890123456789012345678901234567890123456789012345678901234',1234567890;
28 XA START 'gtrid_6789012345678901234567890123456789012345678901234567890123','bqual_6789012345678901234567890123456789012345678901234567890123',1234567890;
29
30 INSERT INTO t VALUES(1);
31
32 --error ER_PARSE_ERROR
33 XA END 'gtrid_67890123456789012345678901234567890123456789012345678901234','bqual_6789012345678901234567890123456789012345678901234567890123',1234567890;
34 --error ER_PARSE_ERROR
35 XA END 'gtrid_6789012345678901234567890123456789012345678901234567890123','bqual_67890123456789012345678901234567890123456789012345678901234',1234567890;
36 XA END 'gtrid_6789012345678901234567890123456789012345678901234567890123','bqual_6789012345678901234567890123456789012345678901234567890123',1234567890;
37 --error ER_PARSE_ERROR
38 XA PREPARE 'gtrid_67890123456789012345678901234567890123456789012345678901234','bqual_6789012345678901234567890123456789012345678901234567890123',1234567890;
39 --error ER_PARSE_ERROR
40 XA PREPARE 'gtrid_6789012345678901234567890123456789012345678901234567890123','bqual_67890123456789012345678901234567890123456789012345678901234',1234567890;
41 XA PREPARE 'gtrid_6789012345678901234567890123456789012345678901234567890123','bqual_6789012345678901234567890123456789012345678901234567890123',1234567890;
42 --error ER_PARSE_ERROR
43 XA COMMIT 'gtrid_67890123456789012345678901234567890123456789012345678901234','bqual_6789012345678901234567890123456789012345678901234567890123',1234567890;
44 --error ER_PARSE_ERROR
45 XA COMMIT 'gtrid_6789012345678901234567890123456789012345678901234567890123','bqual_67890123456789012345678901234567890123456789012345678901234',1234567890;
46 XA COMMIT 'gtrid_6789012345678901234567890123456789012345678901234567890123','bqual_6789012345678901234567890123456789012345678901234567890123',1234567890;
47
48 DROP TABLE t;
49
50 -- echo # End of 10.4 tests