From b283fb79d0b20ab5891e0f13b4f3911de9dbb378 Mon Sep 17 00:00:00 2001
From: "serg@serg.mylan" <>
Date: Tue, 14 Feb 2006 13:19:54 +0100
Subject: MATCH(a,b) AGAINST (... IN NATURAL LANGUAGE MODE) remove explicit
$<ulong_num>$ from sql_yacc.yy
---
mysql-test/r/fulltext.result | 9 +++++++++
1 file changed, 9 insertions(+)
(limited to 'mysql-test/r/fulltext.result')
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
--
cgit v1.2.1