On 7/23/07, Brian Kerr <[EMAIL PROTECTED]> 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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com