diff options
| author | unknown <serg@serg.mylan> | 2006-02-14 13:19:54 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2006-02-14 13:19:54 +0100 |
| commit | 4f4f20d4e096e1bd492e015946e9c2bd90e53252 (patch) | |
| tree | 9b5fccd0dee8948ca8e2fc3a5dc33fd27cb4c517 /mysql-test/r/fulltext.result | |
| parent | 3649a68fab9132828125e9b1107cfc7fb4201699 (diff) | |
| download | mariadb-git-4f4f20d4e096e1bd492e015946e9c2bd90e53252.tar.gz | |
MATCH(a,b) AGAINST (... IN NATURAL LANGUAGE MODE)
remove explicit $<ulong_num>$ from sql_yacc.yy
mysql-test/r/fulltext.result:
MATCH(a,b) AGAINST (... IN NATURAL LANGUAGE MODE)
mysql-test/t/fulltext.test:
MATCH(a,b) AGAINST (... IN NATURAL LANGUAGE MODE)
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index b5084fff165..ff66e9a7274 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -41,6 +41,15 @@ a b Full-text indexes are called collections Only MyISAM tables support collections MySQL has now support for full-text search +select * from t1 where MATCH(a,b) AGAINST ("indexes" IN NATURAL LANGUAGE MODE); +a b +Full-text indexes are called collections +select * from t1 where MATCH(a,b) AGAINST ("indexes" IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION); +a b +Full-text indexes are called collections +Only MyISAM tables support collections +select * from t1 where MATCH(a,b) AGAINST ("indexes" IN BOOLEAN MODE WITH QUERY EXPANSION); +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WITH QUERY EXPANSION)' at line 1 explain select * from t1 where MATCH(a,b) AGAINST ("collections"); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 fulltext a a 0 1 Using where |