MySQL Bugs: #25539: Boolean fulltext query against non-fulltext-indexed column doesn't return error.

Bug #25539	Boolean fulltext query against non-fulltext-indexed column doesn't return error.
Submitted:	11 Jan 2007 7:07	Modified:	11 Jan 2007 9:42
Reporter:	Tetsuro Ikeda	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: FULLTEXT search	Severity:	S3 (Non-critical)
Version:	5.0.27-src	OS:	Linux (Linux (Debian etch))
Assigned to:		CPU Architecture:	Any
Tags:	boolean, fulltext

Description:
Incorrect fulltext boolean search should return error as well as fulltext nlq search.

How to repeat:
[test] > create table t1 (c1 text, c2 text);
Query OK, 0 rows affected (0.01 sec)

[test] > alter table t1 add fulltext index ft1 (c1);
Query OK, 0 rows affected (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 0

[test] > insert into t1 values ("linkers and loaders", "foo bar");
Query OK, 1 row affected (0.08 sec)

[test] > insert into t1 values ("gnu autoconf automake", "foo bar");
Query OK, 1 row affected (0.00 sec)

[test] > insert into t1 values ("mysql community server", "foo bar");
Query OK, 1 row affected (0.00 sec)

[test] > select * from t1 where match(c2) against("foo");
ERROR 1191 (HY000): Can't find FULLTEXT index matching the column list
[test] > select * from t1 where match(c2) against("foo" in boolean mode);
+------------------------+---------+
| c1                     | c2      |
+------------------------+---------+
| linkers and loaders    | foo bar |
| gnu autoconf automake  | foo bar |
| mysql community server | foo bar |
+------------------------+---------+
3 rows in set (0.00 sec)

[test] >

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Below is quote from our manual:

Boolean full-text searches have these characteristics:
    * They can work even without a FULLTEXT index, although a search executed in this fashion would be quite slow.

(From http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html)