installcheck fails when compute_query_id=on or pg_stat_statsement is loaded - Mailing list pgsql-hackers

From Мельников Антон Андреевич
Subject installcheck fails when compute_query_id=on or pg_stat_statsement is loaded
Date
Msg-id 1634283396.372373993@f75.i.mail.ru
Whole thread Raw
Responses Re: installcheck fails when compute_query_id=on or pg_stat_statsement is loaded  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-hackers
Hello!
 
When extension  pg_stat_statsement is loaded into memory or compute_query_id=on in postgesql.conf
many of installcheck tests give errors.
The thing is that in *.out files appear lines "queryid = xxxxx" where xxxxx - some numeric value.
So 24 of 209 installcheck tests will fail.
It seems to be a normal behaviour as queryid calculation was moved into core in 
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=5fd9dfa5f5 
but tests say that something wrong.
Create test variants is not the way, as queryid value varies randomly 
from test to test at the same enviroment.
I think this is a problem because these fake errors can mask a real errors in relevant tests.
What’s your opinion?
 
Best regards,
Anton Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
 
 

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Partition Check not updated when insert into a partition
Next
From: Andrew Bille
Date:
Subject: Re: [Proposal] Global temporary tables