From 52ac92e7c7636808556cce7db9a608a363dc7dfc Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Fri, 12 Feb 2021 09:18:50 +0000 Subject: Handle NULL values when comparing derivation output details set ids Otherwise this restricts the results to entries where neither value is NULL. --- guix-data-service/comparison.scm | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'guix-data-service') diff --git a/guix-data-service/comparison.scm b/guix-data-service/comparison.scm index aad76bd..a61165e 100644 --- a/guix-data-service/comparison.scm +++ b/guix-data-service/comparison.scm @@ -386,8 +386,16 @@ WHERE "") (if exclude-unchanged-outputs? " - AND base_packages.derivation_output_details_set_id <> + AND + ( + ( + base_packages.derivation_output_details_set_id IS NULL OR + target_packages.derivation_output_details_set_id IS NULL + ) OR ( + base_packages.derivation_output_details_set_id <> target_packages.derivation_output_details_set_id + ) + ) " "") (cond -- cgit v1.2.3