diff options
Diffstat (limited to 'mysql-test/t/binlog.test')
| -rw-r--r-- | mysql-test/t/binlog.test | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/mysql-test/t/binlog.test b/mysql-test/t/binlog.test new file mode 100644 index 00000000000..1063940d378 --- /dev/null +++ b/mysql-test/t/binlog.test @@ -0,0 +1,49 @@ +# +# misc binlogging tests that do not require a slave running +# +-- source include/not_embedded.inc +-- source include/have_bdb.inc +-- source include/have_innodb.inc + +--disable_warnings +drop table if exists t1, t2; +--enable_warnings +reset master; + +create table t1 (a int) engine=bdb; +create table t2 (a int) engine=innodb; +begin; +insert t1 values (5); +commit; +begin; +insert t2 values (5); +commit; +# first COMMIT must be Query_log_event, second - Xid_log_event +--replace_result "xid=21" "xid=12" +--replace_column 2 # 5 # +show binlog events from 98; +drop table t1,t2; + +# +# binlog rotation after one big transaction +# +reset master; +let $1=100; + +create table t1 (n int) engine=innodb; +begin; +--disable_query_log +while ($1) +{ + eval insert into t1 values($1 + 4); + dec $1; +} +--enable_query_log +commit; +drop table t1; +--replace_result "xid=32" "xid=19" +--replace_column 2 # 5 # +show binlog events in 'master-bin.000001' from 98; +--replace_column 2 # 5 # +show binlog events in 'master-bin.000002' from 98; + |