diff options
| author | justdave%syndicomm.com <> | 2001-09-07 10:32:13 +0200 |
|---|---|---|
| committer | justdave%syndicomm.com <> | 2001-09-07 10:32:13 +0200 |
| commit | dac2f59798ada0a77717d4a6f455901c8bf1c10a (patch) | |
| tree | 5905b4d6dc1c38cca6992447efd5687e811f82ea /sanitycheck.cgi | |
| parent | ad00b1a24a038c01a9e57a7cbace4165de958e1b (diff) | |
| download | bugzilla-dac2f59798ada0a77717d4a6f455901c8bf1c10a.tar.gz bugzilla-dac2f59798ada0a77717d4a6f455901c8bf1c10a.tar.xz | |
refix for bug 91808: previous patch for this bug used an INNER JOIN construct in the SQL, which is not supported by the
minimum version of MySQL that we require.
Patch by Matthew Tuck <matty@chariot.net.au>
r= justdave x2
Diffstat (limited to 'sanitycheck.cgi')
| -rwxr-xr-x | sanitycheck.cgi | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sanitycheck.cgi b/sanitycheck.cgi index 72a2d3818..89861b4ed 100755 --- a/sanitycheck.cgi +++ b/sanitycheck.cgi @@ -399,8 +399,9 @@ if (@badbugs) { Status("Checking duplicates table"); SendSQL("SELECT bugs.bug_id " . - "FROM bugs INNER JOIN duplicates ON bugs.bug_id = duplicates.dupe " . + "FROM bugs, duplicates " . "WHERE bugs.resolution != 'DUPLICATE' " . + " AND bugs.bug_id = duplicates.dupe " . "ORDER BY bugs.bug_id"); @badbugs = (); |