1# simple join tokudb and innodb 2--source include/have_innodb.inc 3--source include/have_tokudb.inc 4 5--disable_warnings 6drop table if exists tab; 7drop table if exists tbc; 8--enable_warnings 9 10create table tab (a int, b int) engine=tokudb; 11insert into tab values (1,1),(2,1),(2,2),(3,1),(3,2),(3,3); 12select * from tab; 13 14create table tbc (b int, c int) engine=innodb; 15insert into tbc values (2,4),(3,9),(3,27),(4,1); 16select * from tbc; 17 18select a,tab.b,c from tab join tbc on tab.b = tbc.b; 19 20select a,tab.b,tbc.b,c from tab join tbc on tab.b < tbc.b; 21 22select a,tab.b,tbc.b,c from tab join tbc on tab.b > tbc.b; 23 24 25drop table tab; 26drop table tbc; 27 28