xa-4.test

-- source include/have_innodb.inc
-- source include/have_tokudb.inc
-- source include/have_debug.inc

--disable_warnings
drop table if exists t1, t2;
--enable_warnings

#
# bug lp:544173, xa crash with two 2pc-capable storage engines without binlog
#

CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb;
CREATE TABLE t2 (b INT PRIMARY KEY) ENGINE=tokudb;
BEGIN;
# verify that binlog is off
SELECT @@log_bin;
INSERT INTO t1 VALUES (1);
INSERT INTO t2 VALUES (2);

SET SESSION debug="d,crash_commit_before";
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect

--error 2013
COMMIT;

--enable_reconnect

--source include/wait_until_connected_again.inc
select * from t1;
select * from t2;

drop table t1, t2;


CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb;
CREATE TABLE t2 (b INT PRIMARY KEY) ENGINE=tokudb;
BEGIN;
# verify that binlog is off
SELECT @@log_bin;
INSERT INTO t1 VALUES (1);
INSERT INTO t2 VALUES (2);

SET SESSION debug="d,crash_commit_after";
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect

--error 2013
COMMIT;

--enable_reconnect

--source include/wait_until_connected_again.inc
select * from t1;
select * from t2;

drop table t1, t2;