Am 23.02.2011 18:16, schrieb Victor Duchovni: > 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.
Example: %s = t...@domain.tld mydestination = t...@domain.tld where mydestination='%s' will fail because it is case-sensitive where mydestination like '%s' does the same an is case-in-sensitive
signature.asc
Description: OpenPGP digital signature
