From b808272b74ab202b17964fbb64b189e4b912ec2b Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Fri, 7 Oct 2005 01:43:43 +0000
Subject: Bug 309680: Use SQL "JOIN ... ON ..." syntax instead of "JOIN ...
 USING(...)" Patch By Lance Larsh <lance.larsh@oracle.com> r=mkanat,
 a=justdave

---
 Bugzilla/Bug.pm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'Bugzilla/Bug.pm')

diff --git a/Bugzilla/Bug.pm b/Bugzilla/Bug.pm
index b9206b9a0..e050d2211 100755
--- a/Bugzilla/Bug.pm
+++ b/Bugzilla/Bug.pm
@@ -177,7 +177,7 @@ sub initBug  {
       $dbh->sql_date_format('deadline', '%Y-%m-%d') . "
     FROM bugs
        LEFT JOIN votes
-           USING (bug_id)
+              ON bugs.bug_id = votes.bug_id
       INNER JOIN components
               ON components.id = bugs.component_id
       INNER JOIN products
@@ -1011,7 +1011,7 @@ sub RemoveVotes {
                             "products.votesperuser, products.maxvotesperbug " .
                             "FROM profiles " . 
                             "LEFT JOIN votes ON profiles.userid = votes.who " .
-                            "LEFT JOIN bugs USING(bug_id) " .
+                            "LEFT JOIN bugs ON votes.bug_id = bugs.bug_id " .
                             "LEFT JOIN products ON products.id = bugs.product_id " .
                             "WHERE votes.bug_id = ? " . $whopart);
     $sth->execute($id);
-- 
cgit v1.2.3-24-g4f1b