[rt-users] Pg FTS query works, RT search returns 0 results ( was: '.' as delimiter/boundary breaks domain name searches)

[Jeff Blaine]

>> * 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 'foo at domain.com'"

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