[rt-devel] Users::WhoHaveRight and Sybase

[Dean Kao]

> On Sun, Jun 29, 2003 at 11:44:09AM -0700, Dean Kao wrote:
> > The following query has locked up the database for an hour.
> 
> What database?

Mysql 4.0.12

Dean

> 
> > 
> > Copying to tmp table | SELECT DISTINCT main.* FROM ( ( Tickets main LEFT
> > JOIN TicketCustomFieldValues as TicketCustomFieldValues_1  ON
> > ((TicketCustomFieldValues_1.CustomField = '1')) AND (  main.id =
> > TicketCustomFieldValues_1.Ticket)) LEFT JOIN TicketCustomFieldValues as
> > TicketCustomFieldValues_2  ON  ((TicketCustomFieldValues_2.CustomField =
> > '2')) AND (  main.id = TicketCustomFieldValues_2.Ticket))  WHERE
> > ((main.EffectiveId = main.id)) AND ((main.Type = 'ticket')) AND ( (  (
> > (TicketCustomFieldValues_1.Content LIKE '%%01Components%%') ) OR (
> > (TicketCustomFieldValues_2.Content LIKE '%%023Store23%%') )  ) AND (
> > (main.Status = 'resolved') ) )  ORDER BY main.id ASC LIMIT 50 |
> > 
> > 
> > Dean
> > _______________________________________________
> > rt-devel mailing list
> > rt-devel at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-devel
> > 
> 
> -- 
> http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.