From 4adb66027bc5424c10d5f829b6de20867bd4f015 Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Sat, 12 Mar 2005 03:31:36 +0000
Subject: Bug 285407: User cannot log in on PostgreSQL Patch By Max
 Kanat-Alexander <mkanat@kerio.com> r=bugreport, a=myk

---
 Bugzilla/User.pm | 10 ++++++----
 1 file changed, 6 insertions(+), 4 deletions(-)

(limited to 'Bugzilla')

diff --git a/Bugzilla/User.pm b/Bugzilla/User.pm
index 8045ee228..36179fcce 100644
--- a/Bugzilla/User.pm
+++ b/Bugzilla/User.pm
@@ -204,12 +204,14 @@ sub queries {
     my $dbh = Bugzilla->dbh;
     my $sth = $dbh->prepare(q{ SELECT
                              DISTINCT name, query, linkinfooter,
-                                      IF(whine_queries.id IS NOT NULL, 1, 0)
+                                      CASE WHEN whine_queries.id 
+                                      IS NOT NULL THEN 1 ELSE 0 END,
+                                      UPPER(name) AS uppername 
                                  FROM namedqueries
                             LEFT JOIN whine_queries
                                    ON whine_queries.query_name = name
                                 WHERE userid=?
-                             ORDER BY UPPER(name)});
+                             ORDER BY uppername});
     $sth->execute($self->{id});
 
     my @queries;
@@ -494,8 +496,8 @@ sub derive_groups {
             $group_sth ||= $dbh->prepare(q{SELECT grantor_id
                                              FROM group_group_map
                                             WHERE member_id=?
-                                              AND grant_type=' . 
-                                                  GROUP_MEMBERSHIP . '});
+                                              AND grant_type = } .
+                                                  GROUP_MEMBERSHIP);
             $group_sth->execute($group);
             while (my ($groupid) = $group_sth->fetchrow_array) {
                 if (!defined($groupidschecked{"$groupid"})) {
-- 
cgit v1.2.3-24-g4f1b