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

---
 checksetup.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'checksetup.pl')

diff --git a/checksetup.pl b/checksetup.pl
index 3f4a68b78..225a3341e 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -2445,7 +2445,7 @@ if (!($sth->fetchrow_arrayref()->[0])) {
     $sth = $dbh->prepare(
         "SELECT longdescs.bug_id, thetext " .
           "FROM longdescs " .
-     "LEFT JOIN bugs using(bug_id) " .
+     "LEFT JOIN bugs ON longdescs.bug_id = bugs.bug_id " .
          "WHERE (" . $dbh->sql_regexp("thetext",
                  "'[.*.]{3} This bug has been marked as a duplicate of [[:digit:]]+ [.*.]{3}'") . ") " .
            "AND (resolution = 'DUPLICATE') " .
-- 
cgit v1.2.3-24-g4f1b