|
Elaborated MDEV-32347 description test demonstrates how a prepared user XA transaction
gets rolled back:
CREATE TABLE ti (c INT KEY) engine=Innodb;
|
XA START 'xid_i';
|
INSERT INTO ti VALUES (1);
|
XA END 'xid_i';
|
XA PREPARE 'xid_i';
|
|
# --error ER_XAER_RMFAIL
|
LOAD INDEX INTO CACHE c KEY(PRIMARY);
|
|
XA COMMIT 'xid_i';
|
|
SELECT count(*) = 1 FROM ti;
|
# => 0 (sic!)
|
LOAD INDEX INTO CACHE and CACHE INDEX ... must also error out which is not done (by at least LOAD INDEX) either.
No other sql commands, form either DML:s or DDL:s class, are found to produce similar effect.
|