SQLGetDiagRec should not clear error.

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: SQLGetDiagRec should not clear error.
Date: 2014-04-10 19:01:30
Message-ID: 5346EA8A.5080902@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

A colleague of mine pointed out that calling SQLGetDiagRec on a
connection, after the connection has failed, clears the current error.
The consequence is that if you call SQLGetDiagRec twice, and the first
call returns an error, the second call might return no error. According
to the ODBC spec:

> Calls to SQLGetDiagRec are nondestructive to the header and record
> fields. The application can call SQLGetDiagRec again at a later time to
> retrieve a field from a record as long as no other function, except
> SQLGetDiagRec, SQLGetDiagField, or SQLError, has been called in the interim.

Digging into the commit log, the code line that clears the error message
in CC_get_error has been there since the very first commit.

I pushed a patch to fix that, removing the line in CC_get_error that
clears the error number. I also added a regression test that
demonstrates the issue.

- Heikki

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Michael Paquier 2014-04-10 23:43:55 Re: SQLGetDiagRec should not clear error.
Previous Message Barry Bell 2014-04-07 12:28:19 Re: FW: ODBC 9.3.0210 not commiting, Discard ALL