[aur-dev] [PATCH] git-serve: Fix broken SQL statement
Lukas Fleischer
lfleischer at archlinux.org
Tue Aug 8 13:37:01 UTC 2017
Add a missing space to the SQL statement performing the disown
operation.
Fixes FS#55068.
Note that the broken query was not discovered by the test suite since
SQLite parses "?AND" inside prepared statements gracefully while MySQL
does not.
Signed-off-by: Lukas Fleischer <lfleischer at archlinux.org>
---
aurweb/git/serve.py | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/aurweb/git/serve.py b/aurweb/git/serve.py
index eea0c9c..dfaddd1 100755
--- a/aurweb/git/serve.py
+++ b/aurweb/git/serve.py
@@ -192,7 +192,7 @@ def pkgreq_by_pkgbase(pkgbase_id, reqtype):
"INNER JOIN RequestTypes ON " +
"RequestTypes.ID = PackageRequests.ReqTypeID " +
"WHERE PackageRequests.Status = 0 " +
- "AND PackageRequests.PackageBaseID = ?" +
+ "AND PackageRequests.PackageBaseID = ? " +
"AND RequestTypes.Name = ?", [pkgbase_id, reqtype])
return [row[0] for row in cur.fetchall()]
--
2.14.0
More information about the aur-dev
mailing list