summaryrefslogtreecommitdiff
path: root/mysql-test/suite/parts/r/fulltext.result
blob: 6495c9aa5a11250c8edb2684a8e0db2e85b95a09 (plain)
1
2
3
4
5
6
create table t1 (i int, f1 varchar(512), f2 varchar(512), fulltext (f1)) engine=myisam partition by hash (i);
select * from t1 where match (f1) against ('foo');
i	f1	f2
select * from t1 where match (f2) against ('bar' in boolean mode)  ;
i	f1	f2
drop table t1;