[rt-devel] Users::WhoHaveRight and Sybase

Jesse Vincent jesse at bestpractical.com
Mon Jun 30 02:20:46 EDT 2003



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?

> 
> 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.



More information about the Rt-devel mailing list