Subject: | Merge does not occur when the subject contains a blackslash |
Date: | Thu, 3 Oct 2013 14:14:02 +0200 |
To: | bug-RT-Extension-Nagios [...] rt.cpan.org |
From: | Emiliano Ticci <emiticci [...] gmail.com> |
Steps to reproduce:
Open two consecutive tickets with the following subject:
** PROBLEM Service Alert: SERVER/C:\ Operating System is WARNING **
When looking for previous active tickets, the MySQL query that RT executes
is:
SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND ( (
main.Subject LIKE '%Service Alert: SERVER/C: Operating System%' ) AND (
main.Status = 'open' OR main.Status = 'new' OR main.Status = 'stalled' )
AND ( main.Queue = '7' ) ) AND (main.Type = 'ticket') AND
(main.EffectiveId = main.id) ORDER BY main.Created ASC
Instead should be:
SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND ( (
main.Subject LIKE '%Service Alert: SERVER/C:\\\\ Operating System%' ) AND
( main.Status = 'open' OR main.Status = 'new' OR main.Status = 'stalled' )
AND ( main.Queue = '7' ) ) AND (main.Type = 'ticket') AND
(main.EffectiveId = main.id) ORDER BY main.Created ASC
RT 4.0.0
Perl 5.10.0
Linux 2.6.21.7-2.fc8xen
MySQL 5.0.51a