You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@spamassassin.apache.org by bu...@issues.apache.org on 2010/07/19 01:09:37 UTC
[Bug 6464] New: rpad needs its first argument to be of type text and
not bytearray
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6464
Summary: rpad needs its first argument to be of type text and
not bytearray
Product: Spamassassin
Version: 3.3.1
Platform: PC
OS/Version: Linux
Status: NEW
Severity: normal
Priority: P2
Component: Libraries
AssignedTo: dev@spamassassin.apache.org
ReportedBy: endymion+sa@thetys-retz.net
postmaster.log from postgresql 8.4 issue this message : ERROR: function
rpad(bytea, integer, unknown) does not exist at character 8
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
SELECT rpad(token::text , 5, ' '), spam_count, ham_count, atime FROM
bayes_token WHERE (spam_count > 0 OR ham_count > 0) ;
works whereas
SELECT rpad(token, 5, ' '), spam_count, ham_count, atime FROM bayes_token WHERE
(spam_count > 0 OR ham_count > 0) ;
doesn't.
File to patch :
/usr/lib/perl5/vendor_perl/5.12.1/Mail/SpamAssassin/BayesStore/SQL.pm:2358:
return "RPAD(token, 5, ' ')";
--
Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
[Bug 6464] rpad needs its first argument to be of type text and not
bytearray
Posted by bu...@bugzilla.spamassassin.org.
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6464
Kevin A. McGrail <km...@pccc.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kmcgrail@pccc.com
--- Comment #1 from Kevin A. McGrail <km...@pccc.com> 2011-11-01 19:37:30 UTC ---
I wonder if there are binary tokens and that's throwing off things for
postgres.
Otherwise, I'm guessing that using return "RPAD(token::text, 5, ' ')"; will
break mysql.
--
Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
[Bug 6464] rpad needs its first argument to be of type text and not
bytearray
Posted by bu...@bugzilla.spamassassin.org.
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6464
Mark Martinec <Ma...@ijs.si> changed:
What |Removed |Added
----------------------------------------------------------------------------
Target Milestone|Undefined |3.4.0
--
Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
[Bug 6464] rpad needs its first argument to be of type text and not
bytearray
Posted by bu...@bugzilla.spamassassin.org.
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6464
--- Comment #2 from Mark Martinec <Ma...@ijs.si> 2011-11-02 15:22:21 UTC ---
I think the problem here is misusing a bayes_store_module setting
of Mail::SpamAssassin::BayesStore::SQL with PostgreSQL, instead of:
bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL
There is no call to pad() in PgSQL.pm.
--
Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
[Bug 6464] rpad needs its first argument to be of type text and not
bytearray
Posted by bu...@bugzilla.spamassassin.org.
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6464
Mark Martinec <Ma...@ijs.si> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |INVALID
--- Comment #3 from Mark Martinec <Ma...@ijs.si> ---
> I think the problem here is misusing a bayes_store_module setting
> of Mail::SpamAssassin::BayesStore::SQL with PostgreSQL, instead of:
> bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL
> There is no call to rpad() in PgSQL.pm.
Indeed. Closing as invalid.
--
You are receiving this mail because:
You are the assignee for the bug.