diff options
| author | svoj@april.(none) <> | 2006-02-01 20:40:12 +0400 |
|---|---|---|
| committer | svoj@april.(none) <> | 2006-02-01 20:40:12 +0400 |
| commit | 332be5bdd9ab556d612a6a4a1b276f9546ebab90 (patch) | |
| tree | afae1d95f63cfb2e9e71573b6f7637dc81e94991 /mysql-test/r/fulltext.result | |
| parent | 04d6b7fa5435e7f4ea6843f0863ba060d054c64f (diff) | |
| download | mariadb-git-332be5bdd9ab556d612a6a4a1b276f9546ebab90.tar.gz | |
BUG#14496: Crash or strange results with prepared statement,
MATCH and FULLTEXT
Fixed that fulltext query using PS results in unexpected behaviour
when executed 2 or more times.
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index ebd6880a10e..c1dd5f80d5c 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -436,3 +436,14 @@ SELECT a FROM t1 WHERE MATCH a AGAINST('testword\'\'' IN BOOLEAN MODE); a testword'' DROP TABLE t1; +CREATE TABLE t1 (a TEXT, FULLTEXT KEY(a)); +INSERT INTO t1 VALUES('test'),('test1'),('test'); +PREPARE stmt from "SELECT a, MATCH(a) AGAINST('test1 test') FROM t1 WHERE MATCH(a) AGAINST('test1 test')"; +EXECUTE stmt; +a MATCH(a) AGAINST('test1 test') +test1 0.68526661396027 +EXECUTE stmt; +a MATCH(a) AGAINST('test1 test') +test1 0.68526661396027 +DEALLOCATE PREPARE stmt; +DROP TABLE t1; |