summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/t/innodb_defrag_binlog.test
blob: ec3203893a40eacf449036391995e2e8d82421b8 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
--source include/have_innodb.inc
--source include/master-slave.inc
--source include/big_test.inc
--source include/not_valgrind.inc
--source include/not_embedded.inc

--disable_warnings
drop table if exists t1;
--enable_warnings

create table t1(a int not null primary key auto_increment, b varchar(256), key second(b)) engine=innodb;

insert into t1 values (1, REPEAT("a", 256));
insert into t1 values (2, REPEAT("a", 256));
optimize table t1;

drop table t1;

--replace_regex /\/\* xid=.* \*\//\/* XID *\// /Server ver: .*, Binlog ver: .*/Server ver: #, Binlog ver: #/ /table_id: [0-9]+/table_id: #/
show binlog events in 'master-bin.000001' from 313;

--source include/rpl_end.inc