Re: UseServerSidePrepare and data-at-execution - Mailing list pgsql-odbc

From Heikki Linnakangas
Subject Re: UseServerSidePrepare and data-at-execution
Date
Msg-id 5215B49C.7000605@vmware.com
Whole thread Raw
In response to Re: UseServerSidePrepare and data-at-execution  ("Inoue, Hiroshi" <inoue@tpf.co.jp>)
List pgsql-odbc
On 22.08.2013 02:50, Inoue, Hiroshi wrote:
> (2013/08/15 22:43), Heikki Linnakangas wrote:
>> The test case executes a SELECT statement twice, using data-at-execution
>> parameters (ie. SQLParamData and SQLPutData) and array binding together.
>> In that combination, the server logs confirm that the query is executed
>> twice with different parameters, but only the first result is returned
>> to the client.
>>
>> After some debugging, I came up with the attached patch. It clears the
>> curr_param_result flag from the statement object, in SQLParamData, after
>> executing the statement with the current set of parameters.
>
> Oops I overlooked this case.
> Yes the curr_param_result flag must be cleared before excecuting
> the subsequent set of parameters.

Ok then, I committed the patch. Thanks!

- Heikki


pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: Removing support for < 7.4 servers
Next
From: Heikki Linnakangas
Date:
Subject: Re: UseServerSidePrepare default