Skip site navigation (1) Skip section navigation (2)

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

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1010431 ] Bug in PGAPI_ExtendedFetch()
Date: 2008-07-15 12:24:33
Message-ID: 20080715122433.98C3917AD22E@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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

pgsql-odbc by date

Next:From: Duffey, Blake A.Date: 2008-07-21 20:19:53
Subject: SSPI/Kerberos support on Windows 2008
Previous:From: Nick DavisDate: 2008-07-01 19:39:44
Subject: Function sequence error when executing DELETE with 08.03.0200

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group