dovecot - Nov 2011 - Quota BUG ?

Hello list,
I believe I found a bug with quota.
The dovecot quota replies with incorrect values when the mailbox is above 2GB.

du -ks returns 2005764bytes

dovecot IMAP on the same user/directory:
1 getquotaroot inbox
* QUOTAROOT "INBOX" "user"
* QUOTA "user" (STORAGE 1096 2000000)* QUOTAROOT "INBOX"
"user"
* QUOTA "user" (STORAGE 1096 2000000)
1 OK Getquotaroot completed.

Is there any way to fix this ?

---
linux system:
dovecot 1.2.15-7
linux 2.6.32-5-amd64

dovecot.conf:
dict {
   quotadict= mysql:/etc/dovecot/dovecot-dict-quota.conf
}
plugin {
  quota = dict:user::proxy::quotadict
}

dovecot-dict-quota.conf :
user_query = SELECT '/home/%d/%n' as home, 'maildir:/home/%d/%n'
as
mail, 150 AS uid, 8 AS gid, CONCAT('*:bytes=', CAST(quota AS CHAR)) AS
quota_rule FROM mailbox WHERE username = '%u' AND active = '1'

On Wed, 2011-11-09 at 14:59 +0200, Adrian M wrote:
> Hello list,
> I believe I found a bug with quota.
> The dovecot quota replies with incorrect values when the mailbox is above
2GB.
> 
> du -ks returns 2005764bytes
> 
> dovecot IMAP on the same user/directory:
> 1 getquotaroot inbox
> * QUOTAROOT "INBOX" "user"
> * QUOTA "user" (STORAGE 1096 2000000)* QUOTAROOT
"INBOX" "user"
> * QUOTA "user" (STORAGE 1096 2000000)
> 1 OK Getquotaroot completed.
So it wraps.
> dovecot.conf:
> dict {
>    quotadict= mysql:/etc/dovecot/dovecot-dict-quota.conf
> }
> plugin {
>   quota = dict:user::proxy::quotadict
> }
> 
> dovecot-dict-quota.conf :
> user_query = SELECT '/home/%d/%n' as home,
'maildir:/home/%d/%n' as
> mail, 150 AS uid, 8 AS gid, CONCAT('*:bytes=', CAST(quota AS CHAR))
AS
> quota_rule FROM mailbox WHERE username = '%u' AND active =
'1'
This is dovecot-sql.conf, not dovecot-dict-quota.conf (or alternatively
you've named them in a "wrong" way).

Anyway, here's a guess: the quota is stored in mysql in "integer",
which
has a maximum value of 2 GB. Actually looks like Dovecot wiki pages also
use "integer". Replace that with "bigint" and recalculate
quota and it
should work.