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;

create logfile group lg1 add undofile 'undofile.dat' initial_size=100M undo_buffer_size=1M engine=ndb;

create tablespace ts1 add datafile 'datafile01.dat' use logfile group lg1 initial_size=200M engine=ndb;

create table t1 (a int not null auto_increment primary key, b varchar(1)) tablespace ts1 storage disk engine=ndb;

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

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

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

delete from t2;

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

