[rt-devel] Likely Bug: Searching Pg Indexed content ignores NOT

[jim.h.berry at frb.gov]

Hi List,

Using rt-4.0.8,  but this applies to earlier releases as well.  If 
searching over Postgres indexed content, RT ignores NOT.  For example, the 
search 

        Content LIKE 'apple' AND Content NOT LIKE 'banana' 
is processed as
        Content LIKE 'apple' AND Content LIKE 'banana' 

A simple check in Tickets.pm to add " !!" to the Postgres search operand 
and a change in SearchBuilder.pm to allow "@@ !!" seems to fix this.  I 
would guess that searches on indexed Oracle and MySQL content would have 
the same problem with NOT,  but I don't know the appropriate fix.

Please let me know if I am missing something.   This negative search might 
be weird on tickets with multiple transactions, but if RT isn't going to 
honor NOT in this situation, then it would be better to abort rather than 
perform a different search.

Thanks
Jim 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-devel/attachments/20121102/5e8a9890/attachment.html>