drop table if exists s;
create table s (a int, b int, c int) engine=tokudb;
insert into s values (10,10,10);
insert into s values (10,10,9);
insert into s values (10,10,8);
insert into s values (10,10,7);
insert into s values (10,10,6);
insert into s values (10,10,5);
insert into s values (10,10,4);
insert into s values (10,10,3);
insert into s values (10,10,2);
insert into s values (10,10,1);
insert into s values (10,9,10);
insert into s values (10,9,9);
insert into s values (10,9,8);
insert into s values (10,9,7);
insert into s values (10,9,6);
insert into s values (10,9,5);
insert into s values (10,9,4);
insert into s values (10,9,3);
insert into s values (10,9,2);
insert into s values (10,9,1);
insert into s values (10,8,10);
insert into s values (10,8,9);
insert into s values (10,8,8);
insert into s values (10,8,7);
insert into s values (10,8,6);
insert into s values (10,8,5);
insert into s values (10,8,4);
insert into s values (10,8,3);
insert into s values (10,8,2);
insert into s values (10,8,1);
insert into s values (10,7,10);
insert into s values (10,7,9);
insert into s values (10,7,8);
insert into s values (10,7,7);
insert into s values (10,7,6);
insert into s values (10,7,5);
insert into s values (10,7,4);
insert into s values (10,7,3);
insert into s values (10,7,2);
insert into s values (10,7,1);
insert into s values (10,6,10);
insert into s values (10,6,9);
insert into s values (10,6,8);
insert into s values (10,6,7);
insert into s values (10,6,6);
insert into s values (10,6,5);
insert into s values (10,6,4);
insert into s values (10,6,3);
insert into s values (10,6,2);
insert into s values (10,6,1);
insert into s values (10,5,10);
insert into s values (10,5,9);
insert into s values (10,5,8);
insert into s values (10,5,7);
insert into s values (10,5,6);
insert into s values (10,5,5);
insert into s values (10,5,4);
insert into s values (10,5,3);
insert into s values (10,5,2);
insert into s values (10,5,1);
insert into s values (10,4,10);
insert into s values (10,4,9);
insert into s values (10,4,8);
insert into s values (10,4,7);
insert into s values (10,4,6);
insert into s values (10,4,5);
insert into s values (10,4,4);
insert into s values (10,4,3);
insert into s values (10,4,2);
insert into s values (10,4,1);
insert into s values (10,3,10);
insert into s values (10,3,9);
insert into s values (10,3,8);
insert into s values (10,3,7);
insert into s values (10,3,6);
insert into s values (10,3,5);
insert into s values (10,3,4);
insert into s values (10,3,3);
insert into s values (10,3,2);
insert into s values (10,3,1);
insert into s values (10,2,10);
insert into s values (10,2,9);
insert into s values (10,2,8);
insert into s values (10,2,7);
insert into s values (10,2,6);
insert into s values (10,2,5);
insert into s values (10,2,4);
insert into s values (10,2,3);
insert into s values (10,2,2);
insert into s values (10,2,1);
insert into s values (10,1,10);
insert into s values (10,1,9);
insert into s values (10,1,8);
insert into s values (10,1,7);
insert into s values (10,1,6);
insert into s values (10,1,5);
insert into s values (10,1,4);
insert into s values (10,1,3);
insert into s values (10,1,2);
insert into s values (10,1,1);
insert into s values (9,10,10);
insert into s values (9,10,9);
insert into s values (9,10,8);
insert into s values (9,10,7);
insert into s values (9,10,6);
insert into s values (9,10,5);
insert into s values (9,10,4);
insert into s values (9,10,3);
insert into s values (9,10,2);
insert into s values (9,10,1);
insert into s values (9,9,10);
insert into s values (9,9,9);
insert into s values (9,9,8);
insert into s values (9,9,7);
insert into s values (9,9,6);
insert into s values (9,9,5);
insert into s values (9,9,4);
insert into s values (9,9,3);
insert into s values (9,9,2);
insert into s values (9,9,1);
insert into s values (9,8,10);
insert into s values (9,8,9);
insert into s values (9,8,8);
insert into s values (9,8,7);
insert into s values (9,8,6);
insert into s values (9,8,5);
insert into s values (9,8,4);
insert into s values (9,8,3);
insert into s values (9,8,2);
insert into s values (9,8,1);
insert into s values (9,7,10);
insert into s values (9,7,9);
insert into s values (9,7,8);
insert into s values (9,7,7);
insert into s values (9,7,6);
insert into s values (9,7,5);
insert into s values (9,7,4);
insert into s values (9,7,3);
insert into s values (9,7,2);
insert into s values (9,7,1);
insert into s values (9,6,10);
insert into s values (9,6,9);
insert into s values (9,6,8);
insert into s values (9,6,7);
insert into s values (9,6,6);
insert into s values (9,6,5);
insert into s values (9,6,4);
insert into s values (9,6,3);
insert into s values (9,6,2);
insert into s values (9,6,1);
insert into s values (9,5,10);
insert into s values (9,5,9);
insert into s values (9,5,8);
insert into s values (9,5,7);
insert into s values (9,5,6);
insert into s values (9,5,5);
insert into s values (9,5,4);
insert into s values (9,5,3);
insert into s values (9,5,2);
insert into s values (9,5,1);
insert into s values (9,4,10);
insert into s values (9,4,9);
insert into s values (9,4,8);
insert into s values (9,4,7);
insert into s values (9,4,6);
insert into s values (9,4,5);
insert into s values (9,4,4);
insert into s values (9,4,3);
insert into s values (9,4,2);
insert into s values (9,4,1);
insert into s values (9,3,10);
insert into s values (9,3,9);
insert into s values (9,3,8);
insert into s values (9,3,7);
insert into s values (9,3,6);
insert into s values (9,3,5);
insert into s values (9,3,4);
insert into s values (9,3,3);
insert into s values (9,3,2);
insert into s values (9,3,1);
insert into s values (9,2,10);
insert into s values (9,2,9);
insert into s values (9,2,8);
insert into s values (9,2,7);
insert into s values (9,2,6);
insert into s values (9,2,5);
insert into s values (9,2,4);
insert into s values (9,2,3);
insert into s values (9,2,2);
insert into s values (9,2,1);
insert into s values (9,1,10);
insert into s values (9,1,9);
insert into s values (9,1,8);
insert into s values (9,1,7);
insert into s values (9,1,6);
insert into s values (9,1,5);
insert into s values (9,1,4);
insert into s values (9,1,3);
insert into s values (9,1,2);
insert into s values (9,1,1);
insert into s values (8,10,10);
insert into s values (8,10,9);
insert into s values (8,10,8);
insert into s values (8,10,7);
insert into s values (8,10,6);
insert into s values (8,10,5);
insert into s values (8,10,4);
insert into s values (8,10,3);
insert into s values (8,10,2);
insert into s values (8,10,1);
insert into s values (8,9,10);
insert into s values (8,9,9);
insert into s values (8,9,8);
insert into s values (8,9,7);
insert into s values (8,9,6);
insert into s values (8,9,5);
insert into s values (8,9,4);
insert into s values (8,9,3);
insert into s values (8,9,2);
insert into s values (8,9,1);
insert into s values (8,8,10);
insert into s values (8,8,9);
insert into s values (8,8,8);
insert into s values (8,8,7);
insert into s values (8,8,6);
insert into s values (8,8,5);
insert into s values (8,8,4);
insert into s values (8,8,3);
insert into s values (8,8,2);
insert into s values (8,8,1);
insert into s values (8,7,10);
insert into s values (8,7,9);
insert into s values (8,7,8);
insert into s values (8,7,7);
insert into s values (8,7,6);
insert into s values (8,7,5);
insert into s values (8,7,4);
insert into s values (8,7,3);
insert into s values (8,7,2);
insert into s values (8,7,1);
insert into s values (8,6,10);
insert into s values (8,6,9);
insert into s values (8,6,8);
insert into s values (8,6,7);
insert into s values (8,6,6);
insert into s values (8,6,5);
insert into s values (8,6,4);
insert into s values (8,6,3);
insert into s values (8,6,2);
insert into s values (8,6,1);
insert into s values (8,5,10);
insert into s values (8,5,9);
insert into s values (8,5,8);
insert into s values (8,5,7);
insert into s values (8,5,6);
insert into s values (8,5,5);
insert into s values (8,5,4);
insert into s values (8,5,3);
insert into s values (8,5,2);
insert into s values (8,5,1);
insert into s values (8,4,10);
insert into s values (8,4,9);
insert into s values (8,4,8);
insert into s values (8,4,7);
insert into s values (8,4,6);
insert into s values (8,4,5);
insert into s values (8,4,4);
insert into s values (8,4,3);
insert into s values (8,4,2);
insert into s values (8,4,1);
insert into s values (8,3,10);
insert into s values (8,3,9);
insert into s values (8,3,8);
insert into s values (8,3,7);
insert into s values (8,3,6);
insert into s values (8,3,5);
insert into s values (8,3,4);
insert into s values (8,3,3);
insert into s values (8,3,2);
insert into s values (8,3,1);
insert into s values (8,2,10);
insert into s values (8,2,9);
insert into s values (8,2,8);
insert into s values (8,2,7);
insert into s values (8,2,6);
insert into s values (8,2,5);
insert into s values (8,2,4);
insert into s values (8,2,3);
insert into s values (8,2,2);
insert into s values (8,2,1);
insert into s values (8,1,10);
insert into s values (8,1,9);
insert into s values (8,1,8);
insert into s values (8,1,7);
insert into s values (8,1,6);
insert into s values (8,1,5);
insert into s values (8,1,4);
insert into s values (8,1,3);
insert into s values (8,1,2);
insert into s values (8,1,1);
insert into s values (7,10,10);
insert into s values (7,10,9);
insert into s values (7,10,8);
insert into s values (7,10,7);
insert into s values (7,10,6);
insert into s values (7,10,5);
insert into s values (7,10,4);
insert into s values (7,10,3);
insert into s values (7,10,2);
insert into s values (7,10,1);
insert into s values (7,9,10);
insert into s values (7,9,9);
insert into s values (7,9,8);
insert into s values (7,9,7);
insert into s values (7,9,6);
insert into s values (7,9,5);
insert into s values (7,9,4);
insert into s values (7,9,3);
insert into s values (7,9,2);
insert into s values (7,9,1);
insert into s values (7,8,10);
insert into s values (7,8,9);
insert into s values (7,8,8);
insert into s values (7,8,7);
insert into s values (7,8,6);
insert into s values (7,8,5);
insert into s values (7,8,4);
insert into s values (7,8,3);
insert into s values (7,8,2);
insert into s values (7,8,1);
insert into s values (7,7,10);
insert into s values (7,7,9);
insert into s values (7,7,8);
insert into s values (7,7,7);
insert into s values (7,7,6);
insert into s values (7,7,5);
insert into s values (7,7,4);
insert into s values (7,7,3);
insert into s values (7,7,2);
insert into s values (7,7,1);
insert into s values (7,6,10);
insert into s values (7,6,9);
insert into s values (7,6,8);
insert into s values (7,6,7);
insert into s values (7,6,6);
insert into s values (7,6,5);
insert into s values (7,6,4);
insert into s values (7,6,3);
insert into s values (7,6,2);
insert into s values (7,6,1);
insert into s values (7,5,10);
insert into s values (7,5,9);
insert into s values (7,5,8);
insert into s values (7,5,7);
insert into s values (7,5,6);
insert into s values (7,5,5);
insert into s values (7,5,4);
insert into s values (7,5,3);
insert into s values (7,5,2);
insert into s values (7,5,1);
insert into s values (7,4,10);
insert into s values (7,4,9);
insert into s values (7,4,8);
insert into s values (7,4,7);
insert into s values (7,4,6);
insert into s values (7,4,5);
insert into s values (7,4,4);
insert into s values (7,4,3);
insert into s values (7,4,2);
insert into s values (7,4,1);
insert into s values (7,3,10);
insert into s values (7,3,9);
insert into s values (7,3,8);
insert into s values (7,3,7);
insert into s values (7,3,6);
insert into s values (7,3,5);
insert into s values (7,3,4);
insert into s values (7,3,3);
insert into s values (7,3,2);
insert into s values (7,3,1);
insert into s values (7,2,10);
insert into s values (7,2,9);
insert into s values (7,2,8);
insert into s values (7,2,7);
insert into s values (7,2,6);
insert into s values (7,2,5);
insert into s values (7,2,4);
insert into s values (7,2,3);
insert into s values (7,2,2);
insert into s values (7,2,1);
insert into s values (7,1,10);
insert into s values (7,1,9);
insert into s values (7,1,8);
insert into s values (7,1,7);
insert into s values (7,1,6);
insert into s values (7,1,5);
insert into s values (7,1,4);
insert into s values (7,1,3);
insert into s values (7,1,2);
insert into s values (7,1,1);
insert into s values (6,10,10);
insert into s values (6,10,9);
insert into s values (6,10,8);
insert into s values (6,10,7);
insert into s values (6,10,6);
insert into s values (6,10,5);
insert into s values (6,10,4);
insert into s values (6,10,3);
insert into s values (6,10,2);
insert into s values (6,10,1);
insert into s values (6,9,10);
insert into s values (6,9,9);
insert into s values (6,9,8);
insert into s values (6,9,7);
insert into s values (6,9,6);
insert into s values (6,9,5);
insert into s values (6,9,4);
insert into s values (6,9,3);
insert into s values (6,9,2);
insert into s values (6,9,1);
insert into s values (6,8,10);
insert into s values (6,8,9);
insert into s values (6,8,8);
insert into s values (6,8,7);
insert into s values (6,8,6);
insert into s values (6,8,5);
insert into s values (6,8,4);
insert into s values (6,8,3);
insert into s values (6,8,2);
insert into s values (6,8,1);
insert into s values (6,7,10);
insert into s values (6,7,9);
insert into s values (6,7,8);
insert into s values (6,7,7);
insert into s values (6,7,6);
insert into s values (6,7,5);
insert into s values (6,7,4);
insert into s values (6,7,3);
insert into s values (6,7,2);
insert into s values (6,7,1);
insert into s values (6,6,10);
insert into s values (6,6,9);
insert into s values (6,6,8);
insert into s values (6,6,7);
insert into s values (6,6,6);
insert into s values (6,6,5);
insert into s values (6,6,4);
insert into s values (6,6,3);
insert into s values (6,6,2);
insert into s values (6,6,1);
insert into s values (6,5,10);
insert into s values (6,5,9);
insert into s values (6,5,8);
insert into s values (6,5,7);
insert into s values (6,5,6);
insert into s values (6,5,5);
insert into s values (6,5,4);
insert into s values (6,5,3);
insert into s values (6,5,2);
insert into s values (6,5,1);
insert into s values (6,4,10);
insert into s values (6,4,9);
insert into s values (6,4,8);
insert into s values (6,4,7);
insert into s values (6,4,6);
insert into s values (6,4,5);
insert into s values (6,4,4);
insert into s values (6,4,3);
insert into s values (6,4,2);
insert into s values (6,4,1);
insert into s values (6,3,10);
insert into s values (6,3,9);
insert into s values (6,3,8);
insert into s values (6,3,7);
insert into s values (6,3,6);
insert into s values (6,3,5);
insert into s values (6,3,4);
insert into s values (6,3,3);
insert into s values (6,3,2);
insert into s values (6,3,1);
insert into s values (6,2,10);
insert into s values (6,2,9);
insert into s values (6,2,8);
insert into s values (6,2,7);
insert into s values (6,2,6);
insert into s values (6,2,5);
insert into s values (6,2,4);
insert into s values (6,2,3);
insert into s values (6,2,2);
insert into s values (6,2,1);
insert into s values (6,1,10);
insert into s values (6,1,9);
insert into s values (6,1,8);
insert into s values (6,1,7);
insert into s values (6,1,6);
insert into s values (6,1,5);
insert into s values (6,1,4);
insert into s values (6,1,3);
insert into s values (6,1,2);
insert into s values (6,1,1);
insert into s values (5,10,10);
insert into s values (5,10,9);
insert into s values (5,10,8);
insert into s values (5,10,7);
insert into s values (5,10,6);
insert into s values (5,10,5);
insert into s values (5,10,4);
insert into s values (5,10,3);
insert into s values (5,10,2);
insert into s values (5,10,1);
insert into s values (5,9,10);
insert into s values (5,9,9);
insert into s values (5,9,8);
insert into s values (5,9,7);
insert into s values (5,9,6);
insert into s values (5,9,5);
insert into s values (5,9,4);
insert into s values (5,9,3);
insert into s values (5,9,2);
insert into s values (5,9,1);
insert into s values (5,8,10);
insert into s values (5,8,9);
insert into s values (5,8,8);
insert into s values (5,8,7);
insert into s values (5,8,6);
insert into s values (5,8,5);
insert into s values (5,8,4);
insert into s values (5,8,3);
insert into s values (5,8,2);
insert into s values (5,8,1);
insert into s values (5,7,10);
insert into s values (5,7,9);
insert into s values (5,7,8);
insert into s values (5,7,7);
insert into s values (5,7,6);
insert into s values (5,7,5);
insert into s values (5,7,4);
insert into s values (5,7,3);
insert into s values (5,7,2);
insert into s values (5,7,1);
insert into s values (5,6,10);
insert into s values (5,6,9);
insert into s values (5,6,8);
insert into s values (5,6,7);
insert into s values (5,6,6);
insert into s values (5,6,5);
insert into s values (5,6,4);
insert into s values (5,6,3);
insert into s values (5,6,2);
insert into s values (5,6,1);
insert into s values (5,5,10);
insert into s values (5,5,9);
insert into s values (5,5,8);
insert into s values (5,5,7);
insert into s values (5,5,6);
insert into s values (5,5,5);
insert into s values (5,5,4);
insert into s values (5,5,3);
insert into s values (5,5,2);
insert into s values (5,5,1);
insert into s values (5,4,10);
insert into s values (5,4,9);
insert into s values (5,4,8);
insert into s values (5,4,7);
insert into s values (5,4,6);
insert into s values (5,4,5);
insert into s values (5,4,4);
insert into s values (5,4,3);
insert into s values (5,4,2);
insert into s values (5,4,1);
insert into s values (5,3,10);
insert into s values (5,3,9);
insert into s values (5,3,8);
insert into s values (5,3,7);
insert into s values (5,3,6);
insert into s values (5,3,5);
insert into s values (5,3,4);
insert into s values (5,3,3);
insert into s values (5,3,2);
insert into s values (5,3,1);
insert into s values (5,2,10);
insert into s values (5,2,9);
insert into s values (5,2,8);
insert into s values (5,2,7);
insert into s values (5,2,6);
insert into s values (5,2,5);
insert into s values (5,2,4);
insert into s values (5,2,3);
insert into s values (5,2,2);
insert into s values (5,2,1);
insert into s values (5,1,10);
insert into s values (5,1,9);
insert into s values (5,1,8);
insert into s values (5,1,7);
insert into s values (5,1,6);
insert into s values (5,1,5);
insert into s values (5,1,4);
insert into s values (5,1,3);
insert into s values (5,1,2);
insert into s values (5,1,1);
insert into s values (4,10,10);
insert into s values (4,10,9);
insert into s values (4,10,8);
insert into s values (4,10,7);
insert into s values (4,10,6);
insert into s values (4,10,5);
insert into s values (4,10,4);
insert into s values (4,10,3);
insert into s values (4,10,2);
insert into s values (4,10,1);
insert into s values (4,9,10);
insert into s values (4,9,9);
insert into s values (4,9,8);
insert into s values (4,9,7);
insert into s values (4,9,6);
insert into s values (4,9,5);
insert into s values (4,9,4);
insert into s values (4,9,3);
insert into s values (4,9,2);
insert into s values (4,9,1);
insert into s values (4,8,10);
insert into s values (4,8,9);
insert into s values (4,8,8);
insert into s values (4,8,7);
insert into s values (4,8,6);
insert into s values (4,8,5);
insert into s values (4,8,4);
insert into s values (4,8,3);
insert into s values (4,8,2);
insert into s values (4,8,1);
insert into s values (4,7,10);
insert into s values (4,7,9);
insert into s values (4,7,8);
insert into s values (4,7,7);
insert into s values (4,7,6);
insert into s values (4,7,5);
insert into s values (4,7,4);
insert into s values (4,7,3);
insert into s values (4,7,2);
insert into s values (4,7,1);
insert into s values (4,6,10);
insert into s values (4,6,9);
insert into s values (4,6,8);
insert into s values (4,6,7);
insert into s values (4,6,6);
insert into s values (4,6,5);
insert into s values (4,6,4);
insert into s values (4,6,3);
insert into s values (4,6,2);
insert into s values (4,6,1);
insert into s values (4,5,10);
insert into s values (4,5,9);
insert into s values (4,5,8);
insert into s values (4,5,7);
insert into s values (4,5,6);
insert into s values (4,5,5);
insert into s values (4,5,4);
insert into s values (4,5,3);
insert into s values (4,5,2);
insert into s values (4,5,1);
insert into s values (4,4,10);
insert into s values (4,4,9);
insert into s values (4,4,8);
insert into s values (4,4,7);
insert into s values (4,4,6);
insert into s values (4,4,5);
insert into s values (4,4,4);
insert into s values (4,4,3);
insert into s values (4,4,2);
insert into s values (4,4,1);
insert into s values (4,3,10);
insert into s values (4,3,9);
insert into s values (4,3,8);
insert into s values (4,3,7);
insert into s values (4,3,6);
insert into s values (4,3,5);
insert into s values (4,3,4);
insert into s values (4,3,3);
insert into s values (4,3,2);
insert into s values (4,3,1);
insert into s values (4,2,10);
insert into s values (4,2,9);
insert into s values (4,2,8);
insert into s values (4,2,7);
insert into s values (4,2,6);
insert into s values (4,2,5);
insert into s values (4,2,4);
insert into s values (4,2,3);
insert into s values (4,2,2);
insert into s values (4,2,1);
insert into s values (4,1,10);
insert into s values (4,1,9);
insert into s values (4,1,8);
insert into s values (4,1,7);
insert into s values (4,1,6);
insert into s values (4,1,5);
insert into s values (4,1,4);
insert into s values (4,1,3);
insert into s values (4,1,2);
insert into s values (4,1,1);
insert into s values (3,10,10);
insert into s values (3,10,9);
insert into s values (3,10,8);
insert into s values (3,10,7);
insert into s values (3,10,6);
insert into s values (3,10,5);
insert into s values (3,10,4);
insert into s values (3,10,3);
insert into s values (3,10,2);
insert into s values (3,10,1);
insert into s values (3,9,10);
insert into s values (3,9,9);
insert into s values (3,9,8);
insert into s values (3,9,7);
insert into s values (3,9,6);
insert into s values (3,9,5);
insert into s values (3,9,4);
insert into s values (3,9,3);
insert into s values (3,9,2);
insert into s values (3,9,1);
insert into s values (3,8,10);
insert into s values (3,8,9);
insert into s values (3,8,8);
insert into s values (3,8,7);
insert into s values (3,8,6);
insert into s values (3,8,5);
insert into s values (3,8,4);
insert into s values (3,8,3);
insert into s values (3,8,2);
insert into s values (3,8,1);
insert into s values (3,7,10);
insert into s values (3,7,9);
insert into s values (3,7,8);
insert into s values (3,7,7);
insert into s values (3,7,6);
insert into s values (3,7,5);
insert into s values (3,7,4);
insert into s values (3,7,3);
insert into s values (3,7,2);
insert into s values (3,7,1);
insert into s values (3,6,10);
insert into s values (3,6,9);
insert into s values (3,6,8);
insert into s values (3,6,7);
insert into s values (3,6,6);
insert into s values (3,6,5);
insert into s values (3,6,4);
insert into s values (3,6,3);
insert into s values (3,6,2);
insert into s values (3,6,1);
insert into s values (3,5,10);
insert into s values (3,5,9);
insert into s values (3,5,8);
insert into s values (3,5,7);
insert into s values (3,5,6);
insert into s values (3,5,5);
insert into s values (3,5,4);
insert into s values (3,5,3);
insert into s values (3,5,2);
insert into s values (3,5,1);
insert into s values (3,4,10);
insert into s values (3,4,9);
insert into s values (3,4,8);
insert into s values (3,4,7);
insert into s values (3,4,6);
insert into s values (3,4,5);
insert into s values (3,4,4);
insert into s values (3,4,3);
insert into s values (3,4,2);
insert into s values (3,4,1);
insert into s values (3,3,10);
insert into s values (3,3,9);
insert into s values (3,3,8);
insert into s values (3,3,7);
insert into s values (3,3,6);
insert into s values (3,3,5);
insert into s values (3,3,4);
insert into s values (3,3,3);
insert into s values (3,3,2);
insert into s values (3,3,1);
insert into s values (3,2,10);
insert into s values (3,2,9);
insert into s values (3,2,8);
insert into s values (3,2,7);
insert into s values (3,2,6);
insert into s values (3,2,5);
insert into s values (3,2,4);
insert into s values (3,2,3);
insert into s values (3,2,2);
insert into s values (3,2,1);
insert into s values (3,1,10);
insert into s values (3,1,9);
insert into s values (3,1,8);
insert into s values (3,1,7);
insert into s values (3,1,6);
insert into s values (3,1,5);
insert into s values (3,1,4);
insert into s values (3,1,3);
insert into s values (3,1,2);
insert into s values (3,1,1);
insert into s values (2,10,10);
insert into s values (2,10,9);
insert into s values (2,10,8);
insert into s values (2,10,7);
insert into s values (2,10,6);
insert into s values (2,10,5);
insert into s values (2,10,4);
insert into s values (2,10,3);
insert into s values (2,10,2);
insert into s values (2,10,1);
insert into s values (2,9,10);
insert into s values (2,9,9);
insert into s values (2,9,8);
insert into s values (2,9,7);
insert into s values (2,9,6);
insert into s values (2,9,5);
insert into s values (2,9,4);
insert into s values (2,9,3);
insert into s values (2,9,2);
insert into s values (2,9,1);
insert into s values (2,8,10);
insert into s values (2,8,9);
insert into s values (2,8,8);
insert into s values (2,8,7);
insert into s values (2,8,6);
insert into s values (2,8,5);
insert into s values (2,8,4);
insert into s values (2,8,3);
insert into s values (2,8,2);
insert into s values (2,8,1);
insert into s values (2,7,10);
insert into s values (2,7,9);
insert into s values (2,7,8);
insert into s values (2,7,7);
insert into s values (2,7,6);
insert into s values (2,7,5);
insert into s values (2,7,4);
insert into s values (2,7,3);
insert into s values (2,7,2);
insert into s values (2,7,1);
insert into s values (2,6,10);
insert into s values (2,6,9);
insert into s values (2,6,8);
insert into s values (2,6,7);
insert into s values (2,6,6);
insert into s values (2,6,5);
insert into s values (2,6,4);
insert into s values (2,6,3);
insert into s values (2,6,2);
insert into s values (2,6,1);
insert into s values (2,5,10);
insert into s values (2,5,9);
insert into s values (2,5,8);
insert into s values (2,5,7);
insert into s values (2,5,6);
insert into s values (2,5,5);
insert into s values (2,5,4);
insert into s values (2,5,3);
insert into s values (2,5,2);
insert into s values (2,5,1);
insert into s values (2,4,10);
insert into s values (2,4,9);
insert into s values (2,4,8);
insert into s values (2,4,7);
insert into s values (2,4,6);
insert into s values (2,4,5);
insert into s values (2,4,4);
insert into s values (2,4,3);
insert into s values (2,4,2);
insert into s values (2,4,1);
insert into s values (2,3,10);
insert into s values (2,3,9);
insert into s values (2,3,8);
insert into s values (2,3,7);
insert into s values (2,3,6);
insert into s values (2,3,5);
insert into s values (2,3,4);
insert into s values (2,3,3);
insert into s values (2,3,2);
insert into s values (2,3,1);
insert into s values (2,2,10);
insert into s values (2,2,9);
insert into s values (2,2,8);
insert into s values (2,2,7);
insert into s values (2,2,6);
insert into s values (2,2,5);
insert into s values (2,2,4);
insert into s values (2,2,3);
insert into s values (2,2,2);
insert into s values (2,2,1);
insert into s values (2,1,10);
insert into s values (2,1,9);
insert into s values (2,1,8);
insert into s values (2,1,7);
insert into s values (2,1,6);
insert into s values (2,1,5);
insert into s values (2,1,4);
insert into s values (2,1,3);
insert into s values (2,1,2);
insert into s values (2,1,1);
insert into s values (1,10,10);
insert into s values (1,10,9);
insert into s values (1,10,8);
insert into s values (1,10,7);
insert into s values (1,10,6);
insert into s values (1,10,5);
insert into s values (1,10,4);
insert into s values (1,10,3);
insert into s values (1,10,2);
insert into s values (1,10,1);
insert into s values (1,9,10);
insert into s values (1,9,9);
insert into s values (1,9,8);
insert into s values (1,9,7);
insert into s values (1,9,6);
insert into s values (1,9,5);
insert into s values (1,9,4);
insert into s values (1,9,3);
insert into s values (1,9,2);
insert into s values (1,9,1);
insert into s values (1,8,10);
insert into s values (1,8,9);
insert into s values (1,8,8);
insert into s values (1,8,7);
insert into s values (1,8,6);
insert into s values (1,8,5);
insert into s values (1,8,4);
insert into s values (1,8,3);
insert into s values (1,8,2);
insert into s values (1,8,1);
insert into s values (1,7,10);
insert into s values (1,7,9);
insert into s values (1,7,8);
insert into s values (1,7,7);
insert into s values (1,7,6);
insert into s values (1,7,5);
insert into s values (1,7,4);
insert into s values (1,7,3);
insert into s values (1,7,2);
insert into s values (1,7,1);
insert into s values (1,6,10);
insert into s values (1,6,9);
insert into s values (1,6,8);
insert into s values (1,6,7);
insert into s values (1,6,6);
insert into s values (1,6,5);
insert into s values (1,6,4);
insert into s values (1,6,3);
insert into s values (1,6,2);
insert into s values (1,6,1);
insert into s values (1,5,10);
insert into s values (1,5,9);
insert into s values (1,5,8);
insert into s values (1,5,7);
insert into s values (1,5,6);
insert into s values (1,5,5);
insert into s values (1,5,4);
insert into s values (1,5,3);
insert into s values (1,5,2);
insert into s values (1,5,1);
insert into s values (1,4,10);
insert into s values (1,4,9);
insert into s values (1,4,8);
insert into s values (1,4,7);
insert into s values (1,4,6);
insert into s values (1,4,5);
insert into s values (1,4,4);
insert into s values (1,4,3);
insert into s values (1,4,2);
insert into s values (1,4,1);
insert into s values (1,3,10);
insert into s values (1,3,9);
insert into s values (1,3,8);
insert into s values (1,3,7);
insert into s values (1,3,6);
insert into s values (1,3,5);
insert into s values (1,3,4);
insert into s values (1,3,3);
insert into s values (1,3,2);
insert into s values (1,3,1);
insert into s values (1,2,10);
insert into s values (1,2,9);
insert into s values (1,2,8);
insert into s values (1,2,7);
insert into s values (1,2,6);
insert into s values (1,2,5);
insert into s values (1,2,4);
insert into s values (1,2,3);
insert into s values (1,2,2);
insert into s values (1,2,1);
insert into s values (1,1,10);
insert into s values (1,1,9);
insert into s values (1,1,8);
insert into s values (1,1,7);
insert into s values (1,1,6);
insert into s values (1,1,5);
insert into s values (1,1,4);
insert into s values (1,1,3);
insert into s values (1,1,2);
insert into s values (1,1,1);
drop table if exists t;
create table t like s;
insert into t select * from s;
show create table s;
Table	Create Table
s	CREATE TABLE `s` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL
) ENGINE=TokuDB DEFAULT CHARSET=latin1
show create table t;
Table	Create Table
t	CREATE TABLE `t` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL
) ENGINE=TokuDB DEFAULT CHARSET=latin1
explain select straight_join * from s,t where s.b = t.b;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	NULL	NULL	NULL	NULL	1000	
1	SIMPLE	t	ALL	NULL	NULL	NULL	NULL	1000	Using where; Using join buffer (flat, BNL join)
alter table s add key(b);
alter table t add key(b);
show create table s;
Table	Create Table
s	CREATE TABLE `s` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL,
  KEY `b` (`b`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1
show create table t;
Table	Create Table
t	CREATE TABLE `t` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL,
  KEY `b` (`b`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1
explain select straight_join * from s,t where s.b = t.b;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	b	NULL	NULL	NULL	1000	Using where
1	SIMPLE	t	ref	b	b	5	test.s.b	1	
alter table s add key(b) clustering=yes;
Warnings:
Note	1831	Duplicate index `b_2`. This is deprecated and will be disallowed in a future release
alter table t add key(b) clustering=yes;
Warnings:
Note	1831	Duplicate index `b_2`. This is deprecated and will be disallowed in a future release
show create table s;
Table	Create Table
s	CREATE TABLE `s` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL,
  KEY `b` (`b`),
  KEY `b_2` (`b`) `clustering`=yes
) ENGINE=TokuDB DEFAULT CHARSET=latin1
show create table t;
Table	Create Table
t	CREATE TABLE `t` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL,
  KEY `b` (`b`),
  KEY `b_2` (`b`) `clustering`=yes
) ENGINE=TokuDB DEFAULT CHARSET=latin1
explain select straight_join * from s,t where s.b = t.b;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	index	b,b_2	b_2	5	NULL	1000	Using where; Using index
1	SIMPLE	t	ref	b,b_2	b_2	5	test.s.b	1	Using index
alter table s drop key b;
alter table t drop key b;
show create table s;
Table	Create Table
s	CREATE TABLE `s` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL,
  KEY `b_2` (`b`) `clustering`=yes
) ENGINE=TokuDB DEFAULT CHARSET=latin1
show create table t;
Table	Create Table
t	CREATE TABLE `t` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL,
  KEY `b_2` (`b`) `clustering`=yes
) ENGINE=TokuDB DEFAULT CHARSET=latin1
explain select straight_join * from s,t where s.b = t.b;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	index	b_2	b_2	5	NULL	1000	Using where; Using index
1	SIMPLE	t	ref	b_2	b_2	5	test.s.b	1	Using index
alter table s add key(b);
Warnings:
Note	1831	Duplicate index `b`. This is deprecated and will be disallowed in a future release
alter table t add key(b);
Warnings:
Note	1831	Duplicate index `b`. This is deprecated and will be disallowed in a future release
show create table s;
Table	Create Table
s	CREATE TABLE `s` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL,
  KEY `b_2` (`b`) `clustering`=yes,
  KEY `b` (`b`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1
show create table t;
Table	Create Table
t	CREATE TABLE `t` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  `c` int(11) DEFAULT NULL,
  KEY `b_2` (`b`) `clustering`=yes,
  KEY `b` (`b`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1
explain select straight_join * from s,t where s.b = t.b;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	index	b_2,b	b_2	5	NULL	1000	Using where; Using index
1	SIMPLE	t	ref	b_2,b	b	5	test.s.b	1	
drop table s,t;