summaryrefslogtreecommitdiff
path: root/mysql-test/t/fulltext.test
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2003-11-20 23:07:31 +0100
committerunknown <serg@serg.mylan>2003-11-20 23:07:31 +0100
commitd54e1be66b5bf5968d433076980337ff72942535 (patch)
tree3fdf48019ab0e996ceb717e74e9320dcf1194ba0 /mysql-test/t/fulltext.test
parent24bdf9560396936bcdb540d785bcaf981b68d457 (diff)
parentb6bbbf0832513e96ae8c476066bf7fd6e1e593a7 (diff)
downloadmariadb-git-d54e1be66b5bf5968d433076980337ff72942535.tar.gz
Merge
mysql-test/r/fulltext.result: SCCS merged mysql-test/t/fulltext.test: SCCS merged
Diffstat (limited to 'mysql-test/t/fulltext.test')
-rw-r--r--mysql-test/t/fulltext.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test
index 69c69794f4f..567fae069a1 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
#