Should I create a bug report for this? Anyone able to reproduce it on their systems?
On Montag 09 Februar 2009 Michael Monnerie wrote: > In Kmail, I start a search for "Full message" (that's "Vollständige > Nachricht" in german) with content ZMI_FullMessage on an IMAP Folder. > The IMAP command generated is: > 104860 UID SEARCH TEXT "ZMI_FullMessage" > > And the resulting SELECT is: > > SELECT m.message_idnr, v.headervalue, k.messageblk FROM > dbmail_messageblks k JOIN dbmail_physmessage p ON > k.physmessage_id=p.id JOIN dbmail_messages m ON m.physmessage_id=p.id > JOIN dbmail_headervalue v ON v.physmessage_id=p.id WHERE > m.mailbox_idnr=3324 AND m.status in (0,1) HAVING > SUBSTRING(v.headervalue,0,255) ILIKE '%ZMI_FullMessage%' OR > k.messageblk ILIKE '%ZMI_FullMessage%' > > This SELECT produced an error on PostgreSQL 8.3: > ERROR: operator does not exist: bytea ~~* unknown > ZEILE 1: ...,0,255) ILIKE '%ZMI_FullMessage%' OR k.messageblk ILIKE > '%ZM... > TIP: No operator matches the given name and argument type(s). You > might need to add explicit type casts. > > After changing that to "OR k.messageblk::Text ILIKE > '%ZMI_FullMessage%';" (you see, I only casted k.messageblk to a Text > field, and tried with varchar also for the same result) I got the > error: ERROR: column "m.message_idnr" must appear in the GROUP BY > clause or be used in an aggregate function > > Still dbmail returns several messages: > * SEARCH 3635587 (and about 20 other numbers) > 104860 OK SEARCH completed > > And those messages for sure do not contain what I searched for. > > mfg zmi mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
