[rt-users] Re: query problem after 3.4.5 -> 3.6.4 upgrade

[Brian Kerr]

On 7/23/07, Brian Kerr <kerrboy at gmail.com> wrote:
> Hi,
>
> This ticket system has been upgraded from 2.0.12 -> 3.4.5 -> 3.6.4.
> Mysql 4.1.22, Centos 4.4, apache 2.0.52, mod_fastcgi.
>
> When doing a search by requestor/owner email address now, we are
> getting a nasty query produced.  Here are the details of the query.
> Let me know if you need any more information.

Requestor.EmailAddress LIKE 'tom' OR Owner = 'tom'

Forming this query in the query builder will create the nasty SQL.  It
renders the RT instance unusable and all subsequent queries stack up.

-Brian