[ 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
numberof 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
numberof lines requested. 


best regards

Kai

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

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