[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[GNUnet-SVN] [taler-merchant] branch master updated: FETCH FIRST arg ROW
From: |
gnunet |
Subject: |
[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. |
Date: |
Fri, 17 Mar 2017 21:10:58 +0100 |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [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 <=