[rt-devel] Users::WhoHaveRight and Sybase

Dean Kao nouveaux at lightconsulting.com
Sun Jun 29 14:44:09 EDT 2003


The following query has locked up the database for an hour.

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



More information about the Rt-devel mailing list