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

[Tatsuo Ishii]

>> On 5/4/25 05:55, Achilleas Mantzios wrote:
>> 
>>> On 4/5/25 06:42, Tatsuo Ishii wrote:
>>>
>>>> Achilleas,
>>>>
>>>> Please disregard the patch. I think I have an oeversight with the
>>>> patch.
>>>
>>> Good Day Tatsuo. Thank you for all your work!
>>>
>>> I will wait !
>> 
>> Dear Tatsuo ,
>> 
>> I happy to say to you that I finally came up with a valid test that
>> reproduces the 2nd bug (with the INSERT and the BIND), so I have this
>> java program, which will fail exactly after "preparedThreshold"
>> iterations!
>> 
>> This is supposed to be run against the 4.6.0 version with the
>> query_cache-v2.patch applied.
>> 
>> the table looks like :
>> 
>> CREATE TABLE testarr(id bigserial primary key, parents int[], descr
>> text);
>> postgres@[local]/dynacom=# \d testarr
>>                              Table "public.testarr"
>> Column  |   Type    | Collation | Nullable |               Default
>> ---------+-----------+-----------+----------+-------------------------------------
>> 
>> id      | bigint    |           | not null |
>> nextval('testarr_id_seq'::regclass)
>> parents | integer[] |           |          |
>> descr   | text      |           |          |
>> Indexes:
>>    "testarr_pkey" PRIMARY KEY, btree (id)
>> 
>> postgres@[local]/dynacom=#
>> 
>> As with with the first program pls put the class inside a dir called
>> "test", then from the parent :
>> 
>> achill at smadevnu:~/workspace/pgpoolbugII/bin % ls
>> test
>> achill at smadevnu:~/workspace/pgpoolbugII/bin % ls test/
>> PgPoolTestII.class
>> achill at smadevnu:~/workspace/pgpoolbugII/bin %
>> 
>> run
>> 
>> java -cp ":/home/achill/SQL/postgresql-42.7.5.jar" test.PgPoolTestII
>> localhost 9999 dynacom username passwd
> 
> Great! I will give it a try.

Unfortunately the java program needs functions I don't have.

PreparedStatement stidxINS = con.prepareStatement("insert into testarr(parents,descr) VALUES((SELECT intarray_push_array(itoar(?),coalesce((select parents from testarr where id=?),'{}'::integer[]))),?)");

It seems it requires itoar() and intarray_push_array(), which I don't have.

Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp