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 51799BE1.7000703@tpf.co.jp
Whole thread Raw
In response to Re: SQLExecute returns 0 rows with BoolsAsChar=1  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-odbc
(2013/04/25 0:42), Heikki Linnakangas wrote:
> 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.

Thanks.
I'm examing the report from Jack Wilson.
Probably I can reproduce his case now.

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Regression with no results returned from query between 9.01.01 and 9.01.02
Next
From: Dave Page
Date:
Subject: Re: psqlODBC website face-lift