1 # Bug 11766634 59783: InnoDB data grows unexpectedly when inserting,
2 # truncating, inserting the same set of rows.
5 # create table t1. Insert $recs records. check size of ibdata1.
6 # drop table t1. create table t1. Insert the same set of $recs
7 # records. The size of ibdata1 must not increase.
10 -- source include/not_embedded.inc
11 -- source include/have_innodb_plugin.inc
13 create table t1 (f1 char(255)) engine innodb;
14 let $MYSQLD_DATADIR=`select @@datadir`;
15 let IBDATA1=$MYSQLD_DATADIR/ibdata1;
24 insert into t1 values ('Hello World');
31 my $filesize = -s $ENV{'IBDATA1'};
32 print "ibdata1 size: $filesize bytes\n";
36 create table t1 (f1 char(255)) engine innodb;
43 insert into t1 values ('Hello World');
50 my $filesize = -s $ENV{'IBDATA1'};
51 print "ibdata1 size: $filesize bytes\n";