summaryrefslogtreecommitdiff
path: root/mysql-test/t/binlog.test
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2005-02-23 20:35:59 +0100
committerunknown <serg@serg.mylan>2005-02-23 20:35:59 +0100
commitbef32dfacd53c74ab2c78912ba20aa8bb37aced4 (patch)
treea3a02de15dc4fae9284a7557794d6eeab1c2d805 /mysql-test/t/binlog.test
parent58df85e06a88f4cafe48934d058f5bfb66831661 (diff)
downloadmariadb-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.test24
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;
+