use test;
create table `t1` (`c1` tinyint unsigned not null, key `c1` (`c1`))
engine=falcon default charset=utf8;
alter table `t1` disable keys;
insert into t1 values (1),(2),(3),(4);
select now() as "Initial", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 1", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 2", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 3", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 4", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 5", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 6", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 7", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 8", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 9", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 10", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 11", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 12", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 13", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 14", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 15", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 16", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 17", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 18", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 19", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 20", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 21", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 22", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 23", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 24", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 25", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 26", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 27", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 28", count(*) as "Rows" from t1;
insert into t1 select * from t1;
select now() as "Round 29", count(*) as "Rows" from t1;
-- Insert 4294967295 rows.
insert into t1 select * from t1 limit 2147483647;
select now() as "Round 30", count(*) as "Rows" from t1;
alter table t1 enable keys;
-- drop table t1;