diff options
Diffstat (limited to 'storage/tokudb/mysql-test/rpl/r/rpl_xa_interleave.result')
-rw-r--r-- | storage/tokudb/mysql-test/rpl/r/rpl_xa_interleave.result | 78 |
1 files changed, 78 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/rpl/r/rpl_xa_interleave.result b/storage/tokudb/mysql-test/rpl/r/rpl_xa_interleave.result new file mode 100644 index 00000000000..98ded9d2097 --- /dev/null +++ b/storage/tokudb/mysql-test/rpl/r/rpl_xa_interleave.result @@ -0,0 +1,78 @@ +include/master-slave.inc +[connection master] +CREATE TABLE t1(`a` INT) ENGINE=TokuDB; +connection master; +XA START 'x1'; +INSERT INTO t1 VALUES (1); +XA END 'x1'; +XA PREPARE 'x1'; +connection master1; +BEGIN; +INSERT INTO t1 VALUES (10); +COMMIT; +XA START 'y1'; +INSERT INTO t1 VALUES (2); +XA END 'y1'; +XA PREPARE 'y1'; +connection master; +XA COMMIT 'x1'; +connection master1; +XA COMMIT 'y1'; +connection master; +BEGIN; +INSERT INTO t1 VALUES (11); +COMMIT; +XA START 'x2'; +INSERT INTO t1 VALUES (3); +XA END 'x2'; +XA PREPARE 'x2'; +connection master1; +XA START 'y2'; +INSERT INTO t1 VALUES (4); +XA END 'y2'; +XA PREPARE 'y2'; +connection master; +XA COMMIT 'x2'; +connection master1; +XA COMMIT 'y2'; +connection master; +XA START 'x1'; +INSERT INTO t1 VALUES (1); +XA END 'x1'; +XA PREPARE 'x1'; +connection master1; +BEGIN; +INSERT INTO t1 VALUES (10); +COMMIT; +XA START 'y1'; +INSERT INTO t1 VALUES (2); +XA END 'y1'; +XA PREPARE 'y1'; +connection master; +XA ROLLBACK 'x1'; +connection master1; +XA ROLLBACK 'y1'; +connection master; +BEGIN; +INSERT INTO t1 VALUES (11); +COMMIT; +XA START 'x2'; +INSERT INTO t1 VALUES (3); +XA END 'x2'; +XA PREPARE 'x2'; +connection master1; +XA START 'y2'; +INSERT INTO t1 VALUES (4); +XA END 'y2'; +XA PREPARE 'y2'; +connection master; +XA ROLLBACK 'x2'; +connection master1; +XA ROLLBACK 'y2'; +connection master; +connection slave; +TABLES t1 and t2 must be equal otherwise an error will be thrown. +include/diff_tables.inc [master:test.t1, slave:test.t1] +connection master; +DROP TABLE t1; +include/rpl_end.inc |