[rt-users] ticket content search maybe doesn't work as excepted

[Christian Loos]

Hi,

playing around with the ticket content search I discovered many "false
positive" results.

The _TransContentLimit [1] fetches all transaction, notably also the
EmailRecord and CommentEmailRecord transactions which let the content
search also found matches for stings which are inserted by templates
into outgoing emails.

This isn't what I would expect. If I search for content I would expect
matches for the content of Create, Comment, Correspond, Forward Ticket
and Forward Transaction (the content of an incoming email or the content
of an RT user input).

Example (vanilla RT 4.2.11 with unindexed search [2] enabled):
* create a ticket with subject foo and content bar
* search for: Content LIKE 'Greetings'

I wouldn't expect a result here. But the 'Greetings' matches the one
from default 'HTML Autoresponse template' template [3].


Chris

[1]
https://github.com/bestpractical/rt/blob/stable/lib/RT/Tickets.pm#L828-997
[2]
https://bestpractical.com/docs/rt/4.2/full_text_indexing.html#UNINDEXED-SEARCH
[3] https://github.com/bestpractical/rt/blob/stable/etc/initialdata#L260-285