diff options
| author | unknown <serg@sergbook.mylan> | 2003-11-08 15:39:10 +0100 |
|---|---|---|
| committer | unknown <serg@sergbook.mylan> | 2003-11-08 15:39:10 +0100 |
| commit | 20da41c5d6c57fc0c951d9187bd17eb074b8386e (patch) | |
| tree | 14af8fbcbef47c7bb042a457818f804b0ccf6d89 /mysql-test/t | |
| parent | a483fd21913bc4a9e1020e0ce836db3bc2eb5891 (diff) | |
| download | mariadb-git-20da41c5d6c57fc0c951d9187bd17eb074b8386e.tar.gz | |
fulltext.test, fulltext.result:
one simple trunc* test
mysql-test/r/fulltext.result:
one simple trunc* test
mysql-test/t/fulltext.test:
one simple trunc* test
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/fulltext.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 387a36f1f52..e2293094258 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -71,6 +71,16 @@ select * from t1; drop table t1; # +# why to scan strings for trunc* +# +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); +select * from t1 where match a against ("+aaa* +bbb1*" in boolean mode); +select * from t1 where match a against ("+aaa* +ccc*" in boolean mode); +drop table t1; + +# # Check bug reported by Matthias Urlichs # |