The issue 0000883 has been set as DUPLICATE OF the following issue. ====================================================================== http://dbmail.org/mantis/view.php?id=827 ====================================================================== Reported By: variable Assigned To: ====================================================================== Project: DBMail Issue ID: 827 Category: IMAP daemon Reproducibility: always Severity: major Priority: normal Status: resolved target: Resolution: fixed Fixed in Version: 2.2.14 ====================================================================== Date Submitted: 05-Jan-10 00:47 CET Last Modified: 05-Jan-10 20:31 CET ====================================================================== Summary: postgresql-8.4.2 Strangeness Description: I switched to PostgreSQL 8.4.2 but it looks like the error is somehow in dbmail if I am reading this query correctly.
SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=1 AND (status < 2) UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=1 AND (status < 2) AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=1 AND (status < 2) AND recent_flag=1 'a' is TOTAL, 'b' is SEEN, 'c' is RECENT 'c' seems to be fine. However I am getting messages back like: * STATUS "INBOX" (MESSAGES 529 UNSEEN 4294967195 RECENT 0) UNSEEN seems to be equal to: 2^32 - (a-b) After really analyzing this, it appears that in some cases the postgresql server returns: ?column? count b => 31 a => 42 c => 0 and in others: ?column? count a => 42 b => 31 c => 0 Yes they are the exact same thing, but for whatever reason dbmail-imapd is not seeing them as the same thing, I am hoping you all can enlighten me on that whatever? Any ideas? I am wondering if anyone else is running 8.4.2 and seeing these issues? ====================================================================== Relationships ID Summary ---------------------------------------------------------------------- has duplicate 0000883 IMAP returning incorrect EXISTS after u... ====================================================================== ---------------------------------------------------------------------- (0002973) paul (administrator) - 05-Jan-10 20:28 http://dbmail.org/mantis/view.php?id=827#c2973 ---------------------------------------------------------------------- This was fixed by James Cloos back in september on the master branch. I've backported his fix. Issue History Date Modified Username Field Change ====================================================================== 05-Jan-10 00:47 variable New Issue 05-Jan-10 20:28 paul Note Added: 0002973 05-Jan-10 20:31 paul Status new => resolved 05-Jan-10 20:31 paul Resolution open => fixed 05-Jan-10 20:31 paul Fixed in Version => 2.2.14 23-Feb-11 16:13 paul Relationship added has duplicate 0000883 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
