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 '' ) AND ( Status = 'new' OR Status = 'open' OR Status =
> 'stalled' )
>
> ( Content LIKE '' OR Content LIKE '') 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 '' AND Content LIKE '' ) 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
pgpf5d3xIW2du.pgp
Description: PGP signature
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012