[rt-users] Full text search problem on sphinx v4.0.4

[Kevin Falcone]

On Wed, Feb 01, 2012 at 01:32:30PM +0900, Toru wrote:
> I am testing rt v4.0.4 with mysql(compiled with sphinx capability) and having 
> some trouble in full text searching. 
> 
> Here are some sample search queries from rt.
> 
> 
> - Case1: full text search ok with returning right results.
> 
> ------------------------------------------------------------------------------
> ( Content LIKE 'aaaa' ) AND ( Status = 'new' OR Status = 'open' OR Status = 'stalled' )
> 
> ( Content LIKE 'aaaa' OR  Content LIKE 'bbbb') AND ( Status = 'new' OR Status = 'open' OR Status = 'stalled' )
> ------------------------------------------------------------------------------
> 
> - Case2: full text search  "not" ok returning no results and  rt seems  not sending any search query through sphinx.(no result log in sphinx's query.log)
> 
> ------------------------------------------------------------------------------
> ( Content LIKE 'aaaa' AND Content LIKE 'bbbb' ) AND ( Status = 'new' OR Status = 'open' OR Status = 'stalled' )
> ------------------------------------------------------------------------------
> 
> 
> I checked both search queries without fulltext configuration and Case1 and 2 both seems returning ok result.
> 
> 
> My v4.0.4 environment is as follow,
> 
> - rt   v4.0.4
> - perl v5.14.2
> - mysql v5.1.61
> - sphinx 2.0.3
> 
> My configurations (sphinx.conf and RT_SiteConfig.pm) are almost default setting and I haven't done any customization of rt codes.

I've bounced this into the bugtracker as
http://issues.bestpractical.com/Ticket/Display.html?id=19357
to see if we can replicate.  Thanks

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120201/20e7a45e/attachment.sig>