MySQL Forums
Forum List  »  Full-Text Search

Apparent truncation problem - FULLTEXT BOOLEAN MODE
Posted by: Harry Hege
Date: February 21, 2006 03:03PM

In MySQL 4.0.21 I am experiencing an apparent anomoly when searching FULLTEXT IN BOOLEAN MODE -- intermittently returning zero search results for a parenthesized expression containing a word with a truncation character. See searches 16 & 17 below. What would explain this behavior? Is my syntax unacceptable? Is a fix in the works? Thanks.

Sample Searches (result count):
01. +smith (1228)
02. +missile (9444)
03. +missile* (11265)
04. +jones (619)
05. +rocket (27624)
06. +gobbledygook (0)
07. +smith +missile (159)
08. +smith +missile* (209)
09. +jones +rocket (197)
10. +(+smith +missile) -(+jones +rocket) (159)
11. -(+smith +missile) +(+jones +rocket) (197)
12. (+smith +missile) (+jones +rocket) (356)
13. +(+smith +missile*) -(+jones +rocket) (209)
14. +(+smith +missile*) +(+jones +rocket) (0)
15. -(+smith +missile*) +(+jones +rocket) (197)
16. (+smith +missile*) (+jones +rocket) (197) [Why not 209+197=406?]
17. (+smith +missile*) gobbledygook (0) [Why not 209?]

Options: ReplyQuote


Subject
Views
Written By
Posted
Apparent truncation problem - FULLTEXT BOOLEAN MODE
2952
February 21, 2006 03:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.