From 2284a1b6f0793ce4fe4aeb95abba8eb2290e3818 Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Mon, 6 Nov 2017 11:37:59 +0100 Subject: 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 --- bin/udd-query.sh | 18 +++++++++--------- 1 file 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" -- cgit v1.2.3-54-g00ecf