> On 05-21-2022 11:46 am, Benny Pedersen wrote: > On 2022-05-21 17:23, post...@ptld.com wrote: >>> On 05-21-2022 10:30 am, Wietse Venema wrote: >>> Doesn't mysql support case-insensitive lookup? >> >> Yes, and I am not experiencing an issue with postfix lookups. >> >> My goal is to have postfix deliver to LMTP lowercase recipient >> addresses to overcome a dovecot shortcoming (delimited forwarding to >> special folders) that dovecot doesn't appear interested in fixing. > > change %u in dovecot maps to %Lu solves it, but it fails imho in postfix not > have it supported in mysql maps, see my other mail? > > in postfix it could be solved via patch that accept case-sensitive-query to > be mapped to always-lowercase results
This is in relation to dovecot's lmtp_save_to_detail_mailbox function. I do not see where %u or %Lu comes into play. There is no issue with postfix or dovecot accepting the mail, all of the lookups are case-insensitive. The problem is dovecot does case-sensitive matching of recipient user to folder name. user+foo...@example.com would be sorted into the folder "foobar" by LMTP. But user+foo...@example.com would report folder "FOOBAR" not found.
