[ psqlodbc-Bugs-1010431 ] Bug in PGAPI_ExtendedFetch()

Bugs item #1010431, was opened at 2008-07-15 14:24
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010431&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Kai Henning (kai_khcyt)
Assigned to: Nobody (None)
Summary: Bug in PGAPI_ExtendedFetch()

Initial Comment:
PostgreSQL 8.3.3
PostgreSQl ODBC Driver 08.03.0200

IMHO is an bug within the function PGAPI_ExtendedFetch() (file result.c). This error is occur when query a rowset with number of n rows (n >1) and SQL_ATTR_ROW_ARRAY_SIZE is greater than 1 an less than n (in second and subsequent calls of PGAPI_ExtendedFetch() via SQLFetch()/ SQLFetchScroll()).

starting with the line 1482

switch (fFetchType)
{
case SQL_FETCH_NEXT:
...

else
SC_inc_rowset_start(stmt, progress_size); <-- line 1515

should be changed to
SC_inc_rowset_start(stmt, stmt->last_fetch_count);

because the offset to determine the following rows depends on the number of previously retrieved rows, but not on the number of lines requested.

best regards

Kai

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010431&group_id=1000125