v2.3.17 quota-dict related sql errors

[Pascal Volk]

Hi there,

I've updated Dovecot from v2.3.14 (cee3cbc0d) to v2.3.17 (e2aa53df5b).
Right after the update, dovecot begun flooding the mail.log and
PostgreSQL's log.

My dict sql configuration:
,--[ .../dovecot/dovecot-dict-sql.conf.ext ]--
| map {
|   pattern = priv/quota/storage
|   table = userquota
|   username_field = uid
|   value_field = bytes
| }
| map {
|   pattern = priv/quota/messages
|   table = userquota
|   username_field = uid
|   value_field = messages
| }
`--

This worked for decades. Since the update dovecot is passing the user's
email address, instead the user's UID to the query. And therefor I have
lots of errors in the log files: see attached `mail.log' and
`postgresql-14-main.log' excerpts.

The `userquota' table looks like this:

              Table "public.userquota"
  Column  |  Type   | Collation | Nullable | Default
----------+---------+-----------+----------+---------
 uid      | bigint  |           | not null |
 bytes    | bigint  |           | not null | 0
 messages | integer |           | not null | 0
...
Foreign-key constraints:
    "fkey_userquota_uid_users" FOREIGN KEY (uid) REFERENCES users(uid)
ON DELETE CASCADE

(full database structure:
https://bitbucket.org/pvo/vmm/src/vmm-0.7.0/pgsql/create_tables.pgsql)


Regards,
Pascal
-- 
Ubuntu is an ancient African word meaning “I can’t install Debian.”
                                                         -- unknown
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mail.log
Type: text/x-log
Size: 784 bytes
Desc: not available
URL: <https://dovecot.org/pipermail/dovecot/attachments/20211204/8f314886/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgresql-14-main.log
Type: text/x-log
Size: 259 bytes
Desc: not available
URL: <https://dovecot.org/pipermail/dovecot/attachments/20211204/8f314886/attachment-0001.bin>