summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
authorMattia Rizzolo <mattia@debian.org>2017-11-06 11:37:59 +0100
committerMattia Rizzolo <mattia@debian.org>2017-11-06 11:39:16 +0100
commit2284a1b6f0793ce4fe4aeb95abba8eb2290e3818 (patch)
treeeb2e391752d556efce6b0677f3af73d7e1397fc8 /bin
parent72a8a5038d4228b0f923b3dc8b82314e44111a52 (diff)
downloadjenkins.debian.net-2284a1b6f0793ce4fe4aeb95abba8eb2290e3818.tar.xz
udd-query: orphaned_without_o_bug: consider only the higher version instead of the latest upload date
this fixes a fpos of a package adopted in experimental, but with a later qa upload in unstable. Signed-off-by: Mattia Rizzolo <mattia@debian.org>
Diffstat (limited to 'bin')
-rwxr-xr-xbin/udd-query.sh18
1 files changed, 9 insertions, 9 deletions
diff --git a/bin/udd-query.sh b/bin/udd-query.sh
index 7f5cc121..c8ad8cd2 100755
--- a/bin/udd-query.sh
+++ b/bin/udd-query.sh
@@ -69,16 +69,16 @@ orphaned_without_o_bug() {
WNPPRM=$(mktemp)
SORTED_UDD=$(mktemp)
- SQL_QUERY="SELECT DISTINCT u.source
- FROM upload_history AS u
+ SQL_QUERY="
+ SELECT DISTINCT s.source
+ FROM sources AS s
JOIN (
- SELECT s.source, max(u.date) AS date
- FROM upload_history AS u
- JOIN sources AS s ON s.source=u.source
- WHERE s.release = 'sid' OR s.release = 'experimental'
- GROUP BY s.source
- ) AS foo ON foo.source=u.source AND foo.date=u.date
- WHERE maintainer like '%packages@qa.debian.org%';"
+ SELECT source, max(version) AS version
+ FROM sources
+ WHERE release IN ('sid','experimental')
+ GROUP BY source
+ ) AS foo ON foo.source=s.source AND foo.version=s.version
+ WHERE s.maintainer_email = 'packages@qa.debian.org';"
udd_query
cat $UDD | tr -d ' ' | sort | uniq > "$SORTED_UDD"