On Fri, Jul 8, 2005, ""Igor Olemskoi"" <[EMAIL PROTECTED]> said:
>> Igor, the query we use in the code now is:
>> SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) =
>> lower('[EMAIL PROTECTED]') AND lower(alias) <> lower(deliver_to)
>> What output do you get for:
>> SELECT alias, deliver_to FROM dbmail_aliases WHERE
>> lower(alias) = lower('[EMAIL PROTECTED]')
>
> Current database: dbmail
>
> mysql> SELECT alias, deliver_to FROM dbmail_aliases WHERE
> -> lower(alias) = lower('[EMAIL PROTECTED]')
> -> ;
> Empty set (0.00 sec)
>
> mysql> SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) =
> -> lower('[EMAIL PROTECTED]') AND lower(alias) <>
> lower(deliver_to);
> Empty set (0.00 sec)
So what's the problem again? This address has neither an alias nor a
username; hence no deliveries go to it. Did I miss something?
Aaron