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

From Hiroshi Inoue
Subject Re: SQLExecute returns 0 rows with BoolsAsChar=1
Date
Msg-id 51559C6B.5000006@tpf.co.jp
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
List pgsql-odbc
(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.

regards,
Hiroshi Inoue


Attachment

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: SQLExecute returns 0 rows with BoolsAsChar=1
Next
From: blegay
Date:
Subject: Re: psqlodbc 09.01.0200 - OS X 10.6 - memory leak ?