EVOLUTION-MANAGER

Edit File: cluster_2968-1.result

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;