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

[Brian Kerr]

On 7/23/07, James Moseley <jmoseley at corp.xanadoo.com> wrote:
> Your problem may have something to do with the following statement issued
> in the 3.6.4 release notes:
>
> "Use 'Watcher = X' inestead of 'Requestor = X OR Cc = X OR AdminCc = X' in
> the SelfService interface. Both queries do quite the same job, but the
> former is significantly faster."
>
> I ran into query problems as well when trying to search via Requestor,
> AdminCc, Cc, etc, after upgrading to 3.6.4.

These queries are being made from the query builder.  There are many
different instances when users would need to search based on an email
address and said email address would not be a Watcher, or a privileged
user for that matter.

This part of the query seems to be the problem:
"FROM Tickets main CROSS JOIN Users Users_3"

Thanks,
Brian