Description:
According to the manual, new boolean operators should be available in MySQL
v. 4.0.
I have found that the + and - operator does not work at all, as the
testcase below shows.
I have used the fulltext search example from the manual as the testcase:
How-To-Repeat:
CREATE TABLE articles (id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),body TEXT, FULLTEXT (title,body));
INSERT INTO articles VALUES
(0,'MySQL Tutorial', 'DBMS stands for DataBase Management ...'),
(0,'How To Use MySQL Efficiently', 'After you went through a ...'),
(0,'Optimising MySQL','In this tutorial we will show how to ...'),
(0,'1001 MySQL Trick','1. Never run mysqld as root. 2. Normalise ...'),
(0,'MySQL vs. YourSQL', 'In the following database comparison we ...'),
(0,'MySQL Security', 'When configured properly, MySQL could be ...');
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database
tutorial');
#Returns 3 rows as expected.
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+database
+tutorial');
#Returns 3 rows - should return 1 row.
#The words "database" and "tutorial" both exists in the first row only.
SELECT * FROM articles WHERE MATCH (title,body) AGAINST
('+database -tutorial');
#Returns 3 rows - should return 2 rows.
Fix:
None.
Synopsis: Boolean operators doesnt work.
Submitter-Id: ?
Originator: Lars Lautrup
Organization: 3L-Data
MySQL support: none
Severity: Non-critical
Priority: medium
Category: mysqld
Class: sw-bug
Release: mysql-4.0.1
Exectutable: mysqld-nt
Environment: AMD Thunderbird 1Ghz - 512MB RAM
System: Win2000 Server
Compiler: None used.
Architecture: i
Regards,
Lars Lautrup.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
