diff options
| author | svoj@mysql.com/june.mysql.com <> | 2007-07-10 15:37:39 +0500 |
|---|---|---|
| committer | svoj@mysql.com/june.mysql.com <> | 2007-07-10 15:37:39 +0500 |
| commit | 31c8efc812cab281d58aa7f92c29d513761800dd (patch) | |
| tree | a46f1ce2c7f912efbb39743d93d049ff86155188 /mysql-test | |
| parent | c188110565421339455441319ee8b33557f0111e (diff) | |
| download | mariadb-git-31c8efc812cab281d58aa7f92c29d513761800dd.tar.gz | |
BUG#29445 - match ... against () never returns
Part 1:
Do not perform index search for a plus-word with truncation operator
in case there are other plus-words in expression.
Specifically this optimization was enforced for expression like
"+word1 +word2*", but wasn't enforced for expression like
"+word1 word2*".
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/fulltext.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/fulltext.test | 8 |
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index ef8cf304743..6f6760e31bc 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -480,3 +480,9 @@ CREATE TABLE t1(a VARCHAR(2) CHARACTER SET big5 COLLATE big5_chinese_ci, FULLTEXT(a)); INSERT INTO t1 VALUES(0xA3C2); DROP TABLE t1; +CREATE TABLE t1(a VARCHAR(20), FULLTEXT(a)); +INSERT INTO t1 VALUES('Offside'),('City Of God'); +SELECT a FROM t1 WHERE MATCH a AGAINST ('+city of*' IN BOOLEAN MODE); +a +City Of God +DROP TABLE t1; diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 749e54d218a..4e0c65267c4 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -408,4 +408,12 @@ FULLTEXT(a)); INSERT INTO t1 VALUES(0xA3C2); DROP TABLE t1; +# +# BUG#29445 - match ... against () never returns +# +CREATE TABLE t1(a VARCHAR(20), FULLTEXT(a)); +INSERT INTO t1 VALUES('Offside'),('City Of God'); +SELECT a FROM t1 WHERE MATCH a AGAINST ('+city of*' IN BOOLEAN MODE); +DROP TABLE t1; + # End of 4.1 tests |