diff options
| author | Sergey Vojtovich <svoj@sun.com> | 2009-04-23 16:24:08 +0500 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@sun.com> | 2009-04-23 16:24:08 +0500 |
| commit | 509a9cee1ca110f6186f25a9cc85889e0918fa13 (patch) | |
| tree | 7abd97c35be60ee178f22bb83f63779a77f4ea8c /mysql-test/t/fulltext.test | |
| parent | e0526914b6acb91f8cf15bd536ad40e226158d1b (diff) | |
| download | mariadb-git-509a9cee1ca110f6186f25a9cc85889e0918fa13.tar.gz | |
BUG#42907 - Multi-term boolean fulltext query containing a
single quote fails in 5.1.x
Performing fulltext prefix search (a word with truncation
operator) may cause a dead-loop.
The problem was in smarter index merge algorithm - it was writing
record reference to an incorrect memory area.
mysql-test/r/fulltext.result:
A test case for BUG#42907.
mysql-test/t/fulltext.test:
A test case for BUG#42907.
storage/myisam/ft_boolean_search.c:
Fixed incorrect memory update by _mi_dpointer() when performing
fulltext prefix search.
Diffstat (limited to 'mysql-test/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 11dbff5ce9a..b565485bab9 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -462,3 +462,12 @@ CREATE TABLE t1(a TEXT); --error ER_WRONG_ARGUMENTS SELECT GROUP_CONCAT(a) AS st FROM t1 HAVING MATCH(st) AGAINST('test' IN BOOLEAN MODE); DROP TABLE t1; + +# +# BUG#42907 - Multi-term boolean fulltext query containing a single +# quote fails in 5.1.x +# +CREATE TABLE t1(a VARCHAR(64), FULLTEXT(a)); +INSERT INTO t1 VALUES('awrd bwrd cwrd'),('awrd bwrd cwrd'),('awrd bwrd cwrd'); +SELECT * FROM t1 WHERE MATCH(a) AGAINST('+awrd bwrd* +cwrd*' IN BOOLEAN MODE); +DROP TABLE t1; |