Ticket #2810 (closed defect: fixed)

Opened 8 months ago

Last modified 8 months ago

fails when used with report containing LIKE operator

Reported by: anonymous Assigned to: gotoh
Priority: normal Component: TicketBoxMacro
Severity: normal Keywords:
Cc: Trac Release: 0.10

Description

Reports which contain something like the following work in the reports page, but fail with the TicketBox macro:

SELECT id AS ticket, summary FROM ticket

WHERE status IN ('new', 'assigned', 'reopened')

AND (owner='$USER' OR cc LIKE '%$USER%')

I guess that the problem is with the use of the % symbols in the LIKE string?

Attachments

Change History

03/28/08 04:45:44 changed by gotoh

  • status changed from new to closed.
  • resolution set to fixed.

(In [3423]) Fix to use ReportModule.sql_sub_vars() for the issue #2810. Old code is not good for query like "... LIKE '%$USER%'" on 0.10.x or 0.11 on replacing variables. Close #2810.

And also drop supporting for trac 0.8 or before.

03/28/08 04:48:25 changed by gotoh

I'd reproduced your issue and fix it in r3423. Try it please.

Add/Change #2810 (fails when used with report containing LIKE operator)




Change Properties
Action