From 07b4b1aa3f2c9ac74462ff3cb2b6a32c25e13c2e Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Sun, 27 Nov 2022 22:06:59 +0100 Subject: handle partner_serial_id being NULL --- src/exchangedb/pg_get_reserve_history.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/exchangedb/pg_get_reserve_history.c') diff --git a/src/exchangedb/pg_get_reserve_history.c b/src/exchangedb/pg_get_reserve_history.c index 8b8e280a6..6042a620e 100644 --- a/src/exchangedb/pg_get_reserve_history.c +++ b/src/exchangedb/pg_get_reserve_history.c @@ -803,7 +803,7 @@ TEH_PG_get_reserve_history (void *cls, " ON (am.purse_pub = pm.purse_pub AND" " am.reserve_pub = pm.reserve_pub)" " WHERE pm.reserve_pub=$1" - " AND pm.partner_serial_id=0" /* must be local! */ + " AND COALESCE(pm.partner_serial_id,0)=0" /* must be local! */ " AND NOT pdes.refunded;"); PREPARE (pg, "history_by_reserve", @@ -1097,7 +1097,7 @@ TEH_PG_get_reserve_status (void *cls, " am.reserve_pub = pm.reserve_pub)" " WHERE pm.reserve_pub=$1" " AND pm.merge_timestamp >= $2" - " AND pm.partner_serial_id=0" /* must be local! */ + " AND COALESCE(pm.partner_serial_id,0)=0" /* must be local! */ " AND NOT pdes.refunded;"); PREPARE (pg, "history_by_reserve_truncated", -- cgit v1.2.3