cbaines pushed a commit to branch master in repository data-service. commit 60df7ecbf92ea57e3cf3b694459944a5d5fa682f Author: Christopher Baines <m...@cbaines.net> AuthorDate: Tue Mar 24 21:37:18 2020 +0000
Remove redundant DISTINCT from the derivation range INSERT query This was redundant and slow, so don't do it. --- .../model/package-derivation-by-guix-revision-range.scm | 10 +++++----- 1 file 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