aboutsummaryrefslogtreecommitdiff
path: root/guix-data-service/model
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2021-09-16 17:01:34 +0100
committerChristopher Baines <mail@cbaines.net>2021-09-16 17:01:34 +0100
commit8b34126d220c8375ac185955f540dc13fd38e446 (patch)
tree047fecd6c88e737af8638d2af0a44bf20421021c /guix-data-service/model
parentf2b9663cf2e27fbe7daa46d85744d0236d0a3005 (diff)
downloaddata-service-8b34126d220c8375ac185955f540dc13fd38e446.tar
data-service-8b34126d220c8375ac185955f540dc13fd38e446.tar.gz
Fix the select-source-files-missing-nars query
Previously, the VALUES list wasn't being generated properly.
Diffstat (limited to 'guix-data-service/model')
-rw-r--r--guix-data-service/model/derivation.scm9
1 files changed, 6 insertions, 3 deletions
diff --git a/guix-data-service/model/derivation.scm b/guix-data-service/model/derivation.scm
index 9c58dd0..3e882cb 100644
--- a/guix-data-service/model/derivation.scm
+++ b/guix-data-service/model/derivation.scm
@@ -1753,10 +1753,13 @@ WHERE " criteria ";"))
"
WITH RECURSIVE all_derivations AS (
SELECT column1 AS derivation_id
- FROM (VALUES ("
- (string-join (map number->string ids)
+ FROM (VALUES "
+ (string-join (map
+ (lambda (id)
+ (string-append "(" id ")"))
+ (map number->string ids))
", ")
- ")) AS data
+ ") AS data
UNION
SELECT derivation_outputs.derivation_id
FROM all_derivations