[rt-users] Ticket Query causes mysql to spin endlessly

[Jesse Vincent]

On Tue, Nov 15, 2005 at 12:39:51PM -0800, Aaron Nichols wrote:
> On 11/15/05, Vance Vagell <vance.vagell at audiumcorp.com> wrote:
> >  We also have this problem, where searching through the content of tickets
> > causes the session to lock up.  If it is a lengthy search, the browser needs
> > to be closed and the cookies deleted.  If it a short search, it returns
> > results and has no problems.  I have found that specify more search
> > parameters speeds up the search (obviously), and that avoids this problem
> > most of the time.  But there are times when you need a more general search,
> > and then you gamble with locking up the session.
>

It does very much look like the query engine is generating an incorrect
query (sticking the join inside an OR).