02/03: Tweak the comparision query

[Christopher Baines]

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

commit 7e7cd3f5a95341179e0db0f7c8c825f6131c4bde
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Sun Mar 5 10:18:30 2023 +0000

    Tweak the comparision query
    
    This seems to generate better plans.
---
 guix-data-service/comparison.scm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/guix-data-service/comparison.scm b/guix-data-service/comparison.scm
index 4907357..dc521a4 100644
--- a/guix-data-service/comparison.scm
+++ b/guix-data-service/comparison.scm
@@ -345,7 +345,7 @@ SELECT base_packages.name, base_packages.version,
                   SELECT 1
                   FROM blocked_builds
                   WHERE blocked_derivation_output_details_set_id
-                         = builds.derivation_output_details_set_id
+                         = base_packages.derivation_output_details_set_id
                )
              )
              ORDER BY latest_build_status.timestamp
@@ -376,7 +376,7 @@ SELECT base_packages.name, base_packages.version,
                   SELECT 1
                   FROM blocked_builds
                   WHERE blocked_derivation_output_details_set_id
-                         = builds.derivation_output_details_set_id
+                         = target_packages.derivation_output_details_set_id
                )
              )
              ORDER BY latest_build_status.timestamp