| 1 |
include/only_with_option.inc [GLOBAL.xa_detach_on_prepare = 1] |
| 2 |
RESET MASTER; |
| 3 |
CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; |
| 4 |
|
| 5 |
SET SESSION session_track_gtids='all_gtids'; |
| 6 |
XA START '1-trx'; |
| 7 |
-- Tracker : SESSION_TRACK_TRANSACTION_STATE |
| 8 |
-- T_______ |
| 9 |
|
| 10 |
INSERT INTO t1 VALUES(1); |
| 11 |
XA END '1-trx'; |
| 12 |
XA PREPARE '1-trx'; |
| 13 |
-- Tracker : SESSION_TRACK_GTIDS |
| 14 |
-- 00000000-1111-0000-1111-000000000000:1-2 |
| 15 |
|
| 16 |
-- Tracker : SESSION_TRACK_TRANSACTION_STATE |
| 17 |
-- ________ |
| 18 |
|
| 19 |
XA COMMIT '1-trx'; |
| 20 |
-- Tracker : SESSION_TRACK_GTIDS |
| 21 |
-- 00000000-1111-0000-1111-000000000000:1-3 |
| 22 |
|
| 23 |
|
| 24 |
SET SESSION session_track_gtids='own_gtid'; |
| 25 |
XA START '2-trx'; |
| 26 |
-- Tracker : SESSION_TRACK_TRANSACTION_STATE |
| 27 |
-- T_______ |
| 28 |
|
| 29 |
INSERT INTO t1 VALUES(1); |
| 30 |
XA END '2-trx'; |
| 31 |
XA PREPARE '2-trx'; |
| 32 |
-- Tracker : SESSION_TRACK_GTIDS |
| 33 |
-- 00000000-1111-0000-1111-000000000000:4 |
| 34 |
|
| 35 |
-- Tracker : SESSION_TRACK_TRANSACTION_STATE |
| 36 |
-- ________ |
| 37 |
|
| 38 |
XA COMMIT '2-trx'; |
| 39 |
-- Tracker : SESSION_TRACK_GTIDS |
| 40 |
-- 00000000-1111-0000-1111-000000000000:5 |
| 41 |
|
| 42 |
DROP TABLE t1; |