[exim] Strange sql lookup results

Góra strony
Delete this message
Reply to this message
Autor: Todd Lyons
Data:  
Dla: exim-users
Temat: [exim] Strange sql lookup results
Hi all, I'm running exim 4.69. I have the following query:

AUTORESPONDER_DATA = ${lookup mysql {SELECT
ea.active,ea.frequency,ea.subject,ea.message FROM email_autoresponder
AS ea JOIN email AS e ON e.autoresponder_id=ea.id JOIN domain AS d ON
d.id=e.domain_id WHERE e.name='${quote_mysql:${local_part}}' AND
d.name='${quote_mysql:${domain}}' AND e.active=1 } }

The result of this is:

2010-09-09 02:43:19 DEBUG: active=1 frequency=2 ea=BLAH
email_autoresponder=BOBOBOBOBO

But it _SHOULD_ be:

2010-09-09 02:43:19 DEBUG: active=1 frequency=2 subject=BLAH message=BOBOBOBOBO

Can anybody tell me why "ea" and "email_autoresponder" are the last
two field names instead of "subject" and "message"?

Even weirder, if I remove the "AS ea" part from the initial FROM, then
adjust the query accordingly, the lookup results in:

2010-09-09 02:35:58 DEBUG: active=1 frequency=2
email_autoresponder=BLAH email_autoresponder=BOBOBOBOBO

Which of course cannot work. Is it my choice of field names causing
the problem? "message" and "subject" seem dangerously close to
reserved keywords, so it's plausible to me.
--
Regards...      Todd
I seek the truth...it is only persistence in self-delusion and
ignorance that does harm.  -- Marcus Aurealius