diff options
| author | Florian Dold <florian@dold.me> | 2024-07-01 00:21:06 +0200 |
|---|---|---|
| committer | Florian Dold <florian@dold.me> | 2024-07-01 00:21:06 +0200 |
| commit | e4991a240859eb202967e6863abeb63e3dec5721 (patch) | |
| tree | 8965fea1cc5985a587d4cb81d94e0e5e497e2f04 | |
| parent | 0fa0357e132de24baf09718b0593a21fe7a7746c (diff) | |
fix SQL reference errorv0.11.9-dev.1
| -rw-r--r-- | src/backenddb/pg_lookup_all_products.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/backenddb/pg_lookup_all_products.c b/src/backenddb/pg_lookup_all_products.c index 31320d59..a80a19ee 100644 --- 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", |