Re: Problem with Use Declare/Fetch

Hi Hiroshi,

Em 11-04-2012 10:38, Hiroshi Inoue escreveu:
> 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
>


Very strange. I will try again and send you the results.


>> 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.

Ok.

> regards,
> Hiroshi Inoue

Best regards,

Alexandre