The following issue has been RESOLVED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=285
======================================================================
Reported By: stevo_inco
Assigned To:
======================================================================
Project: DBMail
Issue ID: 285
Category: Database layer
Reproducibility: always
Severity: major
Priority: normal
Status: resolved
Resolution: no change required
Fixed in Version: SVN Trunk
======================================================================
Date Submitted: 28-Nov-05 22:10 CET
Last Modified: 29-Nov-05 09:48 CET
======================================================================
Summary: Double quotes break PostgreSQL query
Description:
My IMAP client fails when I try to check my account (different clients
exhibit different behaviors), and I find a failed SQL query in my logs.
The query is done using double-quotes. At jnorell's recomendation, I ran
the query by hand using single-quotes, and it went through successfully.
My runtime follows:
dbmail=> SELECT headername,headervalue FROM dbmail_headervalue v JOIN
dbmail_headername n ON v.headername_id=n.id WHERE v.physmessage_id=106 AND
n.headername IN
("From","To","Cc","Subject","Date","Message-ID","Priority","X-Priority","References","Newsgroups","In-Reply-To");
ERROR: column "From" does not exist
dbmail=> SELECT headername,headervalue FROM dbmail_headervalue v JOIN
dbmail_headername n ON v.headername_id=n.id WHERE v.physmessage_id=106 AND
n.headername IN
('from','To','Cc','Subject','Date','Message-ID','Priority','X-Priority','References','Newsgroups','In-Reply-To');
headername | headervalue
------------+-------------------------------------------
To | amsn-devel@lists.sourceforge.net
Subject | [Amsn-devel] Updated list of translations
Date | Mon, 28 Nov 2005 21:24:39 +0100
(3 rows)
dbmail=>
======================================================================
----------------------------------------------------------------------
paul - 29-Nov-05 09:48
----------------------------------------------------------------------
This has already been fixed in the trunk for some weeks now. The debian
packages will be upgraded asap (after the breakage from the modular setup
has been fixed).
Issue History
Date Modified Username Field Change
======================================================================
28-Nov-05 22:10 stevo_inco New Issue
28-Nov-05 22:20 stevo_inco Issue Monitored: stevo_inco
29-Nov-05 09:48 paul Note Added: 0000955
29-Nov-05 09:48 paul Status new => resolved
29-Nov-05 09:48 paul Resolution open => no change
required
29-Nov-05 09:48 paul Fixed in Version => SVN Trunk
======================================================================
