From 8c98f47714fb1c1898ffa7b54966eaf913a0ae1d Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Thu, 27 May 2021 18:49:51 +0100 Subject: Fix datastore-list-build-outputs for the new outputs table --- guix-build-coordinator/datastore/sqlite.scm | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'guix-build-coordinator/datastore/sqlite.scm') diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm index fd75d2e..3c55344 100644 --- a/guix-build-coordinator/datastore/sqlite.scm +++ b/guix-build-coordinator/datastore/sqlite.scm @@ -3030,10 +3030,12 @@ WHERE derivation_id = :derivation_id" (sqlite-prepare db " -SELECT name, output, hash, size, store_references +SELECT name, outputs.output, hash, size, store_references FROM builds INNER JOIN derivation_outputs ON builds.derivation_id = derivation_outputs.derivation_id +INNER JOIN outputs + ON derivation_outputs.output_id = outputs.id LEFT JOIN output_metadata ON output_metadata.derivation_output_id = derivation_outputs.id AND output_metadata.build_id = builds.id -- cgit v1.2.3