[GNUnet-SVN] [taler-merchant] branch master updated: FETCH FIRST arg ROW ONLY -> LIMIT arg, in prepared statement, as postgresql doesn't like FETCH FIRST arg when arg is a $-parameter. DB testcase does not pass yet, logic is likely to be wrong.

[gnunet]

This is an automated email from the git hooks/post-receive script.

marcello pushed a commit to branch master
in repository merchant.

The following commit(s) were added to refs/heads/master by this push:
     new 325db61  FETCH FIRST arg ROW ONLY -> LIMIT arg, in prepared statement, 
as postgresql doesn't like FETCH FIRST arg when arg is a $-parameter. DB 
testcase does not pass yet, logic is likely to be wrong.
325db61 is described below

commit 325db6147719e85ea9bdf96fc384d98c7067f54d
Author: Marcello Stanisci <address@hidden>
AuthorDate: Fri Mar 17 21:08:04 2017 +0100

    FETCH FIRST arg ROW ONLY -> LIMIT arg, in prepared statement,
    as postgresql doesn't like FETCH FIRST arg when arg is a $-parameter.
    DB testcase does not pass yet, logic is likely to be wrong.
---
 src/backenddb/plugin_merchantdb_postgres.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/backenddb/plugin_merchantdb_postgres.c 
b/src/backenddb/plugin_merchantdb_postgres.c
index 257f65c..545d296 100644
--- a/src/backenddb/plugin_merchantdb_postgres.c
+++ b/src/backenddb/plugin_merchantdb_postgres.c
@@ -323,7 +323,7 @@ postgres_initialize (void *cls)
               " timestamp<$1"
               " AND merchant_pub=$2"
               " ORDER BY timestamp DESC, row_id DESC"
-              " FETCH FIRST $3 ROWS ONLY",
+              " LIMIT $3",
               3);
 
   PG_PREPARE (pg,
@@ -338,7 +338,7 @@ postgres_initialize (void *cls)
               " AND merchant_pub=$2"
               " AND row_id<$3"
               " ORDER BY timestamp DESC, row_id DESC"
-              " FETCH FIRST $4 ROWS ONLY",
+              " LIMIT $4",
               4);
 
   /* Setup prepared "SELECT" statements */

-- 
To stop receiving notification emails like this one, please contact
address@hidden