commit 2214fa5640bf277351c4de1524ad61d422b8e8bd
parent 6f607ef343c0af08ccc6e6fbec1afc26e5446f85
Author: Christian Grothoff <christian@grothoff.org>
Date: Fri, 27 Feb 2026 18:11:29 +0100
-fix query for other direction
Diffstat:
1 file changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/backenddb/pg_lookup_transfers.c b/src/backenddb/pg_lookup_transfers.c
@@ -208,9 +208,15 @@ TMH_PG_lookup_transfers (void *cls,
",mt.credit_serial"
",mt.execution_time"
",mt.expected"
+ ",met.expected_credit_serial"
" FROM merchant_transfers mt"
" JOIN merchant_accounts mac"
" USING (account_serial)"
+ " LEFT JOIN merchant_expected_transfers met"
+ " ON mt.wtid = met.wtid"
+ " AND mt.account_serial = met.account_serial"
+ " AND mt.exchange_url = met.exchange_url"
+ " AND mt.expected"
" WHERE ( $7 OR "
" (mt.execution_time < $2 AND"
" mt.execution_time >= $3) )"