commit 26287cdc50ba0938f67ca4e4e14d68f7b83b99c2
parent 508a02dd7ce79d8e84f636f270a04cf970e356d4
Author: Christian Grothoff <christian@grothoff.org>
Date: Sat, 18 Apr 2026 22:47:23 +0200
-fix SQL bugs
Diffstat:
2 files changed, 1 insertion(+), 2 deletions(-)
diff --git a/src/backenddb/pg_increment_money_pots.sql b/src/backenddb/pg_increment_money_pots.sql
@@ -77,7 +77,7 @@ FOR i IN 1..COALESCE(array_length(ina_money_pots_ids, 1),0)
FOR j IN 1..COALESCE(array_length(my_totals, 1), 0)
LOOP
- IF (my_totals[j]).currency = (ini_current_increment).currency
+ IF (my_totals[j]).curr = (ini_current_increment).curr
THEN
my_totals[j].frac
= my_totals[j].frac + ini_current_increment.frac;
diff --git a/src/backenddb/pg_insert_transfer_details.sql b/src/backenddb/pg_insert_transfer_details.sql
@@ -87,7 +87,6 @@ SELECT expected_credit_serial
(SELECT account_serial
FROM merchant_accounts
WHERE payto_uri=in_payto_uri
- AND exchange_url=in_exchange_url
AND merchant_serial=my_merchant_id);
IF NOT FOUND