diff options
| author | serg@serg.mylan <> | 2006-02-14 13:19:54 +0100 |
|---|---|---|
| committer | serg@serg.mylan <> | 2006-02-14 13:19:54 +0100 |
| commit | b283fb79d0b20ab5891e0f13b4f3911de9dbb378 (patch) | |
| tree | 9b5fccd0dee8948ca8e2fc3a5dc33fd27cb4c517 /mysql-test/r/fulltext.result | |
| parent | e27d2a58732b07eceea5d11c8536f5b6645d44eb (diff) | |
| download | mariadb-git-b283fb79d0b20ab5891e0f13b4f3911de9dbb378.tar.gz | |
MATCH(a,b) AGAINST (... IN NATURAL LANGUAGE MODE)
remove explicit $<ulong_num>$ from sql_yacc.yy
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 |