| 1 |
################################################################################ |
| 2 |
# BUG#20608551 WL#6860 : XA PREPARED TRANSACTION DOESNT RETURN "ALL GTIDS" IN |
| 3 |
# THE OK PACKET |
| 4 |
# |
| 5 |
# Verify that XA PREPARE statement returns correct gtid set to the OK packet, |
| 6 |
# when session_track_gtids=all_gtids or own_gtid |
| 7 |
################################################################################ |
| 8 |
# Test is binlog_format-agnostic. |
| 9 |
--source include/have_binlog_format_mixed.inc |
| 10 |
|
| 11 |
# need debug build to be able to set a deterministic server uuid |
| 12 |
--source include/have_debug.inc |
| 13 |
|
| 14 |
# Session tracking output will be different when without xa_detach_on_prepare |
| 15 |
--let $option_name = xa_detach_on_prepare |
| 16 |
--let $option_value = 1 |
| 17 |
--source include/only_with_option.inc |
| 18 |
|
| 19 |
RESET MASTER; |
| 20 |
|
| 21 |
CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; |
| 22 |
--echo |
| 23 |
|
| 24 |
SET SESSION session_track_gtids='all_gtids'; |
| 25 |
--enable_session_track_info |
| 26 |
XA START '1-trx'; |
| 27 |
INSERT INTO t1 VALUES(1); |
| 28 |
XA END '1-trx'; |
| 29 |
XA PREPARE '1-trx'; |
| 30 |
XA COMMIT '1-trx'; |
| 31 |
--disable_session_track_info |
| 32 |
|
| 33 |
--echo |
| 34 |
SET SESSION session_track_gtids='own_gtid'; |
| 35 |
--enable_session_track_info |
| 36 |
XA START '2-trx'; |
| 37 |
INSERT INTO t1 VALUES(1); |
| 38 |
XA END '2-trx'; |
| 39 |
XA PREPARE '2-trx'; |
| 40 |
XA COMMIT '2-trx'; |
| 41 |
--disable_session_track_info |
| 42 |
|
| 43 |
DROP TABLE t1; |