tokudb/r/simple_join_tokudb_innodb.result

drop table if exists tab;
drop table if exists tbc;
create table tab (a int, b int) engine=tokudb;
insert into tab values (1,1),(2,1),(2,2),(3,1),(3,2),(3,3);
select * from tab;
a	b
1	1
2	1
2	2
3	1
3	2
3	3
create table tbc (b int, c int) engine=innodb;
insert into tbc values (2,4),(3,9),(3,27),(4,1);
select * from tbc;
b	c
2	4
3	9
3	27
4	1
select a,tab.b,c from tab join tbc on tab.b = tbc.b;
a	b	c
2	2	4
3	2	4
3	3	9
3	3	27
select a,tab.b,tbc.b,c from tab join tbc on tab.b < tbc.b;
a	b	b	c
1	1	2	4
1	1	3	9
1	1	3	27
1	1	4	1
2	1	2	4
2	1	3	9
2	1	3	27
2	1	4	1
2	2	3	9
2	2	3	27
2	2	4	1
3	1	2	4
3	1	3	9
3	1	3	27
3	1	4	1
3	2	3	9
3	2	3	27
3	2	4	1
3	3	4	1
select a,tab.b,tbc.b,c from tab join tbc on tab.b > tbc.b;
a	b	b	c
3	3	2	4
drop table tab;
drop table tbc;