[rt-users] RT Content NOT LIKE search failed

[Sergey Putko]

Hello,

I found some bug with search on my system:
perl-5.14.2_3
rt-4.0.10_1
percona-server-5.5.31.30.3

I use it without sphinx, in RT_SiteConfig.pm: Set(%FullTextSearch, Enable  => 1, Indexed => 0,);

Search like: [Content LIKE 'Intel' AND Status = 'open' AND Queue = 'support']  showed me ticket with ids: 15, 18, 26 
When I need search and not include "Intel" in result: [Content NOT LIKE 'Intel' AND (  Status = 'open' AND Queue = 'support' )] its showed me ticket ids: 10, 11, 12, 13, 15, 17,18,22, 25,26,28,30

So "NOT LIKE" doesn't works . For Subject its works, only with Content I see fails.

Maybe I'm wrong? But I see something error like this in this thread: http://comments.gmane.org/gmane.comp.bug-tracking.request-tracker.devel/6725

Thanks.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4127 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130528/5a9febcc/attachment.bin>