05/05: Remove redundant DISTINCT from the derivation range INSERT query

[Christopher Baines]

cbaines pushed a commit to branch master
in repository data-service.

commit 60df7ecbf92ea57e3cf3b694459944a5d5fa682f
Author: Christopher Baines <address@hidden>
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