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?]
Subject
Views
Written By
Posted
Apparent truncation problem - FULLTEXT BOOLEAN MODE
3087
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.