From: James Cloos <cloos@jhcloos.com>
To: 4358@emacsbugs.donarmstrong.com
Subject: bug#4358: 23.1.50; Arithmetic overflow errors break imap
Date: Wed, 09 Sep 2009 10:34:43 -0400 [thread overview]
Message-ID: <m3ws48uqxw.fsf@lugabout.jhcloos.org> (raw)
In-Reply-To: <m3k509w2v5.fsf@lugabout.jhcloos.org> (James Cloos's message of "Tue, 08 Sep 2009 17:19:34 -0400")
Having patched the bug in the imapd¹ is use, imap.el no longer errors
out for me.
As such, fixing the imap.el bug is no longer critical for me.
I hope, however, that the bug can remain open, unless there is already
a big integer bug open for gnus with which this can merge.
1] The imapd uses a sql db to store the mail; it implements the imap
status command by doing a union query to get the number of messages
in the specified folder, how many are seen, etc. It then does an
unseen = exists - seen, using unsigned integers, to get the unseen
count. It also made an invalid assumption about how the query
result set would be ordered; it assumed that, in the absence of an
explicit order by clause, the results would be implicitly ordered
by the first column, as if order by 1 had been specified.
That happened to work with mysql and earlier version of postgres,
but does not happen with postgresql 8.4. Adding an explicit
order by 1 to the query fixed that imapd bug.
-JimC
--
James Cloos <cloos@jhcloos.com> OpenPGP: 1024D/ED7DAEA6
next prev parent reply other threads:[~2009-09-09 14:34 UTC|newest]
Thread overview: 6+ messages / expand[flat|nested] mbox.gz Atom feed top
2009-09-06 13:47 bug#4358: 23.1.50; Arithmetic overflow errors break imap James Cloos
2009-09-08 20:31 ` Stefan Monnier
2009-09-08 21:19 ` James Cloos
2009-09-09 14:34 ` James Cloos [this message]
2009-09-09 15:06 ` Stefan Monnier
2009-09-09 17:42 ` James Cloos
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=m3ws48uqxw.fsf@lugabout.jhcloos.org \
--to=cloos@jhcloos.com \
--cc=4358@emacsbugs.donarmstrong.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.