diff options
| author |   myk%mozilla.org <> | 2004-01-31 08:49:56 +0000 |
|---|---|---|
| committer | myk%mozilla.org <> | 2004-01-31 08:49:56 +0000 |
| commit | b414efe758211cd96b6f4082cbca5201d5263c24 (patch) | |
| tree | d9ef86a31cb1382e9c5b1a92400f6540efcf4451 /Bugzilla/Flag.pm | |
| parent | Patch for bug 213679: Implement a parameter that allows administrators to con... (diff) | |
| download | bugzilla-b414efe758211cd96b6f4082cbca5201d5263c24.tar.gz bugzilla-b414efe758211cd96b6f4082cbca5201d5263c24.tar.bz2 bugzilla-b414efe758211cd96b6f4082cbca5201d5263c24.zip | |
Fix for bug 228917: Makes some flag SQL work with PostgreSQL by using the semantically equivalent INNER JOIN over a comma (,).
Patch by mkanat@kerio.com.
r=myk
a=myk
Diffstat (limited to 'Bugzilla/Flag.pm')
| -rw-r--r-- | Bugzilla/Flag.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Bugzilla/Flag.pm b/Bugzilla/Flag.pm index a766e9e6f..2052f9507 100644 --- a/Bugzilla/Flag.pm +++ b/Bugzilla/Flag.pm @@ -244,12 +244,12 @@ sub process { # no longer valid. &::SendSQL(" SELECT flags.id - FROM flags, bugs LEFT OUTER JOIN flaginclusions i - ON (flags.type_id = i.type_id + FROM (flags INNER JOIN bugs ON flags.bug_id = bugs.bug_id) + LEFT OUTER JOIN flaginclusions i + ON (flags.type_id = i.type_id AND (bugs.product_id = i.product_id OR i.product_id IS NULL) AND (bugs.component_id = i.component_id OR i.component_id IS NULL)) WHERE flags.type_id = $target->{'bug'}->{'id'} - AND flags.bug_id = bugs.bug_id AND i.type_id IS NULL "); clear(&::FetchOneColumn()) while &::MoreSQLData(); |