| 1 |
CREATE TABLE t1(id INT PRIMARY KEY); |
| 2 |
# |
| 3 |
# 1) Prepare XA transaction with some sample data with |
| 4 |
# XA global Trx id '1'. |
| 5 |
# |
| 6 |
XA START '1'; |
| 7 |
INSERT INTO t1 VALUES (1); |
| 8 |
XA END '1'; |
| 9 |
XA PREPARE '1'; |
| 10 |
# |
| 11 |
# 2) Try to do 'XA ROLLBACK' with XA global Trx id '2' and check that |
| 12 |
# it fails. |
| 13 |
# |
| 14 |
XA ROLLBACK '2'; |
| 15 |
# |
| 16 |
# 3) Check that nothing is written to binary log. |
| 17 |
# |
| 18 |
include/assert.inc [Nothing should be written in binlog for failed XA ROLLBACK.] |
| 19 |
# |
| 20 |
# 4) Cleanup. |
| 21 |
# |
| 22 |
XA COMMIT '1'; |
| 23 |
DROP TABLE t1; |