use test;

drop table if exists t1;
drop table if exists t2;

#alter tablespace ts1 drop datafile 'datafile01.dat' engine=ndb;
#drop tablespace ts1 engine=ndb;
#drop logfile group lg1 engine=ndb;
#reset master;
create table t1 (a int not null auto_increment primary key, b varchar(1)) engine=ndb;

create table t2 (a int not null auto_increment primary key, b varchar(1)) engine=ndb;

let $1 = 10000;
while ($1) {
  insert into t2(b) values('a');
  dec $1;
}

let $1 = 100;
while ($1) {
  insert into t1(b) select b from t2;
  dec $1;
}

delete from t2;

let $1 = 100;
while ($1) {
  alter table t2 add column c varchar(1);
  insert into t2(b) select b from t1 limit 200000;  
  alter table t2 drop column c;
  delete from t2;
  dec $1;
}

