The following commit has been merged in the master branch:
commit 0ead462624d4a9a01a307fe56b769630aeaf818f
Author: Andreas Tille <[email protected]>
Date: Mon Jul 11 23:02:09 2016 +0200
fix column name
diff --git a/misc/sql/0-missing-autopkgtest.sh
b/misc/sql/0-missing-autopkgtest.sh
index dffbdc4..3486095 100755
--- a/misc/sql/0-missing-autopkgtest.sh
+++ b/misc/sql/0-missing-autopkgtest.sh
@@ -33,7 +33,7 @@ if ! psql $PORT $SERVICE -c "" 2>/dev/null ; then
fi
psql $SERVICE <<EOT
-SELECT source, vote, MAX(testsuite), tags FROM (
+SELECT source, vote, MAX(testsuite) as testsuite, tags FROM (
SELECT source, vote, testsuite, tags, row_number() OVER (PARTITION BY source
ORDER BY vote DESC) FROM (
SELECT DISTINCT p.source, p.package, CASE WHEN pop.vote IS NULL THEN -1
ELSE pop.vote END AS vote, s.testsuite, d.tags FROM packages p
LEFT OUTER JOIN popcon pop ON p.package = pop.package
--
Static and dynamic websites for Debian Pure Blends
_______________________________________________
Blends-commit mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit
