>> * 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].
... > 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. I'm losing what little is left of my mind, apparently. I looked last week at the problem ticket and could swear it had no merging in its history. Looking today, I see it *does*. > perl -MRT=-init -le > '$t=RT::Tickets->new(RT->SystemUser);$t->FromSQL("@ARGV");print > $t->BuildSelectQuery' \ > "Content LIKE '[email protected]'" Handy! Used this to generate the SQL. Pasted the SQL into psql for kicks and got the unfortunately now-expected 0 results. Filed this snippet away for later. Thanks Alex. Jeff
