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 5151B89D.8060902@tpf.co.jp
Whole thread Raw
In response to Re: SQLExecute returns 0 rows with BoolsAsChar=1  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: SQLExecute returns 0 rows with BoolsAsChar=1
List pgsql-odbc
(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.

regards,
Hiroshi Inoue


Attachment

pgsql-odbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: SQLExecute returns 0 rows with BoolsAsChar=1
Next
From: Hiroshi Inoue
Date:
Subject: Re: SQLExecute returns 0 rows with BoolsAsChar=1