From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: James Cloos Newsgroups: gmane.emacs.bugs Subject: bug#4358: 23.1.50; Arithmetic overflow errors break imap Date: Wed, 09 Sep 2009 10:34:43 -0400 Message-ID: References: Reply-To: James Cloos , 4358@emacsbugs.donarmstrong.com NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: ger.gmane.org 1252510231 31454 80.91.229.12 (9 Sep 2009 15:30:31 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Wed, 9 Sep 2009 15:30:31 +0000 (UTC) To: 4358@emacsbugs.donarmstrong.com Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Wed Sep 09 17:30:24 2009 Return-path: Envelope-to: geb-bug-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1MlP7n-0003tZ-LO for geb-bug-gnu-emacs@m.gmane.org; Wed, 09 Sep 2009 17:30:23 +0200 Original-Received: from localhost ([127.0.0.1]:33715 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MlP7n-0002Yd-04 for geb-bug-gnu-emacs@m.gmane.org; Wed, 09 Sep 2009 11:30:23 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MlOlS-00012t-1c for bug-gnu-emacs@gnu.org; Wed, 09 Sep 2009 11:07:18 -0400 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MlOlF-0000wm-M4 for bug-gnu-emacs@gnu.org; Wed, 09 Sep 2009 11:07:09 -0400 Original-Received: from [199.232.76.173] (port=47714 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MlOlF-0000wb-Fx for bug-gnu-emacs@gnu.org; Wed, 09 Sep 2009 11:07:05 -0400 Original-Received: from rzlab.ucr.edu ([138.23.92.77]:39383) by monty-python.gnu.org with esmtps (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1MlOlE-0000Nc-Qm for bug-gnu-emacs@gnu.org; Wed, 09 Sep 2009 11:07:05 -0400 Original-Received: from rzlab.ucr.edu (rzlab.ucr.edu [127.0.0.1]) by rzlab.ucr.edu (8.14.3/8.14.3/Debian-5) with ESMTP id n89F6xr0012766; Wed, 9 Sep 2009 08:07:02 -0700 Original-Received: (from debbugs@localhost) by rzlab.ucr.edu (8.14.3/8.14.3/Submit) id n89Eo8tY009201; Wed, 9 Sep 2009 07:50:08 -0700 Resent-Date: Wed, 9 Sep 2009 07:50:08 -0700 X-Loop: owner@emacsbugs.donarmstrong.com Resent-From: James Cloos Resent-To: bug-submit-list@donarmstrong.com Resent-CC: Emacs Bugs 2Resent-Date: Wed, 09 Sep 2009 14:50:07 +0000 Resent-Message-ID: Resent-Sender: owner@emacsbugs.donarmstrong.com X-Emacs-PR-Message: followup 4358 X-Emacs-PR-Package: emacs X-Emacs-PR-Keywords: Original-Received: via spool by 4358-submit@emacsbugs.donarmstrong.com id=B4358.12525072757900 (code B ref 4358); Wed, 09 Sep 2009 14:50:07 +0000 Original-Received: (at 4358) by emacsbugs.donarmstrong.com; 9 Sep 2009 14:41:15 +0000 X-Spam-Bayes: score:0.5 Bayes not run. spammytokens:Tokens not available. hammytokens:Tokens not available. Original-Received: from eagle.jhcloos.com (eagle.jhcloos.com [207.210.242.212]) by rzlab.ucr.edu (8.14.3/8.14.3/Debian-5) with ESMTP id n89EfDYn007892 for <4358@emacsbugs.donarmstrong.com>; Wed, 9 Sep 2009 07:41:14 -0700 Original-Received: by eagle.jhcloos.com (Postfix, from userid 10) id D9EB640159; Wed, 9 Sep 2009 14:40:48 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jhcloos.com; s=eagle; t=1252507272; bh=lK/GCgUuImCmqIXSpaBl+Xo8fjMtgaglWYYdpjbl1N8=; h=From:To:Cc:Subject:In-Reply-To:References:Date:Message-ID: MIME-Version:Content-Type:Content-Transfer-Encoding; b=DO4T7GqOIxjWMbfl4c5PX108gy/UiThOM5LfNzgyekhs6mK/rZHrmU2nILV0XO8aS tqN1bAm3EMHGxmbi5MKBsEGnNSN4mxNLLdpTCOZ1gqMJsQ/Fz9dpfL0yQZ8S3YbSmx nH6g5CGH703VySpq/oCSGOgUnqQw49Y+4Zx4rXio= Original-Received: by lugabout.jhcloos.org (Postfix, from userid 500) id E987188614; Wed, 9 Sep 2009 14:35:09 +0000 (UTC) In-Reply-To: (James Cloos's message of "Tue, 08 Sep 2009 17:19:34 -0400") User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/23.1.50 (gnu/linux) Face: iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAI1J REFUOE+lU9ESgCAIg64P1y+ngUdxhl5H8wFbbM0OmUiEhKkCYaZThXCo6KE5sCbA1DDX3genvO4d eBQgEMaM5qy6uWk4SfBYfdu9jvBN9nSVDOKRtwb+I3epboOsOX5pZbJNsBJFvmQQ05YMfieIBnYX FK2N6dOawd97r/e8RjkTLzmMsiVgrAoEugtviCM3v2WzjgAAAABJRU5ErkJggg== Copyright: Copyright 2009 James Cloos OpenPGP: ED7DAEA6; url=http://jhcloos.com/public_key/0xED7DAEA6.asc OpenPGP-Fingerprint: E9E9 F828 61A4 6EA9 0F2B 63E7 997A 9F17 ED7D AEA6 Original-Lines: 25 X-MIME-Autoconverted: from 8bit to quoted-printable by rzlab.ucr.edu id n89F6xr0012766 X-detected-operating-system: by monty-python.gnu.org: GNU/Linux 2.6 (newer, 2) Resent-Date: Wed, 09 Sep 2009 11:07:09 -0400 X-BeenThere: bug-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: "Bug reports for GNU Emacs, the Swiss army knife of text editors" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Errors-To: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.bugs:30891 Archived-At: Having patched the bug in the imapd=B9 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 =3D 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 --=20 James Cloos OpenPGP: 1024D/ED7DAEA6