merchant

commit e4991a240859eb202967e6863abeb63e3dec5721
parent 0fa0357e132de24baf09718b0593a21fe7a7746c
Author: Florian Dold <florian@dold.me>
Date:   Mon,  1 Jul 2024 00:21:06 +0200

fix SQL reference error

Diffstat:
M
src/backenddb/pg_lookup_all_products.c
 | 
6
+++---

1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/backenddb/pg_lookup_all_products.c b/src/backenddb/pg_lookup_all_products.c
@@ -169,8 +169,8 @@ TMH_PG_lookup_all_products (void *cls,
            ",minimum_age"
            ",product_id"
            ",product_serial"
-           " FROM merchant_inventory"
-           " JOIN merchant_instances"
+           " FROM merchant_inventory mi"
+           " JOIN merchant_instances inst"
            "   USING (merchant_serial)"
            ",LATERAL ("
            "   SELECT ARRAY ("
@@ -179,7 +179,7 @@ TMH_PG_lookup_all_products (void *cls,
            "      WHERE mpc.product_serial = mi.product_serial"
            "   ) AS category_array"
            " ) t"
-           " WHERE merchant_instances.merchant_id=$1");
+           " WHERE inst.merchant_id=$1");
   qs = GNUNET_PQ_eval_prepared_multi_select (
     pg->conn,
     "lookup_all_products",