diff options
| author | serg@sergbook.mylan <> | 2003-11-08 15:39:10 +0100 |
|---|---|---|
| committer | serg@sergbook.mylan <> | 2003-11-08 15:39:10 +0100 |
| commit | 05b3ff393ffed1d69e6ef7e5258d33280587c064 (patch) | |
| tree | 14af8fbcbef47c7bb042a457818f804b0ccf6d89 /mysql-test/r/fulltext.result | |
| parent | 76ff0478195ef348cd71144fde5d6737306d12d3 (diff) | |
| download | mariadb-git-05b3ff393ffed1d69e6ef7e5258d33280587c064.tar.gz | |
fulltext.test, fulltext.result:
one simple trunc* test
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 737390865f1..8f1f90e9f76 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -134,6 +134,20 @@ Only MyISAM tables support collections Function MATCH ... AGAINST() is used to do a search some test foobar implements vector space model drop table t1; +create table t1 (a varchar(200) not null, fulltext (a)); +insert t1 values ("aaa10 bbb20"), ("aaa20 bbb15"), ("aaa30 bbb10"); +select * from t1 where match a against ("+aaa* +bbb*" in boolean mode); +a +aaa10 bbb20 +aaa20 bbb15 +aaa30 bbb10 +select * from t1 where match a against ("+aaa* +bbb1*" in boolean mode); +a +aaa20 bbb15 +aaa30 bbb10 +select * from t1 where match a against ("+aaa* +ccc*" in boolean mode); +a +drop table t1; CREATE TABLE t1 ( id int(11), ticket int(11), |