[taler-exchange] branch master updated: limit join to active outcomes, or no outcome

[gnunet]

This is an automated email from the git hooks/post-receive script.

grothoff pushed a commit to branch master
in repository exchange.

The following commit(s) were added to refs/heads/master by this push:
     new 5f6a8a593 limit join to active outcomes, or no outcome
5f6a8a593 is described below

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

    limit join to active outcomes, or no outcome
---
 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
index f66627508..36ab3e756 100644
--- 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",

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.