The following commit has been merged in the master branch:
commit 725fb9416fcb03dff74123095d446530ff5b95d2
Author: Andreas Tille <[email protected]>
Date: Mon Jul 11 23:00:15 2016 +0200
Avoid duplicates
diff --git a/misc/sql/0-missing-autopkgtest.sh
b/misc/sql/0-missing-autopkgtest.sh
index 10620de..dffbdc4 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, testsuite, tags FROM (
+SELECT source, vote, MAX(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
@@ -45,6 +45,7 @@ SELECT source, vote, testsuite, tags FROM (
AND p.release = 'sid'
) tmp1
) tmp2
+GROUP BY source, vote, tags
ORDER BY vote DESC, source
;
EOT
--
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
