[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reproducible debian: build.sh: fix SQL error

[Mattia Rizzolo]

Mattia Rizzolo pushed to branch master at Debian QA / jenkins.debian.net


Commits:
e6af59dd by Mattia Rizzolo at 2018-06-21T13:45:08+02:00
reproducible debian: build.sh: fix SQL error

ERROR:  column reference "package_id" is ambiguous
LINE 1: ...led16-arm64.debian.net', job='arm64_4/9231' WHERE package_id...
                                                             ^

Now, I can't see how it can possibly be ambiguous in such query with
only one table involved, but whatever…

Signed-off-by: Mattia Rizzolo <mattia at debian.org>

- - - - -


1 changed file:

- bin/reproducible_build.sh


Changes:

=====================================
bin/reproducible_build.sh
=====================================
--- a/bin/reproducible_build.sh
+++ b/bin/reproducible_build.sh
@@ -170,7 +170,7 @@ update_db_and_html() {
 		fi
 	fi
 	# Insert or update existing entry in results table
-	query_db "INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('$SRCPKGID', '$VERSION', '$STATUS', '$DATE', '$DURATION', '$NODE1', '$NODE2', '$JOB') ON CONFLICT (package_id) DO UPDATE SET version='$VERSION', status='$STATUS', build_date='$DATE', build_duration='$DURATION', node1='$NODE1', node2='$NODE2', job='$JOB' WHERE package_id='$SRCPKGID'"
+	query_db "INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('$SRCPKGID', '$VERSION', '$STATUS', '$DATE', '$DURATION', '$NODE1', '$NODE2', '$JOB') ON CONFLICT (package_id) DO UPDATE SET version='$VERSION', status='$STATUS', build_date='$DATE', build_duration='$DURATION', node1='$NODE1', node2='$NODE2', job='$JOB' WHERE results.package_id='$SRCPKGID'"
 	query_db "INSERT INTO stats_build (name, version, suite, architecture, status, build_date, build_duration, node1, node2, job) VALUES ('$SRCPACKAGE', '$VERSION', '$SUITE', '$ARCH', '$STATUS', '$DATE', '$DURATION', '$NODE1', '$NODE2', '$JOB')"
 	# unmark build since it's properly finished
 	query_db "DELETE FROM schedule WHERE package_id='$SRCPKGID';"



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/e6af59dd4a9c6e5649d4fa68d8ac3992ce3ee454

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/e6af59dd4a9c6e5649d4fa68d8ac3992ce3ee454
You're receiving this email because of your account on salsa.debian.org.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20180621/e5926bca/attachment.html>