Re: SQLExecute returns 0 rows with BoolsAsChar=1 - Mailing list pgsql-odbc

From Heikki Linnakangas
Subject Re: SQLExecute returns 0 rows with BoolsAsChar=1
Date
Msg-id 5177FD71.3030508@vmware.com
Whole thread Raw
In response to Re: SQLExecute returns 0 rows with BoolsAsChar=1  (Hiroshi Inoue <inoue@tpf.co.jp>)
Responses Re: SQLExecute returns 0 rows with BoolsAsChar=1  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
On 29.03.2013 15:51, Hiroshi Inoue wrote:
> (2013/03/27 0:02), Hiroshi Inoue wrote:
>> (2013/03/25 20:44), Heikki Linnakangas wrote:
>>> On 24.03.2013 12:07, Hiroshi Inoue wrote:
>>>> I can reproduce it now when I turn off the *Server side prepare* option
>>>> or turn on the *Use Declare/Fetch* option.
>>>
>>> Ah yeah, UseServerSidePrepare hides it. I'm also seeing the problem
>>> without UseDeclareFetch, though.
>>>
>>>> Attached is a patch to fix the bug.
>>>
>>> Thanks. I must admit I don't understand how this works. Also, the 2nd
>>> test case in attached file now fails. It does a DELETE ... RETURNING,
>>> binding a parameter array with a VARCHAR(5) column, and fetches the
>>> results. With the patch, it can't fetch the result sets.
>>
>> Thanks for the test case.
>> The attached patch instead of the previous one would fix the problem
>> but still has a problem when the server side prepare option is turned
>> on.
>
> OK attached is a patch to fix the problem with the *Server side
> Prepare* option.

Many thanks! Although I still don't fully understand the fix, I
committed that with minor copy-editing.

- Heikki


pgsql-odbc by date:

Previous
From: Dave Page
Date:
Subject: Re: psqlODBC website face-lift
Next
From: "Marc G. Fournier"
Date:
Subject: Re: psqlODBC website face-lift