Re: SQLExecute returns 0 rows with BoolsAsChar=1

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-03-29 13:51:39
Message-ID: 51559C6B.5000006@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
parse_execute.patch text/x-patch 12.2 KB

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message blegay 2013-04-05 03:48:57 Re: psqlodbc 09.01.0200 - OS X 10.6 - memory leak ?
Previous Message Hiroshi Inoue 2013-03-26 15:02:53 Re: SQLExecute returns 0 rows with BoolsAsChar=1