| Bug #27399 | use of " do not guaranty that results will have exact phrase | ||
|---|---|---|---|
| Submitted: | 23 Mar 2007 14:08 | Modified: | 20 Jun 2008 12:23 |
| Reporter: | [ name withheld ] | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: FULLTEXT search | Severity: | S3 (Non-critical) |
| Version: | 5.0.38, 5.0.30 | OS: | Linux (debian) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[10 Apr 2007 12:26]
Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.37/5.0.38, and inform about the results.
[29 Apr 2007 19:57]
Roland Tanner
I see the same behaviour in version 5.0.38 (Ubuntu default setup with PHP5)
The query:
SELECT
t.id,
p.path,
b.series,
b.volume,
b.startdate,
b.enddate,
b.file AS ebook,
ip.image AS text_image,
t.text AS text
FROM
text_page t
INNER JOIN images_page ip ON (t.images_page_id = ip.id)
INNER JOIN paths p ON (p.id = ip.path_id)
INNER JOIN books b ON (t.book_id = b.id)
WHERE MATCH
(t.text)
AGAINST
('"an exact complete phrase"' IN BOOLEAN MODE)
AND
t.id = 1
OR
t.id = 4 (etc ...)
The results with boolean and non-boolean seem pretty much identical, and the boolean search returns results which do not contain the exact phrase
[5 Jun 2007 10:03]
Sergey Vojtovich
Hi!
I do not see "IN BOOLEAN MODE" around this query:
SELECT description FROM chem_doc WHERE
MATCH (description) AGAINST ('"1-24-ACTH"')
So it is executed in NLQ, which doesn't support phrase search.
Roland, could you provide complete query that you think works wrong plus attach all tables to a bug report (or at least SHOW CREATE TABLE for all of them)?
Also I'd suggest to try 5.0.40, which includes fix for BUG#25729 (fulltext returns false hits with join).
[5 Jul 2007 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[20 May 2008 12:23]
MySQL Verification Team
Could you please provide a complete test case (dump file with create table, insert data and the result of your query). Thanks in advance.
[20 Jun 2008 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: I have database with descriptions of chemical formulas. On mysql 5.0.30 query SELECT description FROM chem_doc WHERE MATCH (description) AGAINST ('"1-24-ACTH"') returns lines like "ACHT ... blah blah blah ... 1. 24h - 48h ... blah blah blah ..." This mean even i use " , Mysql looks separately for "ACHT", "1" and "24". How to repeat: SELECT description FROM chem_doc WHERE MATCH (description) AGAINST ('"1-24-ACTH"')