On Mon, Aug 31, 2015 at 09:39:19AM -0400, Jeff Blaine wrote: > I'm reviving this one time in case anyone has further ideas. > > * PostgreSQL 8.4.20 (RHEL 6.6) with FTS does the right > thing when parsing an email address[1] > > * An RT 4.2.12 search for the same string returns 0 results[2]. > I'm 98% certain the ticket *is* indexed though as other queries > return it[2]. > > * The rt-fulltext-indexer script runs every 10 minutes and has > no errors.
Is the ticket in question a merged ticket? You had a mail from the same timeframe which dealt with merged ticket FTS, which is a known bug: https://issues.bestpractical.com/Ticket/Display.html?id=9370 Sadly, there's not good solution to that bug at this time. Otherwise, seeing the query RT is generating, and stripping clauses out of it until it matches, is likely your best bet. You can see the SQL generated from a TicketSQL query by running: perl -MRT=-init -le '$t=RT::Tickets->new(RT->SystemUser);$t->FromSQL("@ARGV");print $t->BuildSelectQuery' \ "Content LIKE '[email protected]'" - Alex
