[exim] Using MySQL "INSTR" function fails exim-4.62

Top Page
Delete this message
Reply to this message
Author: Matt Judge
Date:  
To: exim-users
Subject: [exim] Using MySQL "INSTR" function fails exim-4.62
Hi,

Can someone check this please. I have never had any problems with MySQL
and Exim up until this point. I have even replaced all the strings with
literals so that it is a valid statement requiring no substitutions at
all - and it still doesn't work.

>>> processing "accept"
>>> check condition = ${if eq{${lookup mysql{SELECT 1 FROM

domain_whitelist WHERE INSTR('test@???', 'google')}}}{1}
{1}{0}}
 >>>                 = 0
 >>> accept: condition test failed


This looks like planned behaviour or a bug.

Kind regards,

Matt.