From 8a7a9223bde79d423dc25f9c34918d0d380a34e0 Mon Sep 17 00:00:00 2001 From: Dave Page Date: Mon, 5 Apr 2004 13:07:08 +0000 Subject: [PATCH] Fix for invalid input syntax for type tid: '(,)' - Jose' Cruanyes --- convert.c | 4 ++-- results.c | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/convert.c b/convert.c index da8818b..b8a0e5e 100644 --- a/convert.c +++ b/convert.c @@ -2115,7 +2115,7 @@ copy_statement_with_parameters(StatementClass *stmt, BOOL buildPrepareStatement) * 1st query is for field information * 2nd query is keyset gathering */ - CVT_APPEND_STR(qb, " where ctid = '(,)';select ctid, oid from "); + CVT_APPEND_STR(qb, " where ctid = '(0,0)';select ctid, oid from "); CVT_APPEND_DATA(qb, qp->statement + qp->from_pos + 5, npos - qp->from_pos - 5); } } @@ -2158,7 +2158,7 @@ inner_process_tokens(QueryParse *qp, QueryBuild *qb) qb->load_stmt_len = qb->npos; if (0 != (qb->flags & FLGB_KEYSET_DRIVEN)) { - CVT_APPEND_STR(qb, "where ctid = '(,)';select CTID, OID from "); + CVT_APPEND_STR(qb, "where ctid = '(0,0)';select CTID, OID from "); CVT_APPEND_DATA(qb, qp->statement + qp->from_pos + 5, qp->where_pos - qp->from_pos - 5); } } diff --git a/results.c b/results.c index a79c097..3b39472 100644 --- a/results.c +++ b/results.c @@ -1848,7 +1848,7 @@ positioned_load(StatementClass *stmt, UInt4 flag, UInt4 oid, const char *tidval) sprintf(selstr, "%s where ctid = '%s' and oid = %u", stmt->load_statement, tidval, oid); } else if ((flag & USE_INSERTED_TID) != 0) - sprintf(selstr, "%s where ctid = currtid(0, '(,)') and oid = %u", stmt->load_statement, oid); + sprintf(selstr, "%s where ctid = currtid(0, '(0,0)') and oid = %u", stmt->load_statement, oid); else sprintf(selstr, "%s where oid = %u", stmt->load_statement, oid); -- 2.39.5