[rt-users] Searching merged tickets yields missing results

[Jesse Vincent]

On Wed, Dec 31, 2003 at 12:47:58PM -0500, Ben Goodwin wrote:
> This is definitely a bug.. I'm hoping someone can help narrow down where/how to fix it.  I have three tickets in question.  1269, 1270, and 1271.  1269 and 1270 have been merged.  1271 talks about 1269 and 1270.  The original content of 1269 was simply 'testcandidate1' and 1270 was 'testcandidate2'.  If I search for content like 'testcandidate2' I get no results.  I opened 1271 for myself to resolve this bug which contains 'testcandidate2' in it as well, so searches now show just ticket 1271.  The problem is that the SQL string is limiting to tickets.id = tickets.effectiveid, which will strip out all merged tickets.  d'oh!  

Merged tickets should never show up in search results, only the tickets
that they were merged into. does 1269 not have its id == its
EffectiveId?

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.