Mailing List Archive

[DBMail 0001097]: Incorrect SQL generated when CONDSTORE is used
The following issue has been SUBMITTED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=1097
======================================================================
Reported By: mverbert
Assigned To:
======================================================================
Project: DBMail
Issue ID: 1097
Category: IMAP daemon
Reproducibility: always
Severity: major
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 01-Sep-19 18:14 CEST
Last Modified: 01-Sep-19 18:14 CEST
======================================================================
Summary: Incorrect SQL generated when CONDSTORE is used
Description:
The connection from the client (Samsung S10e if it matters) would be "dead"
as the IMAP daemon will
generate a wrong SQL statement. PostgreSQL logs looked like this:

STATEMENT: SELECT message_idnr FROM dbmail_messages m LEFT JOIN
dbmail_physmessage p ON m.physmessage_id=p.id WHERE mailbox_idnr = $1 AND
status IN ($2,$3) AND m.message_idnr IN (306362 (MODSEQ 111102)) AND
p.internal_date > '2019-07-11 00:00:00' ORDER BY message_idnr

I did a quick and dirty patch to remove the ' (MODSEQ %" PRIu64 ")' and it
worked again (whether it's still
RFC compliant is another question...).
======================================================================

Issue History
Date Modified Username Field Change
======================================================================
01-Sep-19 18:14 mverbert New Issue
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@lists.nfg.nl
https://lists.nfg.nl/cgi-bin/mailman/listinfo/dbmail-dev