[pgpool-general: 9454] Re: Clarification on query results cache visibility

[Tatsuo Ishii]

> update : the bug (this new bug) is not present prior to the first
> patch. So the bug (the new one) is not present in plain vanilla :
> pgpool-II-4.6.0 . Reverting both patches solves the issue with the new
> bug which has most probably to do with an array function called
> "first" :

"first" is coming with the extension? I am not familiar with it.

> select defid, description from machdefs where first(parents)=214766150
> order by description;
> 
> I haven't been able to reproduce with SQL (from psql).

Is it possible for you to create a java reproducer?

> Also reverting both patches, i.e. going back to plain vanilla
> pgpool-II-4.6.0 solves this new bug, but re-introduces the previous (
> with seeing stale and data and not invalidate data on table
> testpgpool)
> 
>>>>
>>>>>
>>>>> Best regards,
>>>>> -- 
>>>>> Tatsuo Ishii
>>>>> SRA OSS K.K.
>>>>> English: http://www.sraoss.co.jp/index_en/
>>>>> Japanese:http://www.sraoss.co.jp
>>>> _______________________________________________
>>>> pgpool-general mailing list
>>>> pgpool-general at pgpool.net
>>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>>
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general