From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: SQLExecute returns 0 rows with BoolsAsChar=1 |
Date: | 2013-04-25 21:10:57 |
Message-ID: | 51799BE1.7000703@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2013-04-26 08:09:05 | Re: psqlODBC website face-lift |
Previous Message | Heikki Linnakangas | 2013-04-25 12:24:50 | Re: Regression with no results returned from query between 9.01.01 and 9.01.02 |