diff options
| author | unknown <dean@mysql.com> | 2005-02-16 17:35:00 -0600 |
|---|---|---|
| committer | unknown <dean@mysql.com> | 2005-02-16 17:35:00 -0600 |
| commit | 6bb46afb5d6f2171e8eec7691c0349b2eeff70d0 (patch) | |
| tree | 0619d5ed4fae59f365eaa45b8576979f77bf3797 /mysql-test/r/fulltext.result | |
| parent | 8cf5a1cccb91d2c6a7993f0af6c75442b7fef7bf (diff) | |
| parent | d8b0113653f3e6468ae46e5952d8bd5d82bcff74 (diff) | |
| download | mariadb-git-6bb46afb5d6f2171e8eec7691c0349b2eeff70d0.tar.gz | |
Merge mysql.com:/home/dellis/bkl/bug-4.1
into mysql.com:/home/dellis/bkl/bug-5.0
BitKeeper/etc/logging_ok:
auto-union
mysql-test/r/fulltext.result:
Auto merged
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 77325c4e88b..d9ef306d9f6 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -402,6 +402,12 @@ select count(*) from t1; count(*) 1 drop table t1; +CREATE TABLE t1 ( a TEXT, FULLTEXT (a) ); +INSERT INTO t1 VALUES ('testing ft_nlq_find_relevance'); +SELECT MATCH(a) AGAINST ('nosuchword') FROM t1; +MATCH(a) AGAINST ('nosuchword') +0 +DROP TABLE t1; create table t1 (a int primary key, b text, fulltext(b)); create table t2 (a int, b text); insert t1 values (1, "aaaa"), (2, "bbbb"); |