diff options
author | unknown <serg@serg.mylan> | 2005-02-23 20:35:59 +0100 |
---|---|---|
committer | unknown <serg@serg.mylan> | 2005-02-23 20:35:59 +0100 |
commit | bef32dfacd53c74ab2c78912ba20aa8bb37aced4 (patch) | |
tree | a3a02de15dc4fae9284a7557794d6eeab1c2d805 /mysql-test/t/binlog.test | |
parent | 58df85e06a88f4cafe48934d058f5bfb66831661 (diff) | |
download | mariadb-git-bef32dfacd53c74ab2c78912ba20aa8bb37aced4.tar.gz |
innodb-dependent test moved from rpl_rotate_logs.test to binlog.test
mysql-test/r/binlog.result:
binlog rotation after a big transation
mysql-test/r/rpl_rotate_logs.result:
innodb-dependent test removed
mysql-test/t/binlog.test:
binlog rotation after a big transation
mysql-test/t/rpl_rotate_logs.test:
innodb-dependent test removed
Diffstat (limited to 'mysql-test/t/binlog.test')
-rw-r--r-- | mysql-test/t/binlog.test | 24 |
1 files changed, 22 insertions, 2 deletions
diff --git a/mysql-test/t/binlog.test b/mysql-test/t/binlog.test index 2f97a5088ba..5862861eaeb 100644 --- a/mysql-test/t/binlog.test +++ b/mysql-test/t/binlog.test @@ -18,8 +18,28 @@ begin; insert t2 values (5); commit; # first COMMIT must be Query_log_event, second - Xid_log_event ---replace_result "xid=891" "xid=318" "xid=11" "xid=318" "xid=18" "xid=318" +--replace_result "xid=18" "xid=11" show binlog events from 96; -reset master; 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=29" "xid=18" +show binlog events in 'master-bin.000001' from 96; +show binlog events in 'master-bin.000002' from 96; + |