Re: Problem with Use Declare/Fetch

Hi Alexandre,

(2012/04/10 8:25), Alexandre - Aldeia Digital wrote:
> Hi Hiroshi,
>
> Sorry for delay!
>
> I sent the links to download the logs directly in your e-mail.
> I analyzed the logs and I believe that the error was in this cursor:
>
> [1168-47.972] stmt_with_params = 'declare "P00954" cursor for SELECT
> T1.Fn04CodEmp(...)
>
> This query must return about 14k rows. But with use/declare fectch (in
> this case, cache size = 10), returns only 10 rows.

It seems OK to me. Psqlodbc driver fetches tuples using extended query
other than the 1st fetch. You can see the following lines in many
places

SendExecuteRequest: plan_name=P00954 count=10

and the query returns 14725 tuples as a result.

[1168-332.835]end of tuple list -- setting inUse to false: this =
083A0810 SELECT 5
ELECT 5
[1168-332.835]_QR_next_tuple: 'C' fetch_total = 14725 & this_fetch = 5

> I don't search in other areas, but if you need I can do this.
>
> Another doubt: My Rollback on erros is set to Transaction. But I can see
> some SAVEPOINT/RELEASE statements. It's normal ?

Yes the driver uses savepoint/rollback in some internal queries.

regards,
Hiroshi Inoue