From 5a18e955ebd663a6e1318378002a6368a7c07566 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Sat, 4 Feb 2023 21:54:47 +0100
Subject: -fix AML decision update logic and history fetch logic

---
 src/exchangedb/pg_select_aml_process.c | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'src/exchangedb/pg_select_aml_process.c')

diff --git a/src/exchangedb/pg_select_aml_process.c b/src/exchangedb/pg_select_aml_process.c
index 6ee0dbeb9..5df5fe657 100644
--- a/src/exchangedb/pg_select_aml_process.c
+++ b/src/exchangedb/pg_select_aml_process.c
@@ -140,25 +140,25 @@ TEH_PG_select_aml_process (
            "SELECT"
            " aml_status_serial_id"
            ",h_payto"
-           ",threshold_var"
+           ",threshold_val"
            ",threshold_frac"
            ",status"
            " FROM aml_status"
            " WHERE aml_status_serial_id > $2"
            "   AND status = $1"
-           " ORDER BY aml_status_serial_id INC"
+           " ORDER BY aml_status_serial_id ASC"
            " LIMIT $3");
   PREPARE (pg,
            "select_aml_process_dec",
            "SELECT"
            " aml_status_serial_id"
            ",h_payto"
-           ",threshold_var"
+           ",threshold_val"
            ",threshold_frac"
            ",status"
            " FROM aml_status"
            " WHERE aml_status_serial_id < $2"
-           "   AND $1 = status & $1"
+           "   AND status = $1"
            " ORDER BY aml_status_serial_id DESC"
            " LIMIT $3");
   qs = GNUNET_PQ_eval_prepared_multi_select (pg->conn,
-- 
cgit v1.2.3