diff options
author | unknown <knielsen@knielsen-hq.org> | 2011-04-08 09:39:33 +0200 |
---|---|---|
committer | unknown <knielsen@knielsen-hq.org> | 2011-04-08 09:39:33 +0200 |
commit | 64e43e1cc88c66bd89f95a5307020bcf60ba4b96 (patch) | |
tree | 1ae6299d5a75f92fa97b240b0670c81c9a301afe /mysql-test/suite/pbxt | |
parent | 8b427b7d5548aeb214c70b004cc9056b9f7a6f7c (diff) | |
parent | 86008e0ca2b864f1ab7a30e496d7c67c8fce06c2 (diff) | |
download | mariadb-git-64e43e1cc88c66bd89f95a5307020bcf60ba4b96.tar.gz |
Merge various replication-related patches into MariaDB 5.3:
- MWL#116 Group commit
- MWL#136 Enhancements for START TRANSACTION WITH CONSISTENT SNAPSHOT
- MWL#47 Annotate_rows_log_event
- MWL#163 innodb_release_locks_early
- Percona patch enhancing row-based replication for tables with no primary key
Diffstat (limited to 'mysql-test/suite/pbxt')
-rw-r--r-- | mysql-test/suite/pbxt/r/pbxt_xa_binlog.result | 32 | ||||
-rw-r--r-- | mysql-test/suite/pbxt/t/pbxt_xa_binlog.test | 32 |
2 files changed, 64 insertions, 0 deletions
diff --git a/mysql-test/suite/pbxt/r/pbxt_xa_binlog.result b/mysql-test/suite/pbxt/r/pbxt_xa_binlog.result new file mode 100644 index 00000000000..abfeebb5b96 --- /dev/null +++ b/mysql-test/suite/pbxt/r/pbxt_xa_binlog.result @@ -0,0 +1,32 @@ +drop table if exists t1, t2; +SET binlog_format = 'mixed'; +CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb; +CREATE TABLE t2 (b INT PRIMARY KEY) ENGINE=pbxt; +BEGIN; +SELECT @@log_bin; +@@log_bin +1 +INSERT INTO t1 VALUES (1); +INSERT INTO t2 VALUES (2); +COMMIT; +select * from t1; +a +1 +select * from t2; +b +2 +SET sql_log_bin = 0; +BEGIN; +INSERT INTO t1 VALUES (3); +INSERT INTO t2 VALUES (4); +COMMIT; +select * from t1 order by a; +a +1 +3 +select * from t2 order by b; +b +2 +4 +drop table t1, t2; +drop database pbxt; diff --git a/mysql-test/suite/pbxt/t/pbxt_xa_binlog.test b/mysql-test/suite/pbxt/t/pbxt_xa_binlog.test new file mode 100644 index 00000000000..4a4578a5595 --- /dev/null +++ b/mysql-test/suite/pbxt/t/pbxt_xa_binlog.test @@ -0,0 +1,32 @@ +--source include/have_innodb.inc +--source include/have_log_bin.inc + +--disable_warnings +drop table if exists t1, t2; +--enable_warnings + +SET binlog_format = 'mixed'; + +CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb; +CREATE TABLE t2 (b INT PRIMARY KEY) ENGINE=pbxt; +BEGIN; +# verify that binlog is on +SELECT @@log_bin; +INSERT INTO t1 VALUES (1); +INSERT INTO t2 VALUES (2); +COMMIT; +select * from t1; +select * from t2; + +# Test 2-phase commit when we disable binlogging. +SET sql_log_bin = 0; +BEGIN; +INSERT INTO t1 VALUES (3); +INSERT INTO t2 VALUES (4); +COMMIT; +select * from t1 order by a; +select * from t2 order by b; + +drop table t1, t2; +drop database pbxt; + |