On Tuesday, November 29, 2016 3:26 PM, Wietse Venema <wie...@porcupine.org> wrote:
mailing lists: > This is working as documented. As described under "TABLE LOOKUP > ORDER", the transport_map lookup code generates the .example.bar > query after the user@domain and domain queries produce no result. Wietse, you are right I must have messed something during the tests, now it is working perfectly. I also received an answer off-list with an alternative solution which reduces the number of database queries, it uses this query: SELECT rhs FROM transport WHERE lhs='%d' OR lhs LIKE '.%%' AND RIGHT('%d', CHAR_LENGTH(lhs))=lhs thank you all.