[exim-dev] [Bug 394] New: expansion of route_list

http://www.exim.org/bugzilla/show_bug.cgi?id=394

           Summary: expansion of route_list
           Product: Exim
           Version: 4.52
          Platform: x86
        OS/Version: Linux
            Status: NEW
          Severity: bug
          Priority: high
         Component: Routing
        AssignedTo: ph10@???
        ReportedBy: ml@???
         QAContact: exim-dev@???

I have to match in a mysql-Statement against ';', but exim gives me a error:

2006-09-21 13:14:15 1GQMVT-0007NW-NG == user@??? R=forward_aliases defer
(-1): forward_aliases router: failed to expand "${lookup mysql {SELECT
U_RemoteAddress FROM Users WHERE U_Type = '4' AND U_Domain =
'${quote_mysql:$domain}' AND U_Alias LIKE '%": missing } at end of string

my route_list is:

route_list = * "${lookup mysql {SELECT U_RemoteAddress FROM Users WHERE U_Type =
'4' AND U_Domain = '${quote_mysql:$domain}' AND U_Alias LIKE
'%;${quote_mysql:$local_part};%'}}"

so I have to use this statement which is very ugly:

route_list = * "${lookup mysql {SELECT U_RemoteAddress FROM Users WHERE U_Type =
'4' AND U_Domain = '${quote_mysql:$domain}' AND U_Alias LIKE CONCAT('%',
CHAR(59), '${quote_mysql:$local_part}', CHAR(59), '%')}}"



------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.