summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2014-10-04 12:59:17 +0200
committerHolger Levsen <holger@layer-acht.org>2014-10-04 12:59:17 +0200
commit411cdb0608b07439fbe0a75f981bdd5518fe968f (patch)
tree7ceb72ae47dfa1092ec3c9358def210be6474faa /bin
parentc1fe1c605e3bd126809fb87d0cd650473a43be80 (diff)
downloadjenkins.debian.net-411cdb0608b07439fbe0a75f981bdd5518fe968f.tar.xz
reproducible: fix sql query to select failing packages with newer version
Diffstat (limited to 'bin')
-rwxr-xr-xbin/reproducible_build.sh2
1 files changed, 1 insertions, 1 deletions
diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh
index d006010b..09c3c67c 100755
--- a/bin/reproducible_build.sh
+++ b/bin/reproducible_build.sh
@@ -93,7 +93,7 @@ if [[ $1 =~ ^-?[0-9]+$ ]] ; then
echo ".import $CSVFILE sources" | sqlite3 -csv -init $INIT ${PACKAGES_DB}
rm $CSVFILE
AMOUNT=33
- PACKAGES=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT DISTINCT source_packages.name FROM source_packages,sources,job_sources WHERE (( source_packages.status = 'unreproducible' OR source_packages.status = 'FTBFS') AND source_packages.name = job_sources.name AND source_packages.name = sources.name AND job_sources.job = 'random' AND source_packages.version != sources.version) ORDER BY source_packages.build_date LIMIT $AMOUNT" | xargs -r echo)
+ PACKAGES=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT DISTINCT source_packages.name FROM source_packages,sources,job_sources WHERE sources.version IN (SELECT version FROM sources WHERE name=source_packages.name ORDER by sources.version DESC LIMIT 1) AND (( source_packages.status = 'unreproducible' OR source_packages.status = 'FTBFS') AND source_packages.name = job_sources.name AND source_packages.name = sources.name AND job_sources.job = 'random' AND source_packages.version < sources.version) ORDER BY source_packages.build_date LIMIT $AMOUNT" | xargs -r echo)
echo "Info: Only unreproducible and FTBFS packages with a new version available are selected from this job."
AMOUNT=0
for PKG in $PACKAGES ; do