File patch-SQL_ASCII_SORT of Package spamassassin

Overview Repositories Revisions Requests Users Attributes Meta

File patch-SQL_ASCII_SORT of Package spamassassin (Revision 3b740764823bd3ae7375f1768c8241b0)

Currently displaying revision 3b740764823bd3ae7375f1768c8241b0 , Show latest

Index: lib/Mail/SpamAssassin/Conf/SQL.pm
===================================================================
--- lib/Mail/SpamAssassin/Conf/SQL.pm.orig
+++ lib/Mail/SpamAssassin/Conf/SQL.pm
@@ -148,9 +148,14 @@ sub load_with_dbi {
        $sql =~ s/_DOMAIN_/$quoted_domain/g;
      }
      else {
-       $sql = "select $f_preference, $f_value  from $f_table where ". 
-        "$f_username = ".$dbh->quote($username).
-        " or $f_username = '\@GLOBAL' order by $f_username asc";
+       $sql = "select $f_preference, $f_value, ascii(username) as user_asci from $f_table where ".
+       "$f_username = ".$dbh->quote($username).
+       " or $f_username = '\@GLOBAL' order by user_asci asc";
+       # changed by varkoly@novell.com on 09.02.2007 suggested by 
+       # Charles Camello <charles@integrasul.inf.br>
+       #$sql = "select $f_preference, $f_value  from $f_table where ". 
+       #"$f_username = ".$dbh->quote($username).
+       #" or $f_username = '\@GLOBAL' order by $f_username asc";
      }
      dbg("config: Conf::SQL: executing SQL: $sql");
      my $sth = $dbh->prepare($sql);

Places

File patch-SQL_ASCII_SORT of Package spamassassin (Revision 3b740764823bd3ae7375f1768c8241b0)

Places