diff options
| author | Dan McGee <dan@archlinux.org> | 2012-08-15 08:22:01 -0500 |
|---|---|---|
| committer | Dan McGee <dan@archlinux.org> | 2012-08-15 08:22:01 -0500 |
| commit | a071d800c6a26d3efcdc0d32fe1adb1cde7e6f31 (patch) | |
| tree | 3e71009b9c6c4e167baac4a5afbaaa77212c6379 | |
| parent | ca0011c585ec28f9dde0f400a77fd6f859d520b0 (diff) | |
Fix signoffs SQL query
Although the old query returned the same results, the repos IN clause
should really be a part of the WHERE, not the JOIN condition.
Signed-off-by: Dan McGee <dan@archlinux.org>
| -rw-r--r-- | packages/utils.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/packages/utils.py b/packages/utils.py index d95c015f..ee1b56b3 100644 --- a/packages/utils.py +++ b/packages/utils.py @@ -363,6 +363,7 @@ class PackageSignoffGroup(object): return u'%s-%s (%s): %d' % ( self.pkgbase, self.version, self.arch, len(self.signoffs)) + _SQL_SPEC_OR_SIGNOFF = """ SELECT DISTINCT s.id FROM %s s @@ -374,7 +375,7 @@ SELECT DISTINCT s.id AND s.arch_id = p.arch_id AND s.repo_id = p.repo_id ) - AND p.repo_id IN (%s) + WHERE p.repo_id IN (%s) """ |