[taler-exchange] 129/151: -fix SQL bugs

[gnunet]

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

grothoff pushed a commit to branch master
in repository exchange.

commit c97633adb8bdfc6f6f2d574e2ada7127c7ba949d
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Fri Jul 26 15:44:30 2024 +0200

    -fix SQL bugs
---
 src/exchangedb/pg_lookup_aml_history.c | 6 +++---
 src/exchangedb/pg_lookup_kyc_history.c | 4 ++--
 2 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/src/exchangedb/pg_lookup_aml_history.c 
b/src/exchangedb/pg_lookup_aml_history.c
index 01744bcdd..077e2781c 100644
--- a/src/exchangedb/pg_lookup_aml_history.c
+++ b/src/exchangedb/pg_lookup_aml_history.c
@@ -141,17 +141,17 @@ TEH_PG_lookup_aml_history (
   PREPARE (pg,
            "lookup_aml_history",
            "SELECT"
-           " ah.decision_time"
+           " lo.decision_time"
            ",ah.justification"
            ",ah.decider_pub"
            ",lo.jproperties"
            ",lo.jnew_rules"
            ",lo.to_investigate"
-           ".lo.is_active"
+           ",lo.is_active"
            " FROM aml_history ah"
            " JOIN legitimization_outcomes lo"
            "   USING (outcome_serial_id)"
-           " WHERE h_payto=$1"
+           " WHERE ah.h_payto=$1"
            " ORDER BY decision_time DESC;");
   qs = GNUNET_PQ_eval_prepared_multi_select (
     pg->conn,
diff --git a/src/exchangedb/pg_lookup_kyc_history.c 
b/src/exchangedb/pg_lookup_kyc_history.c
index 6dc67356b..c5bc87d88 100644
--- a/src/exchangedb/pg_lookup_kyc_history.c
+++ b/src/exchangedb/pg_lookup_kyc_history.c
@@ -174,9 +174,9 @@ TEH_PG_lookup_kyc_history (
            ",ka.encrypted_attributes"
            " FROM kyc_attributes ka"
            "    JOIN legitimization_processes lp"
-           "      ON (ka.legitimization_serial = 
lp.legitimization_process_serial)"
+           "      ON (ka.legitimization_serial = 
lp.legitimization_process_serial_id)"
            " WHERE ka.h_payto=$1"
-           " ORDER BY collection_time DESC;");
+           " ORDER BY ka.collection_time DESC;");
 
   qs = GNUNET_PQ_eval_prepared_multi_select (
     pg->conn,

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