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 | f3d921c08273123385c4e1db590c3e18d33f9c7a (patch) | |
| tree | 7abd97c35be60ee178f22bb83f63779a77f4ea8c /mysql-test/r/fulltext.result | |
| parent | c27566aec5529beacd7ee27be4433827d8fa1755 (diff) | |
| download | mariadb-git-f3d921c08273123385c4e1db590c3e18d33f9c7a.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.
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index a980c7bfa01..d1edce12cce 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -535,3 +535,11 @@ CREATE TABLE t1(a TEXT); SELECT GROUP_CONCAT(a) AS st FROM t1 HAVING MATCH(st) AGAINST('test' IN BOOLEAN MODE); ERROR HY000: Incorrect arguments to AGAINST DROP TABLE t1; +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); +a +awrd bwrd cwrd +awrd bwrd cwrd +awrd bwrd cwrd +DROP TABLE t1; |