exchange

commit 5f6a8a59398bbc546cf0fbb40cd3ff993fcd903c
parent c93d1d9df27f8f873bdd3c693558319175ebf631
Author: Christian Grothoff <christian@grothoff.org>
Date:   Mon,  5 Aug 2024 00:20:40 +0200

limit join to active outcomes, or no outcome

Diffstat:
M
src/exchangedb/pg_lookup_kyc_requirement_by_row.c
 | 
5
+++--

1 file changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/exchangedb/pg_lookup_kyc_requirement_by_row.c b/src/exchangedb/pg_lookup_kyc_requirement_by_row.c
@@ -80,8 +80,9 @@ TEH_PG_lookup_kyc_requirement_by_row (
            "   USING (access_token)"
            " LEFT JOIN legitimization_outcomes lo"
            "   ON (wt.wire_target_h_payto = lo.h_payto)"
-           " WHERE legitimization_measure_serial_id=$1"
-           "   AND lo.is_active;");
+           " WHERE lm.legitimization_measure_serial_id=$1"
+           "   AND ( (lo.is_active IS NULL)"
+           "          OR lo.is_active);");
   return GNUNET_PQ_eval_prepared_singleton_select (
     pg->conn,
     "lookup_kyc_requirement_by_row",