diff options
| author | msvensson@neptunus.(none) <> | 2006-03-22 14:57:24 +0100 |
|---|---|---|
| committer | msvensson@neptunus.(none) <> | 2006-03-22 14:57:24 +0100 |
| commit | 451a7129bb728e62dd266d3298cdca081471893a (patch) | |
| tree | 137332f058e9a80490e7af79385026a8cab5b463 /mysql-test/t/fulltext.test | |
| parent | dcceaae8b63641958bab3cdf9ebb161af4c76332 (diff) | |
| download | mariadb-git-451a7129bb728e62dd266d3298cdca081471893a.tar.gz | |
Bug#18071 Result from MATCH() uses too many decimals
- Use FORMAT as a workaround to only output the first 6 decimals of the value returned
from MATCH
- This has been done before
Diffstat (limited to 'mysql-test/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 91033fe2ba9..0f7835e9e7e 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -371,7 +371,7 @@ 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')"; +PREPARE stmt from "SELECT a, FORMAT(MATCH(a) AGAINST('test1 test'),6) FROM t1 WHERE MATCH(a) AGAINST('test1 test')"; EXECUTE stmt; EXECUTE stmt; DEALLOCATE PREPARE stmt; |