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

jim.h.berry at frb.gov jim.h.berry at frb.gov
Fri Nov 2 16:43:07 EDT 2012

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 

        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.


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

More information about the rt-devel mailing list