From 6b8c75788710b64eaf1323c9cd95a428c129012d Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Wed, 17 Nov 2021 11:26:19 +0100
Subject: towards merging with master

---
 src/exchangedb/plugin_exchangedb_postgres.c | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)

(limited to 'src/exchangedb')

diff --git a/src/exchangedb/plugin_exchangedb_postgres.c b/src/exchangedb/plugin_exchangedb_postgres.c
index 9bfe777f4..57c222455 100644
--- a/src/exchangedb/plugin_exchangedb_postgres.c
+++ b/src/exchangedb/plugin_exchangedb_postgres.c
@@ -864,16 +864,16 @@ prepare_statements (struct PostgresClosure *pg)
     GNUNET_PQ_make_prepare (
       "get_refresh_revealed_coins",
       "SELECT "
-      " freshcoin_index"
+      " rrc.freshcoin_index"
       ",denom.denom_pub"
-      ",link_sig"
-      ",coin_ev"
-      ",ev_sig"
-      " FROM refresh_revealed_coins"
+      ",rrc.link_sig"
+      ",rrc.coin_ev"
+      ",rrc.ev_sig"
+      " FROM refresh_commitments"
+      "    JOIN refresh_revealed_coins rrc"
+      "      USING (melt_serial_id)"
       "    JOIN denominations denom "
       "      USING (denominations_serial)"
-      "    JOIN refresh_commitments"
-      "      USING (melt_serial_id)"
       " WHERE rc=$1"
       "   ORDER BY freshcoin_index ASC;",
       1),
-- 
cgit v1.2.3