diff options
Diffstat (limited to 'storage/tokudb/mysql-test/suite/tokudb/r/cluster_2968-2.result')
| -rw-r--r-- | storage/tokudb/mysql-test/suite/tokudb/r/cluster_2968-2.result | 1120 |
1 files changed, 0 insertions, 1120 deletions
diff --git a/storage/tokudb/mysql-test/suite/tokudb/r/cluster_2968-2.result b/storage/tokudb/mysql-test/suite/tokudb/r/cluster_2968-2.result deleted file mode 100644 index 5bf8cb42f9b..00000000000 --- a/storage/tokudb/mysql-test/suite/tokudb/r/cluster_2968-2.result +++ /dev/null @@ -1,1120 +0,0 @@ -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 s.a,t.a 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 -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 s.a,t.a 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 -1 SIMPLE t ref b b 5 test.s.b 11 Using where -alter table s add key(b,a); -alter table t add key(b,a); -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`,`a`) -) 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`,`a`) -) ENGINE=TokuDB DEFAULT CHARSET=latin1 -explain select straight_join s.a,t.a 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 10 NULL 1000 Using index -1 SIMPLE t ref b,b_2 b_2 5 test.s.b 11 Using where; Using index -alter table s add clustering key(b); -alter table t add clustering 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`), - KEY `b_2` (`b`,`a`), - CLUSTERING KEY `b_3` (`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`), - KEY `b_2` (`b`,`a`), - CLUSTERING KEY `b_3` (`b`) -) ENGINE=TokuDB DEFAULT CHARSET=latin1 -explain select straight_join s.a,t.a 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_3 b_2 10 NULL 1000 Using index -1 SIMPLE t ref b,b_2,b_3 b_2 5 test.s.b 11 Using where; Using index -alter table s drop key b_2; -alter table t drop key b_2; -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`), - CLUSTERING KEY `b_3` (`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`), - CLUSTERING KEY `b_3` (`b`) -) ENGINE=TokuDB DEFAULT CHARSET=latin1 -explain select straight_join s.a,t.a 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_3 b_3 5 NULL 1000 -1 SIMPLE t ref b,b_3 b_3 5 test.s.b 11 Using where -drop table s,t; |