diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-03-24 21:37:18 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-03-24 21:37:18 +0000 |
| commit | 60df7ecbf92ea57e3cf3b694459944a5d5fa682f (patch) | |
| tree | 5e2e5aa24299f8bb1260d3594885a8c1840263f1 /guix-data-service/model/package-derivation-by-guix-revision-range.scm | |
| parent | 994318782a8184d3967d6b4b0e08391910879fc8 (diff) | |
| download | data-service-60df7ecbf92ea57e3cf3b694459944a5d5fa682f.tar data-service-60df7ecbf92ea57e3cf3b694459944a5d5fa682f.tar.gz | |
Remove redundant DISTINCT from the derivation range INSERT query
This was redundant and slow, so don't do it.
Diffstat (limited to 'guix-data-service/model/package-derivation-by-guix-revision-range.scm')
| -rw-r--r-- | guix-data-service/model/package-derivation-by-guix-revision-range.scm | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/guix-data-service/model/package-derivation-by-guix-revision-range.scm b/guix-data-service/model/package-derivation-by-guix-revision-range.scm index 712f546..4c5cbf6 100644 --- a/guix-data-service/model/package-derivation-by-guix-revision-range.scm +++ b/guix-data-service/model/package-derivation-by-guix-revision-range.scm @@ -66,11 +66,11 @@ SELECT DISTINCT OVER package_version AS last_guix_revision_id FROM packages INNER JOIN ( - SELECT DISTINCT package_derivations.package_id, - package_derivations.derivation_id, - package_derivations.system, - package_derivations.target, - guix_revision_package_derivations.revision_id + SELECT package_derivations.package_id, + package_derivations.derivation_id, + package_derivations.system, + package_derivations.target, + guix_revision_package_derivations.revision_id FROM package_derivations INNER JOIN guix_revision_package_derivations ON package_derivations.id = guix_revision_package_derivations.package_derivation_id |