On Wed, Feb 23, 2011 at 05:56:35PM +0100, Reindl Harald wrote:
> >> mysql-transport.cf:
> >> select transport from
> >> dbma_transports where mydestination like '%s'
> >> or mydestination like '%d'
> >> order by transport desc limit 1;
> >
> > This type of fuzzy "like" query is highly questionable in this context.
> > What's wrong with "="? Why match both "%s" and "%d"? I think you're
> > somewhat confused here, even if it does mostly work.
>
> this is because "dbma_transports" is a view and "dbma_recipient_relay" is for
> sender dependent relay hosts
What's wrong with "mydestination = '%s'"? Why are you using "like '%s'"?
Surely the destination domain is not a wildcard pattern, but is rather
a literal string.
--
Viktor.
